how about something like
<CFQUERY NAME="AddUser"
DATASOURCE="sqlswidata">
INSERT INTO Users,UserDetails
(Users.UserID,Users.Password,UserDetails.FirstName,UserDetails.LastName,User
Details.Company,UserDetails.Address1,Address2,UserDetails.City,UserDetails.S
tate,UserDetails.Country,UserDetails.Zip,UserDetails.PhoneHome,UserDetails.P
honeWork,UserDetails.PhoneFax,UserDetails.Email)
VALUES ('#Form.UserID#', '#Form.Password#','#Form.FirstName#' etc
etc.etc)
</CFQUERY>
-----Original Message-----
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 6: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,
<CFTRANSACTION>
<CFQUERY>
INSERT username, password...
</CFQUERY>
<CFQUERY>
INSERT userdetails
</CFQUERY>
</CFTRANSACTION>
this way if one blows up, the entire transaction gets rolled back, and you
avoid ugly data consistency problems.
Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]
-----Original Message-----
From: Jim Taylor [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 9:52 AM
To: Cf-Talk@Houseoffusion. Com
Subject: <cfinsert> & <cfquery>
<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.
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
