You don't have to add the schema to the tables if you are the owner of the tables. Besides, schema dot, as you call it, is common and proper SQL for higher level RDBMS. You can't call it a problem. Perhaps you're comparing Oracle to Access or something - as for autonumbering, you simply create a sequencing table and reference it in your SQL INSERT statement. Very simple.
Dave ----- Original Message ----- From: "James Maltby" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 29, 2001 12:16 PM Subject: RE: Oracle and CF 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
