Yes/No Data Type

[mbutler55]

Ok gurus -
In a field that is defined as "Yes/No" in Access, how do I make a comparison in ASP? Example:
sql = "SELECT INVEST, REF1CODE, NEWAC1 From AblProc WHERE REF1CODE='2AC20' AND NEWAC1='Yes';"

Having NEWAC1='Yes' gives "Data type mismatch in criteria expression." error message.
In the database the information is stored as -1 for Yes and 0 for No so I tried
sql = "SELECT INVEST, REF1CODE, NEWAC1 From AblProc WHERE REF1CODE='2AC20' AND NEWAC1='-1';"

That also gave the same error message.

Any help is GREATLY appreciated!

 

[swampBoogie]

sql = "SELECT INVEST, REF1CODE, NEWAC1 From AblProc WHERE REF1CODE='2AC20' AND NEWAC1"

 

[onpnt]

true / false _________________________________________________________
for the best results to your questions: FAQ333-2924
Is your question a most FAQ?? Find out here FAQ333-3048

http://www.onpntwebdesigns.com/aspTut4.asp