its Friday afternoon.. almost beer time.. my brian is not working but... Update tableName SET FirstName='D' AND LastName='G'
shouldnt the update statement be Update tableName SET FirstName='D', LastName='G' Joel ----- Original Message ----- From: "Deepak Gupta" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Friday, March 09, 2007 2:16 PM Subject: Re: Data truncation: Truncated incorrect DOUBLE > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272120 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
