sql query with variable from asp on same page

[frogggg]

How can I query a recordset to bring back all records where the value = the value of a listbox?
select * from table
where listbox.value = table.field
the sql builder in visual interdev does not understand this.
Do I have to put this in the vbscript code? Please say no.

 

[phuctran]

I don't use Visual InterDev, but the concept is
You have two pages, the first page is used to collect information from user, the second page is used to connect to the database to collect data.
After user clicks on Submit button, the second page will be called and it doesn't know what listbox.value is. You have to get the value of listbox.value then build a SQL statement.

I think you have to write it in your VBscript code.