Forums
This topic is locked
Drop Down Results help
28 Jan 2003 23:41:35 ipaq CE posted:
Hi I created 2 Dropdown Menus (Parent & Child DropDown menu)
When ever I select child dropdown my results shows everything. How can I just show of what I have selected from the Child dropdown menu selections?
Can any give me how the SQL qurries to write for this? Below is my SQL what I have written for the results page.
--------------------------
SELECT grouptype, childvalue, childname, groupid
FROM child_table, parent_table
WHERE grouptype LIKE 'vargrouptype%' AND childvalue LIKE 'varchildvalue%' AND groupname LIKE 'varchildname%' AND groupid LIKE 'vargroupid%'
vargrouptype % Request.Form("grouptype"

varchildvalue % Request.Form("childvalue"

varchildname % Request.Form("childname"

vargroupid % Request.Form("groupid"

--------------------
Again I only want to get a results of what I have selected and not the whole results.
Thanks
Replies
Replied 29 Jan 2003 12:26:27
29 Jan 2003 12:26:27 Rafi Mellado replied:
Is this what you're looking for?
www.macromedia.com/support/ultradev/ts/documents/client_dynamic_listbox.htm
"If it weren't for the last minute, nothing would get done."
www.macromedia.com/support/ultradev/ts/documents/client_dynamic_listbox.htm
"If it weren't for the last minute, nothing would get done."