p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_codeclinic thread: Re: Building a hyperlink


Message #1 by "Ken Schaefer" <ken@a...> on Thu, 1 Feb 2001 12:00:05 +1100
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.

Dallas Martin


----- 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.
>
> Mark
>
>
> ----- 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
> changed
> > the data type and it worked without a problem.
> >
> > You were right... it did show up as a null.  It has something to do
> with
> > reading text type fields in a specific manner.  I've learned to use
> these
> > type of fields very selectively.  I'm still using a text type field
> but
> > 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...
> >

  Return to Index