Length = 16 is only the data that is stored inside the row. If your total
data for the Text field is 16 characters or less, it is stored in the row.
Otherwise, a pointer is stored to the data page (out of row) that holds the
data.
Check Bob Barrows' info, or, you can use the code on David Penton's side
(he's an SQL Server MVP):
http://www.davidpenton.com/testsite/...b.command3.asp
You need to scroll down to get the point where he appends the parameter for
the Text datatype (adLongVarChar)
Cheers
Ken
"Chopper" <ch*****@despammed.com> wrote in message
news:3f*********************@news.dial.pipex.com.. .
:
: "Tom B" <sh*****@hotmail.com> wrote in message
: news:eK*************@TK2MSFTNGP12.phx.gbl...
: > In your database (I assume Access) you would have set the length of the
: text
: > field. That's the value to use.
: >
: >
: <snip>
:
: Thanks for your reply.
: It's SQL Server 2000. The field in the database is of type 'Text' with
: length 16.
: I cannot find a matching type when passing the parameter using ASP which
is
: what I'm trying to figure out.
:
: