Not in an Access DB
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 05 April 2001 16:01
To: CF-Talk
Subject: Re: update
I try to pass all needed info to a stored procedure and handle all database
work there ... but Becky's method appears to me as ... well clunky.
Can't you just pass a SQL batch something like this in CF:
SQLQuery = "INSERT INTO foo (x) VALUES('x')""
SQLQuery = "SET NOCOUNT ON " & SQLQuery & " Select id = @@Identity SET
NOCOUNT OFF"
Execute the query and and have as a result the Identity value?
Cheers,
Bill
In a message dated 4/5/01 10:27:27 AM Eastern Daylight Time,
[EMAIL PROTECTED] writes:
> Becky see http://www.allaire.com/Handlers/index.cfm?ID=1463&Method=Full
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
