Oh yeah!!! You are absolutely correct! John, tell Matthew what he's won. ;)
-Jake --- Matthew Walker <[EMAIL PROTECTED]> wrote: > 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! > > > ______________________________________________________________________ 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
