Forums

This topic is locked

Drop Down Results help

Posted 28 Jan 2003 23:41:35
1
has voted
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."

Reply to this topic