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