Thanks Rob Parkhill.
It was the Max data length in cf admin.It was set to 64,000 characters by
default. Adjusting that solved the problem.
Robert Harrison
Director of Interactive Services
Austin & Williams
Advertising I Branding I Digital I Direct
125 Kennedy Drive, Suite 100 I H
; Bobby Hartsfield
> http://acoderslife.com
> http://cf4em.com
>
> -Original Message-
> From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
> Sent: Monday, March 14, 2011 5:41 PM
> To: cf-talk
> Subject: RE: Data Truncation on TEXT field
>
>
> Enable Blo
Even the ones**
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
Sent: Monday, March 14, 2011 5:41 PM
To: cf-talk
Subject: RE: Data Truncation on TEXT field
Enable Blob/Clob
rison [mailto:rob...@austin-williams.com]
Sent: Monday, March 14, 2011 1:39 PM
To: cf-talk
Subject: Data Truncation on TEXT field
Hi,
I have a client with no sense who want to type a book into a single field.
They have over 200,000 characters they are typing into the edit file.
Data ba
Rob,
The Text, NText, and Image data types come from the previous versions of SQL
Server. It is recommended that you use the newer varchar(MAX),
nvarchar(MAX), and varbinary(MAX) data types instead.
Results to text only allows a maximum of 8192 characters. Perhaps this is
also your issue in quer
lug in to our blog: A&W Unplugged
http://www.austin-williams.com/unplugged
-Original Message-
From: Brian Cain [mailto:bcc9...@gmail.com]
Sent: Monday, March 14, 2011 1:43 PM
To: cf-talk
Subject: Re: Data Truncation on TEXT field
Check the advanced settings on the datasource in the
Going straight to just the SQL update I have:
UPDATE tbl_capabilities_categories
SET capability_cat_txt2='HERE ARE 200,000 ALPHANUMERIC ONLY CHARACTERS'
WHERE id=#id#;
capability_cat_txt2 field type is TEXT
Only about 63,000 of the update characters are being updated to the field. The
r
Check the advanced settings on the datasource in the CF Adminstrator. Make
sure "CLOB" (Enable long text retrival) is checked , and increase the long
text buffer to handle the larger data field size.
~|
Order the Adobe Coldfusi
Hi,
I have a client with no sense who want to type a book into a single field.
They have over 200,000 characters they are typing into the edit file.
Data base is:
MS SQL 2008 R2
Field type is:
text
When an update is done the data is truncated at around 63,000 characters.
*facepalm*
Syntax gets you every time, doesn't it?
--Ben Doom
Deepak Gupta wrote:
> got it
>
> instead of AND i have to use comma.
~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see
got it
instead of AND i have to use comma.
>Hi
>I am getting this error
>Data truncation: Truncated incorrect DOUBLE value
>
Hi
I am getting this error
Data truncation: Truncated incorrect DOUBLE value
from query
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'
>
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/
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
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
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
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
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
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
; 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
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
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
HI
I am getting this error
Data truncation: Truncated incorrect DOUBLE value: 'Value1'
M
Perhaps your field lengths are too short. Check the length of the
fields in the database for each parameter (especially those long ones)
Joseph Christina, RN
Web Programmer
Children's Hospital of Philadelphia
--
Archive
> From: "AKBAR" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Thursday, May 04, 2000 8:25 PM
> Subject: data truncation??
>
>
> > hello everybody,
> >
> > can anyone plzz tell me wat this erro
t with a
general identifier of
> (CFQUERY), occupying document position (3:1) to (3:67) in
the template file
> C:\PROGRAM
>
FILES\ALLAIRE\SPECTRA\CUSTOMTAGS\SYSTEM\COAPI\UTILS\_RECORDI
NSERT_BP.CFM.
>
>
>
>
> -Original Message-
> From: Fred T. Sanders
[mailto:[EMAI
the question mark is really there?
- Original Message -
From: "AKBAR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 04, 2000 8:44 PM
Subject: RE: data truncation??
> ok here is the query code. i am running spectra.
>
> Queries
>
&g
0 9:31 AM
To: [EMAIL PROTECTED]
Subject: Re: data truncation??
You'll need to show the query code as well.
- Original Message -
From: "AKBAR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 04, 2000 8:25 PM
Subject: data
You'll need to show the query code as well.
- Original Message -
From: "AKBAR" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 04, 2000 8:25 PM
Subject: data truncation??
> hello everybody,
>
> can any
hello everybody,
can anyone plzz tell me wat this error stands for?? i am not able to proceed
further.
plzz, tell me the solution for this.
thanx in advance
akbar
Error Diagnostic Information
ODBC Error Code = 01004 (Data truncated)
[Microsoft][ODBC SQL Server Driver]Fractional truncation
T
IL PROTECTED]
> Subject: data truncation
>
>
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0059_01BFA9E6.FE00C9E0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> has anyone run
One of the form fields allows more info than your db field allows.
add maxlength="??" to your form fields to equal the field size of your corresponding
db fields.
Jeff Craig
--
Archives: http://www.
: Ben Densmore <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 19, 2000 14:06
Subject: data truncation
> This is a multi-part message in MIME format.
>
> --=_NextPart_000_0059_01BFA9E6.FE00C9E0
> Content-Type: text/plain;
> charset="iso-885
This is a multi-part message in MIME format.
--=_NextPart_000_0059_01BFA9E6.FE00C9E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
has anyone run into this problem before? I only get this error message =
once in a while. some people that s
35 matches
Mail list logo
