Rick Lamb 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?
Something else. One of the fields in the database is not long enough for
the data. It's probably the really long piece of text in that data.
> 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
