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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists