Forums
This topic is locked
Dynamic Text Drop Down Menus
Posted 12 Aug 2002 18:18:18
1
has voted
12 Aug 2002 18:18:18 Peter Lent posted:
Hi All,Is there an extension or tutorial that shows haow to create dynamic, data base driven drop down menus?
THANKS
-Peter
Replies
Replied 12 Aug 2002 20:16:48
12 Aug 2002 20:16:48 aegis kleais replied:
I'm sure there's a tutorial, but they're rather easy to make.
Create a recordset that you want to populate the Dropdown with.
Click the Dropdown box and edit the list.
For the first value, click on the dynamic lightning bolt and select the recordset then field you want to display in the list.
Then in the second column, hit the lightning bolt again and pick the field that sets the value. And boom, for as many records as you have in the recordset, you'll have listed in the dropdown.
ie, if you want fldName to show but the value of the selection be their address (fldAddress) it would show
Aaron
Bob
Chris
Mark
But when you select the name, the value passed to the system will be their respective addresses.
Otherwise, you can use fldName for both the display and the value so that selecting Aaron sends "Aaron" and so on.
Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])
Create a recordset that you want to populate the Dropdown with.
Click the Dropdown box and edit the list.
For the first value, click on the dynamic lightning bolt and select the recordset then field you want to display in the list.
Then in the second column, hit the lightning bolt again and pick the field that sets the value. And boom, for as many records as you have in the recordset, you'll have listed in the dropdown.
ie, if you want fldName to show but the value of the selection be their address (fldAddress) it would show
Aaron
Bob
Chris
Mark
But when you select the name, the value passed to the system will be their respective addresses.
Otherwise, you can use fldName for both the display and the value so that selecting Aaron sends "Aaron" and so on.
Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])