|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
April 21st, 2005, 08:36 AM
|
|||
|
|||
string or data will be truncated error...
Thanks for the help in advance. I am receiving a weird sql error saying 'string or data will be truncated' The field has set up as a varchar(1000) on the DB. When i count the chars in the text with the spaces, I have 994. Why does it truncate the string when i have less than the required?
|
|
#2
April 21st, 2005, 09:28 AM
|
|||
|
|||
|
check the actual length of the string using len()...I suspect there are hidden characters or spaces that you are not counting. The database wouldn't be giving you the error if the string was not breaking the limit.
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
#3
April 21st, 2005, 02:32 PM
|
|||
|
|||
|
I had an oracle error once that shouldn't have happened--string literal too long on a short string. To fix it, I used <cfqueryparam cfsqltype="" value="##">. Worked for my issue
I truly doubt that this will fix your problem, but I thought I would pass it along anyway.
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > string or data will be truncated error... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
