'Invalid data for CFSQLTYPE CF_SQL_NUMERIC' That would suggest that the value you're passing in is not numeric, or the column name is an Integer, in which case you might need to use CF_SQL_INTEGER, I've not used ORACLE so can't be sure about that, first thing I would do is dump the variable you're passing in from CF and check its value.
Rob -----Original Message----- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: 05 June 2007 12:38 To: CF-Talk Subject: sql insert error Lost. I'm doing a loop to insert values into a db (Oracle). I keep getting an error 'Invalid data for CFSQLTYPE CF_SQL_NUMERIC.' This is just one example, but I don't see the problem. One other thing though, in my cftry/error output, it says it's on field 'pa_int_other_text, and it seems that it has a value of 1, but it doesn't show up in the sql output. I wasn't sure whether to include this info as it might not be pertinent or be a debugging problem. Here's the sql output (I've removed temporarily the cfqueryparams so that ? don't show up for most values). INSERT INTO fsnep_ha_physical_activity ( physical_activity_id, login_id,stage, active_min, total_active_hours, total_active_min, reg_ex, reg_ex_days, reg_ex_less_30, pa_family, date_added ) VALUES ( unique_ha_physical_activity_s.NEXTVAL, ?,?, '7 days', 1, 30, 4, '0 days', 1, 1, {ts '2005-01-10 06:53:46'} ) Here's the structure: table fsnep_ha_physical_activity ( physical_activity_id NUMBER Primary Key, login_id NUMBER REFERENCES fsnep_login(login_id) ON DELETE CASCADE, date_added date, stage VARCHAR2(50), active_min VARCHAR2(50), total_active_hours NUMBER, total_active_min NUMBER, active_less_30 NUMBER, reg_ex NUMBER, reg_ex_days VARCHAR2(50), total_reg_ex_hours NUMBER, total_reg_ex_min NUMBER, reg_ex_less_30 NUMBER, pa_how NUMBER, pa_daily NUMBER, pa_new NUMBER, pa_health NUMBER, pa_community NUMBER, pa_safety NUMBER, pa_family NUMBER, pa_disability NUMBER, pa_int_other NUMBER, pa_int_other_text VARCHAR2(200) ) -- Daniel Kessler College of Health and Human Performance University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 Phone: 301-405-2545 http://hhp.umd.edu ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280090 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
