Well, actually you can cheat with MS SQL Server, like this:
<cfquery>
set nocount on
INSERT username, password...
INSERT userdetails ...
set nocount off
</cfquery>
"nocount on" supresses the message that SQL server sends to the client
saying "query complete"; this tricks CF into allowing the second query (or
however many you want) to run.
I've done this with CF 4.0x and SQL 6.5.
All that said, in many cases a stored procedure would be a better solution.
-----Original Message-----
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 9:57 AM
To: '[EMAIL PROTECTED]'
Subject: RE: <cfinsert> & <cfquery>
you can't, not without a stored procedure.
you might want to look into doing it in two <CFQUERY>s, wrapped in a
CFTRANSACTION.
IE,
<snip>
<cfthanks>
I have 1 database on a mssql , 2 tables, i need to insert user_id and
password in dbo.usere and the user details in dbo.userdetails with one how
can i do this with one <cfinsert> & <cfquery> . <cftahanks>
----------------------------------------------------------------------------
--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
