No... check field lengths --- truncation occurs when input exceeds the
field length
>Looks like you are missing a comma between "Water Utilities" and "Use of
>Plastic Pipe"
>
>Try that first
>
>-----Original Message-----
>From: Rick Lamb [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, February 13, 2001 6:50 PM
>To: CF-Talk
>Subject: a single quote bug with cf4.0?
>
>
>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.
>SQL = "Insert into Reference (LegacyNum, DocumentLink, Title, PubAbbr,
>Authors, CorporateSource, PubName, ConferenceLocation, MeetingDate,
>Publisher, Availability, ISSN, ISBN, LibCongressNum, CODEN, OrderNum,
>PubDate, PubYear, Edition, VolumeNum, IssueNum, Pagination, Pages, Language,
>Notes, DocType, MediaType, Abstract, Descriptors, ADD_Date, ADD_Initials,
>CHG_Date, CHG_Initials) Values('JAW71029', '', 'Water Utilities'' Use of
>Plastic Pipe: Skagit County', 'JAW', 'Yale, Robert A.', '', 'Journal
>American Water Works Association', '', '', 'AWWA', 'AWWA', '0003-150X', '',
>'', 'JAWWA5', '', 'February', '1971', '', '63', '2', '124-126', '3',
>'English', 'tables', 'Jnl Article', '', 'The successful use of plastic
>material pipes in the Public Utility District No. 1 of Skagit County
>Washington is discussed. One reason for the success is having experienced
>installers, keeping in contact with manufacturers and using conservative
>pressure ratings. The water district also has experienced cost savings using
>the plastic pipe.', 'Plastic Pipe^Costs', 'DAW', '19951002', '', '')"
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
