My feeling is you are trying to do this:
table x
ID 1 2
1 a c
2 a d
3 b c
You want to select "a" from column 1 and "d" from column 2, so your recordset would be:
2 a d
To accomplish this is simply :
"SELECT * FROM x WHERE 1='" & Request.Form("1") & "' AND 2='" & Request.Form("2") & "'"
If that is, in fact, what you are trying to do and it is not working for you, check the syntax carefully.
If that isn't what you are trying to do, then need more info. Maybe you could post a quick example of what you are trying to do? Or, are you getting an error message?
Edited by dj1811 - 22 February 2005 at 3:17am
Topic Options
Post Options
Thanks(0)
