Scratch that last email I didn't look very close, sorry!
If you are just inserting into one table then why not use
<CFINSERT dataSource="database" tableName="table">
and then pass whatever from your form.
Or am I misunderstanding what your doing?
-Mark :o)
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 14, 2000 3: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/cf-talk@houseoffusion.com/
> 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/cf-talk@houseoffusion.com/
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.
