got it instead of AND i have to use comma.
>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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
