Re: Data truncation: Truncated incorrect DOUBLE

uot;Deepak Gupta" <[EMAIL PROTECTED]> To: "CF-Talk" 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' >

Re: Data truncation: Truncated incorrect DOUBLE

Can anyone help me with this issue >Is it some mysql issue??? > >DG >>> My query is ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/

Re: Data truncation: Truncated incorrect DOUBLE

Is it some mysql issue??? DG >Is the datasource empty in the live version, or did you remove it to >post here? > >--Ben Doom > >Deepak Gupta wrote: >> HI >> >> I am getting this error >> >> Data truncation: Truncated inc

Re: Data truncation: Truncated incorrect DOUBLE

I removed it to post here. DG >Is the datasource empty in the live version, or did you remove it to >post here? > >--Ben Doom > >Deepak Gupta wrote: >> HI >> >> I am getting this error >> >> Data truncation: Truncated inc

Re: Data truncation: Truncated incorrect DOUBLE

Is the datasource empty in the live version, or did you remove it to post here? --Ben Doom Deepak Gupta wrote: > HI > > I am getting this error > > Data truncation: Truncated incorrect DOUBLE value: 'Valu

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 fro

Re: Data truncation: Truncated incorrect DOUBLE

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 d

Re: Data truncation: Truncated incorrect DOUBLE

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. D

Re: Data truncation: Truncated incorrect DOUBLE

; DG >> Offhand, if arr2 contains values, you should use single quotes around >> it, not double quotes. >> >> --Ben Doom >> >> Deepak Gupta wrote: >>> HI >>> >>> I am getting this error

Re: Data truncation: Truncated incorrect DOUBLE

I tried using single quotes too. Still it doesnt work DG >Offhand, if arr2 contains values, you should use single quotes around >it, not double quotes. > >--Ben Doom > >Deepak Gupta wrote: >> HI >> >> I am getting this error >> >> Data trunc

Re: Data truncation: Truncated incorrect DOUBLE

Offhand, if arr2 contains values, you should use single quotes around it, not double quotes. --Ben Doom Deepak Gupta wrote: > HI > > I am getting this error > > Data truncation: Truncated incorrect DOUBLE value: 'Valu

Data truncation: Truncated incorrect DOUBLE

HI I am getting this error Data truncation: Truncated incorrect DOUBLE value: 'Value1' M