If you are adding 3 records to the DB then you do this:
<cfquery name"addit" datasource="whatever">
INSERT INTO Data(Fieldone) Values('#form.dat1#)
</cfquery>
<cfquery name"addit" datasource="whatever">
INSERT INTO Data(Fieldone) Values('#form.dat2#)
</cfquery>
<cfquery name"addit" datasource="whatever">
INSERT INTO Data(Fieldone) Values('#form.dat3#)
</cfquery>
If the form.dat1 + form.dat2 + form.dat3 is data to be entered into the ONE
field as a sum
then
<cfset alldata = form.dat1 & form.dat2 & form.dat3>
<cfquery name"addit" datasource="whatever">
INSERT INTO Data(Fieldone) Values('#alldata#)
</cfquery>
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 6:12 PM
Subject: Simple SQL Question
> Ok I want to "conjugate" 3 fields when i am inserting into a database.
>
> this is what i have, but it won't work, am i missing something???
>
> <cfquery datasource="data" name="add">
> INSERT INTO Data(data1)
> VALUES('#FORM.dat1# #FORM.dat2# #FORM.dat3#')
> </cfquery>
>
>
> ?????
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/[email protected]/
> 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.mail-archive.com/[email protected]/
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.
