SQL Not Working

myself · July 29th, 2006, 01:50 AM

The following SQL does not work:

Code:

myMin = CInt(Request("minAge"))
myMax = CInt(Request("maxAge"))

mySQLb = "SELECT * From tbl_bro WHERE BrAge >='" & myMin & "' AND BrAge <='" & myMax & "'"

AND

mySQLb = "SELECT * FROM tbl_bro WHERE  BrAge BETWEEN " & myMin & " AND " & myMax & ";"

But this works:

Code:

mySQLb = "SELECT * FROM tbl_bro WHERE  BrAge BETWEEN 18 AND 50"
myRS.Open mySQLb, myCon

Anything obvious?

dparsons · July 29th, 2006, 06:57 AM

Are your variables actually getting assigned a value?

"The one language all programmers understand is profanity."

myself · July 29th, 2006, 07:47 AM

Hmmm...

Tried it:

Code:

<%= myMin %>
&
<%= myMax %>

And the VALUES come through OK.

itHighway · August 5th, 2006, 08:29 AM

Check 'BrAge' Field type in database. If it is a numeric field then use following sql

mySQLb = "SELECT * From tbl_bro WHERE BrAge >=" & myMin & " AND BrAge <=" & myMax
AND

mySQLb = "SELECT * FROM tbl_bro WHERE BrAge BETWEEN " & myMin & " AND " & myMax

Hope this helps