How would this done with SQL Server
----- Original Message ----- From: "Wally - Comcast" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, June 26, 2002 4:54 PM Subject: Re: getting auto id > Ray, > Oracle uses a structure called a Sequence number to generate the equivalent > of the auto number in Access. An Oracle sequence number always returns a > unique number when invoked. For example if the Sequence number is > CustomerID then the following statement will generate a unique key: > INSERT into CUSTOMER (Customer_Key, Customer_Name) values > (CustomerID.Nextval, 'John Smith'); > > After the insert call you can issue the following select statement which > will return the last value YOU obtained from the Sequence: > SELECT CustomerID.CurrentVal FROM DUAL; > (DUAL is a dummy table Oracle uses to permit the return of this kind of > strange select value). > > ----- Original Message ----- > From: "Ray Bujarski" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, June 26, 2002 3:55 PM > Subject: getting auto id > > > > I am using oracle and am running into an issue. I have a relation that I > > need to get the id value for a record that was just inserted. I am using > a > > trigger to insert the sequence value into ID field of the parent table. > > However, I need to use this same ID for a relation. Does anyone know how I > > can return this value back to the cold fusion application server for use > in > > my relation insertion? > > > > Ray Bujarski > > 858-845-7669 > > 858-636-9900 pgr > > [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
