nope...Oracle is sequences....and I hate sequences ;-) Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Allaire Alliance Partner www.allaire.com
----- Original Message ----- From: "Andrew Scott" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 02, 2002 8:32 PM Subject: RE: Database AutoNum column > Doesn't oracle support @@identity? > > > > -----Original Message----- > From: Tony Schreiber [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 3 January 2002 3:19 PM > To: CF-Talk > Subject: Re: Database AutoNum column > > Not directly. But you can create a SEQUENCE. Then you use the value from > that sequence in your query: > > INSERT INTO table > (pk,value,value) > VALUES > (sequencename.nextval,'value','value') > > (What I DON'T know how to do is use that same value in subsequent > queries > without selecting it from the table I just inserted...) > > > Is there an autonum feature in oracle 8i, if so how do I define it? > > > > Thanks > > Sam > > > > > > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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