There are some probs with SQL syntax and autonumbering, but these should be easy for you (if you are used to ANSI SQL then you have to re-learn some syntax - such as adding "schema" dot notation before all table calls and creating server-side auto numbering formats and calling them from the code.
Oracle seems a little more robust than SQL, there are however some problems when loading native and odbc drivers in CF 5.0 on *nix platforms, but if you are not using CF on *nix then I won't bore you with them.... HTH J -----Original Message----- From: Alex [mailto:[EMAIL PROTECTED]] Sent: 29 November 2001 16:14 To: CF-Talk 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
