asp_databases thread: retrieve a text datatype from an SQL Server database?
Message #1 by "Sergio Oliveira" <neptuno2@h...> on Wed, 18 Jul 2001 18:29:21
|
|
Hi :)
Can someone tell me why canīt one retrieve from SQL SERVER fields of text
datatype?
Thank you!
Message #2 by John Pirkey <mailjohnny101@y...> on Wed, 18 Jul 2001 11:54:06 -0700 (PDT)
|
|
the TEXT datatype is similar to the image datatype. you sort of have to think of it
as being "blobs" of data. you have to use the GetChunk method of the recordset to
start pulling down the data - building an object to hold it all the while.
check out your fav code site for examples - there should be lots of them out there.
i just can't seem to remember exactly where any are. :(
john
--- Sergio Oliveira <neptuno2@h...> wrote:
> Hi :)
>
> Can someone tell me why canīt one retrieve from SQL SERVER fields of text
> datatype?
>
> Thank you!
Message #3 by Steve Carter <Steve.Carter@t...> on Thu, 19 Jul 2001 10:41:59 +0100
|
|
BLOB actually stands for Binary Large OBject, to complete the mnemonic.
> From: John Pirkey
>
> the TEXT datatype is similar to the image datatype. you sort
> of have to think of it as being "blobs" of data.
|
View Cart
