General information
Title:
Customizing SQL Recordset Connection
Hi! I'm using Visual Interdev's DTC Recordset Object in my ASP page and it's pretty neat. I assigned the DTC Recordset to a Grid and it works. Now I would like to customize the Recordset's SQL Query to fetch records based on criteria determined by a couple of my variables.
Here's a sample:
session("var1") = first condition criteria
session("var2") = second condition criteria
I entered the following SQL statement at the pane at the General Tab and I got error messages:
select * from users where user_id= & "session(" & "'" & "var1" & "'" & ")" & "AND password=" & "session(" & "'" & "var2" & "'" & ")"
I would appreciate the help. Thanks.
Ariel
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only