not as a single operation, perhaps you could tell us a little more about what you are trying to accomplish?
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, September 15, 2003 4:07 PM To: SQL Subject: insert/select 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:> Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
