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#" DELIMITER=","> > <cfquery datasource="Software Updates" name="serverUpdate"> > 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 problem > 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?sidebar=lists
