This is what i get when i output the query Update tableName SET FirstName='D' AND LastName='G' and firstName and lastName are varchar in my table that too varchar(256)
DG >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: >>> --Ben ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272113 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4