The last problem I had was runnign query a query on a recordset returned via oledb, all the sql BIT fields were coming back as 'Yes' and 'No' as oppossed to 0/1.
-----Original Message----- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: 11 December 2001 14:28 To: CF-Talk Subject: RE: ODBC or OLE DB I'm curious as to what differences you've found as I've used both interchangeably without any problems whatsoever. Could you possibly enumerate the differences for the benefit of the list. Cheers, Steve > OLEDB handles dates and boolean fields slightly differently at times > (perhaps other data types too?), converting sites that use > ODBC can be a > pain. > > I've used both quite bit, and still don't have a preference. > If I was trying > to decide which to use for a new site, then I would probably > go with ODBC as ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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