Data truncation:

[Deepak Gupta]

Hi 
I am getting this error
Data truncation: Truncated incorrect DOUBLE value

from query
<cfloop query="GetColumnNames">
                                                                                
                        <cfquery name="Update" datasource="Application.dsn#">
                                                                                
                                Update #Table# SET 
                                                                                
                        <cfloop from="1" TO="#ArrayLen(arr1)#" index="i">
                                                                                
                                        #arr1[i]#='#arr2[i]#'
                                                                                
                                        <cfif i NEQ ArrayLen(arr1)>
                                                                                
                                                AND 
                                                                                
                                        </cfif>  
                                                                                
                                </cfloop>
                                                                                
                                WHERE ID=#UID#
                                                                                
                         </cfquery>
                                                                                
                </cfloop>               

The column names are of type varchar(50)

Can anyone help me with this issue?     Its killing me right now.

DG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272121
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4