You can also do this
<CFQUERY>
INSERT INTO TABLE(THIS_FIELD) VALUES ('#FIELD1#')
INSERT INTO TABLE(THIS_FIELD) VALUES ('#FIELD2#')
INSERT INTO TABLE(THIS_FIELD) VALUES ('#FIELD3#')
</CFQUERY>
----- Original Message -----
From: "Spencer Saunders" <[EMAIL PROTECTED]>
To: "cftalk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 09, 2000 12:37 PM
Subject: SQL insert question
> I am trying to insert multiple variables into one field in a DB but each
> variable in it's own row. The problem I keep running into is that all the
> variables keep getting inserted into one row and not individual ones. My
> INSERT code as follows.
>
> <cfquery datasource="whatever">
> INSERT into Tablename (Fieldname)
> VALUES ('#field1#, #field2#, #field3#')
> </cfquery>
>
> Thanks in advance.
>
> spencer
>
> --------------------------------------------------------------------------
----
> 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.
