Check the length of the fields in your table. You will probably find that
the value for one (or more) field that you are trying to insert is too long
for the field in the table.
Eric J. LeRoy
RST Database Admin/Software Developer
-----Original Message-----
From: Jennifer Larkin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 14, 2001 3:53 PM
To: CF-Talk
Subject: Re: a single quote bug with cf4.0?
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
