READTEXT Problem

[Dodecahedron]

I have used the following to to try to extract rich text format string from an image field. I have used datalength and notice to see that sizes I am dealing with and some are over 50000 in size

declare @val binary(16)
select @val = textptr(fieldname)
from tablename
where id > 0
readtext tablename.fieldname @val 1 10

I then get the message 110 rows affected, but no rtf strings displayed.

Am I using this in the wrong way?

Thanks

Qouth

 

[DotNetGnat]

try this:

declare @val binary(16)
select @val = textptr(fieldname)
from tablename
where id = 111 
readtext tablename.fieldname @val 1 10

use some specific value for the id and see if the above code reads second through 11th character...

-DNG

 

[Dodecahedron]

Hi, I now get one row affected only, with no output