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]

Reply via email to