Filtering records

[risa hu]

Hi: I need to build an ASP query to search a property size that is
between minimum and maximum values (in two text boxes in a form). Here
is the SQL statement I use:
mysql="select Center_name, Store_name, Address, Phone, Size, Type, APN
from delamo where size >= '"&min& "'"

But when running the code I got an error message "Data type mismatch in
criteria expression."

Do I need to dim both min and mas as numbers? Please help me!
Risa
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Curt_C [MVP]]

are these NUMBER data types? If so lose the ' and '

....where size >= " & minsize & " AND size <= " & maxsize & "....

OR look at the BETWEEN clause of tSQL

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
...Offering free scripts & code snippits for everyone...
---------------------------------------------------------

"risa hu" <an*******@devdex.com> wrote in message
news:#b**************@TK2MSFTNGP11.phx.gbl...

Hi: I need to build an ASP query to search a property size that is
between minimum and maximum values (in two text boxes in a form). Here
is the SQL statement I use:
mysql="select Center_name, Store_name, Address, Phone, Size, Type, APN
from delamo where size >= '"&min& "'"

But when running the code I got an error message "Data type mismatch in
criteria expression."

Do I need to dim both min and mas as numbers? Please help me!
Risa
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!