Use the Set TEXTSIZE command to set the
size of the buffer where the results of READTEXT
are stored. If size of the column is less
than @@TEXTSIZE, then the entire column is
available. If it is larger, then any data
beyond the size of the @@TEXTSIZE is lost.
Any SELECT on a text datatype will be affected
by @@TEXTSIZE. SQL Books OnLine has good documentation
of the handling of text columns. By the way the default
size is 4K.
----- Original Message -----
From: "Draco Associates Ltd" <jmail@d...>
To: "Code Clinic" <proasp_codeclinic@p...>
Sent: Friday, February 02, 2001 3:25 PM
Subject: Re: Building a hyperlink
> Neal, the trick seems to be to order fields in your query such that
> the text-type columns is/are the last one(s) requested. For example
> SELECT MyInteger, YourVarchar, MyVarchar, MyText FROM... etc.
> However you might reconsider your use of the text datatype. If (as
> your example suggests) the "Link" column in your database will always
> contain only a URL, then the text datatype seems like overkill.
> Varchar will always be smaller and retrieve more efficiently than
> text. Use text when you might have more than 8000 (4000 with
> nvarchar) characters to store.
> Hope this helps.
> ----- Original Message -----
> From: "Neal Lebar" <nlebar@i...>
> To: "Code Clinic" <proasp_codeclinic@p...>
> Sent: Friday, February 02, 2001 9:55 AM
> Subject: RE: Building a hyperlink
> > It was resolved... objrs("Link") was a text SQL datatype field. I
> > the data type and it worked without a problem.
> > You were right... it did show up as a null. It has something to do
> > reading text type fields in a specific manner. I've learned to use
> > type of fields very selectively. I'm still using a text type field
> > changed most of the others to varchar.
> > Thanks,
> > Neal
> > -----Original Message-----
> > From: p.bengeri@z... [mailto:p.bengeri@z...]
> > Sent: Friday, February 02, 2001 12:35 AM
> > To: Code Clinic
> > Subject: Re: Building a hyperlink
> > Hi Neal,
> > I think the problem is the objrs("Link") contains null so nothing is
> > showing up.
> > try writting objrs("Link") [response.write] and check if it is null
> > i think this will work else do tell me.
> > -Praveen
> > p.bengeri@z...