On 9/14/00, [EMAIL PROTECTED] penned:
>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>
That should work. I do it all the time putting #firstname# #lastname#
into one column.
I don't know if the query name will cause a problem, but it's not
needed for an insert.
The only other problems I can see is if the column is a number data
type. Or if it's a text field and it's too short for the 3 values.
What error are you getting?
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------
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.
