I have a form and a results page. I have everything correct.<BR>When the data returns its returning only the first row of data. But In the sql statement I have a var, but no matter what data is inputed for the var it does not return that record. but the sqltext returns correct. here is my code:<BR><BR><%varStdidID=Request.Form("baID" ) <BR>Dim oRSt<BR>Set oRSt=Server.CreateObject("ADODB.recordset")<BR>sql text="SELECT * FROM Safety_Table1"<BR>sqltext=sqltext& " Where stdid=" & varStdidID & ";"<BR>oRSt.Open "SELECT * FROM Safety_Table1", "DSN=CSCbooks"<BR>Response.Write sqltext<BR>%><BR><BR>the data never changes with the var, why is this happening??