to return the ID of the last inserted record, I always use this:

<cfquery datasource="MyDSN" name="GetID>
SELECT @@IDENTITY AS 'ActivityID'
</cfquery>

>I've always found cfupdate/cfinsert to lack flexibility. Stick to
>cfquery.
>
>I haven't seen any CT's to replace the tags btw
>
>Pascal
>
>>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to