All my bit fields come back as 1/0 both in OLEDB and ODBC. All my date fields are treated the same. Text (VC, Text, etc.) fields, no probs. Numerics - all OK
Anyone out there actually KNOW of any fundamental differences on the SQL interface level? > -----Original Message----- > From: Craig Dudley [mailto:[EMAIL PROTECTED]] > Sent: 11 December 2001 14:51 > To: CF-Talk > Subject: RE: ODBC or OLE DB > > > 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
