Empty Recordset problem

[slechols]

I have some code where I am populating a drop down box using dynamic variables. "Selection" could be one of four options, depending on which previous drop down box was selected, and "criteria" is the variable selected from that drop down box. The session variables are populated correctly, but it is retrieving an empty recordset. Am I coding this correctly? Thanks in advance.

criteria=Session("criteria&quot
selection=Session("selection&quot
strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("scrubbed.mdb&quot
set conn = server.createobject("adodb.connection&quot
set rs2= server.createobject("adodb.recordset&quot
conn.open strconn
strsql="Select nsn from scrubbed_data where '"& selection &"' = '"& criteria &"' order by nsn;"
rs2.open strsql, conn, 2, 2

 

[webspy]

the error is in ur query
remove the single codes from the search field variable
even u put that in run time. u need not put the single codes for the fiedls.u must put single codes for the search variables
other wise everything is correct
here the corrected query for u

strsql="Select nsn from scrubbed_data where "& selection &" = '"& criteria &"' order by nsn"
rs2.open strsql, conn, 2, 2

try this and make ur program execute successful
with regards
raghu(webspy)