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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
