Thank you, this solved my problem.
TK
-----Original Message-----
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 5:01 PM
To: CF-Talk
Subject: RE: Working with CLOBs
There's a setting in the datasource config (advanced settings) that will
allow a data source to pull back more than 64K bytes from a BLOB/CLOB
field.
Cheers,
barneyb
> -----Original Message-----
> From: Tom Kitta [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 06, 2004 1:53 PM
> To: CF-Talk
> Subject: Working with CLOBs
>
> Hello,
>
> I am running into a strange problem with CFMX6.1 and SQL
> Server2000. I am
> able to insert 170k text into a 'text' field, however when I query and
> retrieve the same text CF only dumps the first 64000bytes
> precisely. The
> same query outside CF works fine (I cannot view actual data dump using
> standard MS tools, I use 'datalength' function to find object
> size). Anyone
> knows what's going on? Is it the driver that is failing me?
> Thanks a lot for
> your help.
>
> TK
>
>
>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- crystal tech - access databases Tim Laureska
- Working with CLOBs Tom Kitta
- RE: Working with CLOBs Barney Boisvert
- RE: crystal tech - access databases Tom Kitta
- RE: crystal tech - access databases Cameron Childress
- RE: crystal tech - access databases Tim Laureska
- RE: crystal tech - access databases Jason Egan