are you using a stored proc for sql statement? if so just make an out var in your proc, and set your seqeunce value equal to it. then in your cf code use a cfprocparam of type out and you can reference the variable with a proc_name.var_name
Steven D. Dworman Certified Macromedia Developer -------------------------------------------- Web Consultant Systems Administrator phone: 248.647.8841 cell : 248.767.9925 -------------------------------------------- Comspec International Empower-XL Software for Higher Education http://www.ComspecInternational.com ----- 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
