Yep. You're using an older SQL ODBC driver that released before SQL 7. SQL
6.5 had a 255 character limit in varchar fields. Update the driver.
Jim
----- Original Message -----
From: "Mike Dorr" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, October 03, 2000 5:18 PM
Subject: CFQuery in 4.5 Truncating SQL7 varchar field
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_003D_01C02D66.5CF5CA60
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: 7bit
>
> Here's the problem.
> I have a large varchar field in a SQL 7 database, max 8000 characters.
> Normally, I would use a text field, but I have a GROUP BY clause in about
5
> different queries that need to access it. However, you cannot GROUP BY a
> text field. Anyway, I have had no problem in 4.0 querying for and
outputting
> all the text I need to. However, when running the queries (via ODBC) in CF
> 4.5, they are only returning the first couple hundred characters (I'm
> guessing 255). Needless to say this severely screws up the site. Has this
> happened to anyone else? I need a solution quickly and hopefully one that
> will not require CASTing variables in TransactSQL. Others have speculated
> that there may be a problem with the ODBC drivers. Thank you for your
help.
>
>
> [EMAIL PROTECTED]
> Application Developer (Internet Scribe)
> Weberize
> Strategists. Builders. Evangelists.
> Phone: 615-301-8004 ext 356
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
