With the Yes/No fields, zero represents a No/False value, any non-zero value
represents a Yes/True value.
Therefore, a value of 1 or -1 mean the same thing.
When dealing with the Yes/No field (or any boolean field), you should be
checking for True/False. Leave the details of the values to the system
(like it was designed to do).
(there are exceptions of course, such as if you use a char(1) field to hold
a Y or N value for boolean purposes).
My two cents worth.
Shawn Grover
-----Original Message-----
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 9:22 AM
To: CF-Talk
Subject: RE: weird behaviour using yes/no field in Access
Just a guess.
Have you recently installed a newer version of MDAC?
-----Original Message-----
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 04, 2001 11:16 AM
To: CF-Talk
Subject: OT:weird behaviour using yes/no field in Access
Hi I wonder if anyone has come across this before. To set a yes no field in
Access to yes I usually insert a 1, this seems to work. Also when searching
for checked fields, searching for the value 1 for yes/no fields usually
works as well. Of recent I have noticed that this no longer works. I now
need to check for yes with no quotes quotes or minus 1, checking for 1 will
not match checked fields. As I've never had this problem before I'm
wondering if this could possibly have anything to do with CF5 and the
drivers it ships with as this is the only change which has been made to the
site.
Thanks in advance
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
