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