>'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
None of the columns in the table structure is an integer. All the numbers are listed as numerics. >thing I would do is dump the variable you're passing in from CF and check >its value. I dumped it and presented it in the first posting of the problem. I didn't see any wrong type of data for the expected fields in the sql output. daniel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280091 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
