Is there a way of doing an insert and a select on the data that was just inserted as a single operation inside a CFQUERY tag? Not in an SP, but as straight SQL. If not, I'll have to do the transaction, insert, select thing. I'm just looking for the best option. Thanks
Michael Dinowitz Finding technical solutions to the problems you didn't know you had yet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Get the mailserver that powers this list at http://www.coolfusion.com
