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
------=_NextPart_000_003D_01C02D66.5CF5CA60
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"
eJ8+IisXAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANAHCgADABIAEgAAAAIACgEB
A5AGAFAIAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAALQAAAENGUXVlcnkgaW4gNC41IFRydW5jYXRpbmcgU1FMNyB2YXJjaGFyIGZpZWxkAAAAAAIB
cQABAAAAFgAAAAHALZBFwpe+rvmZMxHUgQAAsNAlPS8AAAIBHQwBAAAAHAAAAFNNVFA6TUlLRS5E
T1JSQFdFQkVSSVpFLkNPTQALAAEOAAAAAEAABg4AhNArkC3AAQIBCg4BAAAAGAAAAAAAAABfyaVI
ENTTEYCfALDQJT0vwoAAAAsAHw4BAAAAAgEJEAEAAADMAwAAyAMAAEoFAABMWkZ1IYbzagMACgBy
Y3BnMTI1FjIA+Atgbg4QMDMzjwH3AqQD4wIAcHJxDlAIZmNoCsBzZXQw/iAHEwKDAFAQZhFPAgAR
EeUSrlQJcGJ1ExARkAXRzQKAfQqACMggOwliDiD+OAm0F4IKMheBFzMJqxiWnRePMBjKGvgWUVx2
CJCkd2sLgGQ0DGBjAFCZCwNzYg9AAUBzYR5ySQu1IEgEkGUnBCB0FRXQIBDgbwJgZW0uUwrjCoBJ
IBMgdiAgYdIgC2ByZyAgdgrAExLEIGYIkGxkIAuAIZEAU1FMIDcgZGElAZFhEYAsIADAeCBeOB6A
EbATEgDQdASQc40gsE4FsADAbGx5JDDtITB3CGAi0XURgCGRJUB+eAVAIqMkMBWgBUAhN0eAUk9V
UCBCWSTQ3wtgJsIjAgbgJ/E1I6AGkOZmH6ECMCBxClAIgR/imSPAIG4J4CLgdG8hkExjYweQBCBp
dCCwSKhvd2UhcHIkMHkIYPMk0ABwbm8FQCi3JwogsOBBbnl3YSYTIVMTIM8i4C4AIDYi8jQuEbAr
Avp5C4BnIpAFsQBwIuAqAfpwJ/B0MlIl4R/zJyMhMJsr1SzpdxXQA6BydS3wNzJSIAIrBigdICGg
T0RIQkMpIvJDRjGxNbskMCABeSGQCXAzAG4mAP82EBGQCHA2VyKgEXAFQAWg7nULUDCBNjBkCXEk
2TdQ9EknMXBnClAEEDJSDjD8NSklgSvhIIAEESwhHrD/OPAgAAQAPnAtMiLAOPAE8f8H0AQgOwAf
8wCQJUAs4SQA8z60EyBwcAnwK/UvwAIgtyAgIsARgD80hiGgcwbw3SfwaQIgKvEN4Gs5cTLS9Ghv
QaBmJoA5cUJiK4M/A/Az0S4CCXBEITkhQ0H+UwdgMmEiIQcwIHEsoQOg3xVwAHElISNRILBPIAE8
UfUhU3NBoGMmgCPAK/Irku9JUiAgAMA48GIhgjEWA/B/IAAf8zeyI6AFEC1BJXFU+RMgbmstgzKS
LZEFwBXQ/GxwILEL4R2gIOMK9BJjdwwBT9dQBmMAQQwwFDMxUjYkQGlrQLBkBbBybkAtIEugBRB6
QLAFoG3bT8VSEDIRwEGQbA3gI8D9Q+JELTEJAEGgBcA8gAIwWwSRFeFTBQFLoClUVzG8IFdTpVIB
UOZSEDMGANZ0JRAlQGcEAHQlcFii9iADMFTCQkQwItAlUlpX+DQgRSIgDyAiwFoGHeMNCoBQROAr
0DogNjHANS0zMDEtJJFcINEnMjM1NlijYgLRUJ4XCzEg8hZRAGGQCwAAgAggBgAAAAAAwAAAAAAA
AEYAAAAAA4UAAAAAAAADAAKACCAGAAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMAB4AIIAYAAAAA
AMAAAAAAAABGAAAAAFKFAAAnagEAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAA
OS4wAB4ACoAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAAuACCAGAAAAAADA
AAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAMgAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEA
AAABAAAAAAAAAAsADYAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAACwARgAggBgAAAAAAwAAA
AAAAAEYAAAAABoUAAAAAAAADABKACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAG4AIIAYA
AAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAcgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAAD
AB6ACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAAIB+A8BAAAAEAAAAF/JpUgQ1NMRgJ8AsNAl
PS8CAfoPAQAAABAAAABfyaVIENTTEYCfALDQJT0vAgH7DwEAAACXAAAAAAAAADihuxAF5RAaobsI
ACsqVsIAAFBTVFBSWC5ETEwAAAAAAAAAAE5JVEH5v7gBAKoAN9luAAAAQzpcV0lOTlRcUHJvZmls
ZXNcQWRtaW5pc3RyYXRvclxMb2NhbCBTZXR0aW5nc1xBcHBsaWNhdGlvbiBEYXRhXE1pY3Jvc29m
dFxPdXRsb29rXG1haWxib3gucHN0AAADAP4PBQAAAAMADTT9NwAAAgF/AAEAAAA2AAAAPE5EQkJJ
QUpQRlBISkhGR05DTlBMSUVGTUZOQUEubWlrZS5kb3JyQHdlYmVyaXplLmNvbT4AAAADAAYQlXfU
BgMABxDWAgAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAEhFUkVTVEhFUFJPQkxFTUlIQVZF
QUxBUkdFVkFSQ0hBUkZJRUxESU5BU1FMN0RBVEFCQVNFLE1BWDgwMDBDSEFSQUNURVJTTk9STUFM
TFksSVdPVUxEVVNFQVRFWFRGSUVMRCwAAAAABQg=
------=_NextPart_000_003D_01C02D66.5CF5CA60--
------------------------------------------------------------------------------
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.
