>- see footer for list info -< You don't say what's not happening. What datatypes are your columns?
'#ListElement#' instead of #ListElement# if it's a string. Adrian -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul Swingewood Sent: 22 March 2006 12:40 To: [email protected] Subject: [CF-Dev] List Loop >- see footer for list info -< Can anyone see whats wrong with this please ...? <cfoutput>#form.IncidentType#</cfoutput> <cfloop index = "ListElement" list = "#form.IncidentType#" delimiters = ","> <cfquery datasource="#Application.RacistDSN#" name="AddPartTwo"> INSERT INTO tblIncidentTypeToIncident ( IncidentTypeIDFK, Incidentype ) VALUES ( #Session.LastRecordID#, #ListElement# ) </cfquery> </cfloop> Regards - Paul _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
