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
