That's what I thought, but I wanted to be sure. I'm going to test it out some.
Thanks
> Depends on what DB you are using... This *should* be valid for SQL2k
>
> <CFQUERY NAME="foo" DATASOURCE="bar">
> INSERT INTO foo (bar)
> VALUES ("homer")
>
> SELECT *
> FROM foo
> WHERE fooid = Scope_Identity()
> </CFQUERY>
>
>
>
>
> -----Original Message-----
> From: Michael Dinowitz [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 15, 2003 21:07
> 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:>
Get the mailserver that powers this list at
http://www.coolfusion.com
