**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**
Hi,
I have a SQL Server 7 database and I am trying to insert a large amount
Quoting Adams, Stephen [EMAIL PROTECTED]:
The problem I am having is a ODBC Error Code = 22001 (String data
right truncation) error.
My table design is like this.
Column name DatatypeLength
MessageID int 4
MessageType char20
You should either trim the text being inserted using the left function ...
EXAMPLE:
Left(form.MessageTeaser, 16 )
or you should expand the size of the field in the table. If this is data
input via a form you could use the size option in the input tag to enforce
the size restriction but I
respectively, but still I get the 22001 error.
-Original Message-
From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl]
Sent: 28 October 2002 15:05
To: CF-Talk
Subject: Re: OT: SQL Server database problem
Quoting Adams, Stephen [EMAIL PROTECTED]:
The problem I am having is a ODBC Error
I think the error message is straight forward,
that is you are trying to insert string that's longer than your datatype
can handle.
For example:
Field: MessageTitle (16): You are trying to insert: Some text to throw
error which has 24 characters.
Try to increase the length of the field in your
- could this be the problem ?
Alex
-Original Message-
From: John Morgan [mailto:gameczar;zbzoom.net]
Sent: 28 October 2002 15:14
To: CF-Talk
Subject: Re: OT: SQL Server database problem
You should either trim the text being inserted using the left
function ...
EXAMPLE:
Left
: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl]
Sent: 28 October 2002 15:05
To: CF-Talk
Subject: Re: OT: SQL Server database problem
Quoting Adams, Stephen [EMAIL PROTECTED]:
The problem I am having is a ODBC Error Code = 22001 (String data
right truncation) error.
My table design is like
Message-
From: A.Little [mailto:A.Little;open.ac.uk]
Sent: 28 October 2002 15:23
To: CF-Talk
Subject: RE: OT: SQL Server database problem
You don;t need to trim these down to 16 chars as that isn't the max length
you can store in a SQL 'text' field - it's something like up to 2Gb of data
(on SQL2K
Just another taught...
Using varchar instead of text as a datatype for this kind of data maybe
helpful...
Rizal
At 10:21 PM 10/28/2002, you wrote:
I think the error message is straight forward,
that is you are trying to insert string that's longer than your datatype
can handle.
For example:
,
not the three I originally thought.
Stephen
-Original Message-
From: Rizal Firmansyah [mailto:rizal.firmansyah;sentracommerce.com]
Sent: 28 October 2002 15:42
To: CF-Talk
Subject: Re: OT: SQL Server database problem
Just another taught...
Using varchar instead of text as a datatype
10 matches
Mail list logo