you can update and then create a trigger to select the record that was updated.
Shlomy -----Original Message----- From: Craig Dudley [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 11:07 AM To: CF-Talk Subject: RE: Is this SQL trick possible erm, can't you do the update and a select in the same cfquery block? If your'e using SQLserver u can anyway, as long as the cfquery only returns one recordset, e.g. ----------------- <cfquery name=test datasource="#request.dsn#"> begin transaction update tblTable set value1=1 where id=1; select value1 from tblTable where id=1; commit transaction </cfquery> <cfoutput>#test.value1#</cfoutput> ----------------- That's crappy example and a bit pointless, but you should understand what I'm getting at. -----Original Message----- From: Robert Everland [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 15:58 To: CF-Talk Subject: Is this SQL trick possible Is there anyway I can get the value of a field that I update without having to do a query first. Robert Everland III Dixon Ticonderoga ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists