Forums

This topic is locked

Pass Variable into Recordset

Posted 14 Feb 2006 23:11:02
1
has voted
14 Feb 2006 23:11:02 daniel avila posted:
Hello, I have a menu/list which contains four values.

I need for the user to select a value from the list, press "GO" button and then have my query :
SELECT * FROM JOBS

be run but filtered by the value the user selected from the menu/List

any ideas?

Thanks



Replies

Replied 06 Jan 2008 23:02:30
06 Jan 2008 23:02:30 David Soros replied:
Did you have you had any luck??? I'm trying to put the value from a select field into a session variable.
Replied 08 Jan 2008 07:20:54
08 Jan 2008 07:20:54 Javier Castro replied:

Try this:
SELECT * FROM JOBS

under parameters you add the
name: whatever
Type: numeric or text depending on your type of query
value: Request.QueryString("Selectname"
Default value: 0

hope it helps

Reply to this topic