In addition, if you want to reduce your database calls, you can alway s do:
<cfquery datasource="Software Updates" name="serverUpdate"> <CFLOOP INDEX="ServerID" LIST="#servers#" DELIMITER=" ,"> INSERT INTO [update] (log_id, server) VALUES (#logQuery.id#,#ServerID#) </CFLOOP> </cfquery> That way, you're only doing one db call, that has multiple statemen ts within it. Also, you should wrap the dynamic variables in the insert statement with <cfqueryparam> tags. ----- Original Message ----- From: Matthew Walker <[EMAIL PROTECTED]> Date: Wednesday, February 27, 2002 3:07 pm Subject: RE: Inserting a delimited list into a database > Hey ho! The problem is having a table called Update! Try wrapping > [] around > update. > > > -----Original Message----- > > From: Jake Munson [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, 28 February 2002 10:47 am > > To: CF-Talk > > Subject: Inserting a delimited list into a database > > > > > > I have a form that returns a comma delimited list of > > numbers from some checkboxes that each have the same name. > > I want to be able to insert a new record in a database for > > each checkbox that was checked in my form. I figured that > > if I used a list loop based on my checkbox list, that I > > could have a SQL query insert a record for each value in > > the list. But it keeps giving me an error on the insert > > query. Is it not possible to put a cfquery into a loop? > > Is there a better way to do this? Below is my code. Below > > that is the error I get. > > > > <CFLOOP INDEX="ServerID" LIST="#servers#" DELIM ITER=","> > > <cfquery datasource="Software Updates" name="serverUp date"> > > INSERT INTO update (log_id, server) > > VALUES (#logQuery.id#,#ServerID#) > > </cfquery> > > </CFLOOP> > > > > "[Microsoft][ODBC Microsoft Access Driver] Syntax error in > > INSERT INTO statement. > > > > The error occurred while processing an element with a > > general identifier of (CFQUERY), occupying document > > position..." > > > > I thought that maybe the problem was that I didn't have a > > cfoutput around the #ServerID#, but that wasn't the probl em > > either. > > > > Thanks for the help. > > > > -Jake > > > > ______________________ _________________________ ___ > > Do You Yahoo!? > > Yahoo! Greetings - Send FREE e-cards for every occasion! > > > _______________________ _________________________ ______________________ > Why Share? > Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / > 20 GB MO/XFER > Instant Activation � $99/Month � Free Setup > http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: http://www.mail-archive.com/cf-talk@houseoffusion com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sideb ar=lists > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
