Double search criteria

[MetroToday]

I am having trouble with SQL when I want to check two text boxes. It gives me a syntax error. Below is the code that I have.

(All in one line)
oRS.open "SELECT * FROM tbldata WHERE DealNum=" & Request.Form("Deal&quot AND WHERE Sequence=" & Request.Form("Sequence&quot , "DSN=WiresASP"

 

[kdelacruz]

You need to have
'& " '
before the "Request.Form("Deal&quot" in your SQL statement

oRS.open "SELECT * FROM tbldata WHERE DealNum=" & Request.Form("Deal&quot & " AND WHERE Sequence=" & Request.Form("Sequence&quot , "DSN=WiresASP"

 

[Tarwn]

You may also want to remove the second where from the statement:

oRS.open "SELECT * FROM tbldata WHERE DealNum=" & Request.Form("Deal") & " AND Sequence=" & Request.Form("Sequence") , "DSN=WiresASP"

If DealNum is a string value in the db, than you need the single quotes like mentioned above:

oRS.open "SELECT * FROM tbldata WHERE DealNum='" & Request.Form("Deal") & "' AND Sequence=" & Request.Form("Sequence") , "DSN=WiresASP"

If Sequence is a string you would need single quotes on that:

oRS.open "SELECT * FROM tbldata WHERE DealNum=" & Request.Form("Deal") & " AND Sequence='" & Request.Form("Sequence")&"'" , "DSN=WiresASP"

Like so.

I'm assuming you can figure out the both by yourself, I only reposted the single quotes issue to make sure you didn't doubt it from the previous post and assume removal of the extra where would do it for you (for whatever reason).
-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
For my next trick I will pull a hat out of a rabbit (if you think thats bad you should see how the pigeon feels...)