You might be better just doing one insert at a time and enclosing the query
in a cfloop looping over the variables...
Just an idea
Ben.
----- 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.
