Are you sure that the value in arr1 which lines up with D points to a char, varchar, etc.? Try removing the cfquery from around the query to show what is actually being produced. Also, check your schema to make sure that the columns are correctly defined.
--Ben Doom Deepak Gupta wrote: > I dumped arr2 and i got the value D which is correct. But somehow its > recognizing it as double . I dont understand my column name is > actually firstName and the value i am passing is 'derek'. I cut down > to D even then it gives me error. Its the D value that i am setting > using an update query. > > > DG >> Wait. What is actually stored in arr2? It looks like you're >> trying to store the value "Value1" in a double. Try dumping arr2 >> -- you may be getting value names instead of values. >> >> --Ben ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272112 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
