cfupdate is passing the entire value form.empid_muster, not one value at a time. Simply dump the cfupdate and switch to a real SQL insert.
======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 18, 2002 9:22 AM > To: CF-Talk > Subject: 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. > > > > Rick > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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.
