I believe you can use the Set NoCount On and Set NoCount Off commands in
MS SQL to nest multiple sql commands into the same CF Query.
<CFQUERY name="Insert" DATASOURCE="Datasourcename" dbtype="ODBC">
SET NOCOUNT ON
BEGIN TRAN
INSERT INTO Members (UserName,
CreateDate)
VALUES ('#Left(Form.UserName,
50)#', getdate())
SELECT @@IDENTITY AS NewUserId
COMMIT TRAN
SET NOCOUNT OFF
</CFQUERY>
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On
Behalf Of Ramphal, Ron
Sent: Thursday, January 24, 2002 9:34 AM
To: [EMAIL PROTECTED]
Subject: [KCFusion] Assigning unique ID's
______________________________________________________________________
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives........ http://www.mail-archive.com/[email protected]
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe.................... mailto:[EMAIL PROTECTED]
To Unsubscribe................ mailto:[EMAIL PROTECTED]
