Well, the issues we face are more platform-centric than anything. We're running CF 5.0 on Win2000 and our Oracle 8x sits on an IBM OS/390. The issue is that with the native drivers, numeric and datefields must be set to TO_CHAR() in the SQL to output them in CF. You can add/update/delete without that, but your SELECT must have those datatypes to_char'd to read out. I contacted MM's tech support about it at the DevCon2001 and they're looking into it. That's really the only issue. ODBC works fine without the to_char issue.
Dave ----- Original Message ----- From: "Alex" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 11:13 AM Subject: Re: Oracle and CF What are the "some small issues"? On Thu, 29 Nov 2001, Dave Hannum wrote: > We use Oracle here both with Native drivers and with ODBC. Works great! > (mostly - some small issues) > > Dave > > > ----- Original Message ----- > From: "Jason Dowdell" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Thursday, November 29, 2001 10:39 AM > Subject: Oracle and CF > > > Hi all, > > Being a former Oracle employee I'm fairly familiar > with Oracle but I've yet to use it with CF. What > are some of the limitations versus SQL Server? > I've heard that the Oracle drivers only return > one record in a query result set at a time. Is > this true. What are some of the other drawbacks > and or advantages? > > Thanks in advance, > Jason > > > -- > --------------------------------- > Jason Dowdell > CF_Developer > e-mail: [EMAIL PROTECTED] > --------------------------------- > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
