Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » RADICORE development » Application Development » Problem with two list1 transactions on one table
Re: Problem with two list1 transactions on one table [message #1540 is a reply to message #1538] Tue, 12 August 2008 19:26 Go to previous messageGo to previous message
AJM is currently offline  AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK
Senior Member
You don't need two tables, and you don't even need all that code. There is a perfect example of what you want already built into the MENU system, as described in http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq50.

For this you will need a single LIST1 control script which is accessed by two separate tasks, with different values in the Selection (fixed) field, such as:

player(list1) => pers_type='player'
coach(list1) => pers_type='coach'

This means that although the same script is being run it will have different values in the $where string at runtime, so no need for any code in the '_cm_pre_getData()' method.

Both of these tasks can use the same ADD1 task on the navigation buttons as it will be passed the contents of the $where string and automatically load that value into the screen and set it to 'noedit' so that it cannot be modified.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]
 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Help/suggestions with record filtering by user
Next Topic: $where clause problem with list1 and read
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ] [ PDF ]

Current Time: Wed Jul 09 19:42:00 EDT 2025

Total time taken to generate the page: 0.00929 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.2.0.
Copyright ©2001-2025 FUDforum Bulletin Board Software