Printable View
Hi. I want to select an item in a list box generated from a database. I want to send a request to the database and reload the same page based on the selected item. At present, I am calling a new ASP file by sending the selected item as a parameter. Can this be done?
Yes, this can be done quite easily.
Select the Primary key of the record as the value and the ListBox Item as the name with an onchange event. Have your ASP page instantiate a stored proc, or build the SQL dymanically from ASP, and select your recordset based off the Key value. If you use DRI vs. Triggers, then you can walk the indexes and receive more responsive query performance.
HTH-
------------
Tosha at 12/7/00 10:51:35 AM
Hi. I want to select an item in a list box generated from a database. I want to send a request to the database and reload the same page based on the selected item. At present, I am calling a new ASP file by sending the selected item as a parameter. Can this be done?