Which SQL Function?

myself · July 3rd, 2006, 07:15 AM

Hello,
I have a form with 2 list menus: minAge & maxAge.

On my results page, I want to 'filter' out people whose AGE falls between the two (>= minAge & <=maxAge).

Do I use the BETWEEN or the 'AND OR' SQL function. EG:

myMin = CInt(Request("minAge"))
myMax = CINT(Request("maxAge"))
mySQL = "SELECT * From tblstaff WHERE BrAge BETWEEN '" & myMin & "' AND '" & myMax & "'"

Hope to hear (& is this the better way?)
TIA.

Dj Kat · July 3rd, 2006, 09:29 AM

Hi,

The BETWEEN operator is fine if you want yo use it. The AND is good to
I've noticed you used the single quote this is not needed because it myMin and myMax are numbers

The Between operator

Code:

' The Between operator
mySQL = "SELECT  * From  tblstaff WHERE  BrAge BETWEEN  " & myMin & " AND  " & myMax

Using AND only

Code:

' The Between operator
mySQL = "SELECT  * From  tblstaff WHERE  BrAge >= " & myMin & " 
AND  BrAge <=" & myMax

the only thing you can't use is OR

__________________________________________________ ________
This is my junk I'm gona eat it

myself · July 3rd, 2006, 09:53 AM

Thank you.
That makes sense now!