oi Jeff!!
<cfquery datasource="#request.dsn#" name="addReports">
SET NOCOUNT ON
insert stuff........
SELECT id = Scope_Identity()
SET NOCOUNT OFF
</cfquery>
------------------------------------
Tuesday, July 8, 2003, 2:19:49 PM, you wrote:
J> I'm using SQL Server, and I'm performing a cfquery and inserting something,
J> then going to another, "success" page and I'd like to pass the ID of the
J> inserted item to the page, but I'm spacing how to do it...
J> Kinda like...
J> <cfquery...insert stuff>
J> </cfquery>
J> <cflocation url=success_page.cfm?ID=#ItemIJustInserted#>
J>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
