Let me try this again please.
Is this the best way to handle a 2 table insert ?
<cftransaction>
<cfquery name="AddUser" datasource="sqlswidata">
INSERT INTO Users (Users.UserID,Users.Password)
VALUES ('#Form.UserID#', '#Form.Password#')
</cfquery>
<CFQUERY NAME="AddUserDetails"
DATASOURCE="sqlswidata">
INSERT INTO Users,UserDetails
(UserDetails.FirstName,UserDetails.LastName,UserDetails.Company,UserDetails.
Address1,Address2,UserDetails.City,UserDetails.State,UserDetails.Country,Use
rDetails.Zip,UserDetails.PhoneHome,UserDetails.PhoneWork,UserDetails.PhoneFa
x,UserDetails.Email)
VALUES ('#Form.FirstName#', '#Form.LastName#', '#Form.Company#',
'#Form.Address1#', '#Form.Address2#', '#Form.City#', '#Form.State#',
'#Form.Country#', '#Form.Zip#', '#Form.PhoneHome#', '#Form.PhoneWork#',
'#Form.PhoneFax#', '#Form.Email#')
</CFQUERY>
</cftransaction>
Jim Taylor
ICQ 47640391
------------------------------------------------------------------------------
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.
