Yes. Your input data is too long for the database column.
You should really validate inputs for length (and type, too).
E.g. if you had a varchar(64) column called Title, do this:
...
<cfif Len(Trim(form.title)) GT 64>
... output an error msg to the user ...
<cfelse>
... go ahead and do the query ...
</cfif>
...
Interestingly enough, Allaire's very own Forums
will barf with the string data right trunc error message if
you put a long subject line in your posting.
Repeat to yourself thirty-two times:
"I will not pass unchecked data to my database."
:)
Chris Tweney
Media Application Developer
roundpeg
www.roundpeg.com
1700 California Suite 260
San Francisco, CA. 94109
Ph. 415-437-3900
Fax 415-437-3904
> -----Original Message-----
> From: Steve Weiner [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 01, 2000 7:43 AM
> To: '[EMAIL PROTECTED]'
> Subject: Is there a typical cause for this error message?
>
>
> Error Occurred While Processing Request
> Error Diagnostic Information
> ODBC Error Code = 22001 (String data right truncation)
>
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]String or
> binary data would
> be truncated.
>
>
>
> The error occurred while processing an element with a general
> identifier of
> (CFQUERY), occupying document position (41:7) to (41:98).
>
>
>
> --------------------------------------------------------------
> ----------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
s/cf_talk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
