At 08:50 PM 2/13/01 -0600, you wrote:
>I'm having a problem with a query. I've isolated the problem to a field that
>contains a single quote and can't figure out why it's now escaping it
>correctly. Is there a bug with cf 4.0 with not escaping single quotes, or is
>it something else? Thanks for any help! Here's the error I'm getting:
>ODBC Error Code = 22001 (String data right truncation)
>[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
>be truncated.
I don't think it's the single quote.
This error usually occurs when you are trying to insert data into a field
that is not large enough to hold the data. Have you checked that?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
