Ah... question: In which version of MDAC does this become broken? I've
been using 1/0, both in setting and in testing boolean (yes/no) fields
in Access for years, thinking that this was the most portable (that is,
compatible with SQL Server) coding technique.
Jim
-----Original Message-----
From: Carlisle, Eric <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Tuesday, September 04, 2001 9:44 AM
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
