Test the page- comment out the loop/query and put a <cfoutput>#ListLen(Form.EmpID_Muster)#--#empID_muster#, #emp_status#<BR></CFOUTPUT> This will show you how it's trying to update the database- and Jim is probably right that it's trying to do something like EmpID/Emp_Status 123/1,1,1,1,1,1,1,1,1 Instead of what you want, which is 123/1 124/1 193/1 203/1 blah/blah/blah/blah Maybe you should use a different field to use with listlen?? I guess I just neveruse an autonumber type id with my loops.
-----Original Message----- From: Jim Davis [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 11:12 AM To: CF-Talk Subject: RE: CF SQL problem > 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
