> I've never seen this message before. Any ideas would be appreciated. > > Here's the code from the Action page: > > <cfloop from="1" to="#ListLen(Form.EmpID_Muster)#" index="i"> > <cfupdate datasource="MorningMuster" dbtype="ODBC" > tablename="muster" formfields="empID_muster, emp_status"> > </cfloop> > > And here's the info I get back from CF Debug > > Error Executing Database Query. Invalid data > 1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1 for > CFSQLTYPE CF_SQL_NUMERIC.
Well - it looks like you're trying to pass a list into a numeric column. My guess is that you've got several form fields named the same - so that the browser is sending one name as a list of all the values rather than one value for each. Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
