Radicore Forum: How To » Multiple dropdowns in the same record

Home » RADICORE » How To » Multiple dropdowns in the same record

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Multiple dropdowns in the same record [message #989]

Wed, 25 July 2007 13:57

adamsp
Messages: 32
Registered: July 2007

Member

I have several columns in a table that contain codes and require dropdowns. All of the lookups are in a single table (LKUP) with 3 fields: colname, code, text. I can successfully populate a single dropdown using the _cm_getExtraData() in the database class and _cm_getValRep() in the foreign table (LKUP).

I cannot figure out how to get MULTIPLE dropdowns (with different columns with different codes) on a single record. It may be that the _cm_getExtraData() is executed only once ???

The $where parameter on _cm_getExtraData() suggests I can pass a parameter but I cannot determine where I set this parameter ???

How can this be done in Radicore?

Report message to a moderator

Re: Multiple dropdowns in the same record [message #991 is a reply to message #989]

Wed, 25 July 2007 18:19

AJM
Messages: 2347
Registered: April 2006
Location: Surrey, UK

Senior Member

If you want a separate dropdown list on three different columns on the same record then you simply create three separate entries in $this->lookup_data. There is no such limitation as one dropdown per record. You can have as many as you like. Each column has a unique name, and each column can be associated with a different entry in $this->lookup_data. Just because http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq09 shows only one insertion into $this->lookup_data does not mean that you can only have one - it's an array of arrays, so you can have as many as you like.

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

Report message to a moderator

Re: Multiple dropdowns in the same record [message #998 is a reply to message #989]

Thu, 26 July 2007 07:27

adamsp
Messages: 32
Registered: July 2007

Member

Tony, Works perfectly as you advised. As I learn more about the system....very impressed. Razz

Report message to a moderator

Previous Topic:	Accessing my Radicore App for the first time
Next Topic:	RE-Generate PHP Scripts question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Fri Apr 19 05:05:20 EDT 2024

Total time taken to generate the page: 0.00868 seconds