Very Computer

by **Martin Frolic** » Thu, 02 Jul 1998 04:00:00

Hello,

I'm not very experienced in SQL programming. Can anyone tell me if there is
a soulution for my problem, please?

I need to create and update records in MSSQL table. There is a TEXT datatype
field within my table in which I have to write text data from ASP page. It
works fine if length of the text is less than 102400 bytes. I simply
executed
<%connection.execute ( "INSERT INTO mytable VALUES ( '.... < 102400 bytes of
text...' ) " )%>
If more data is sent, no error, no warning, field is just filled with
incorrect data. Is there any way to send more than 102400 bytes of data ????

Any help greatly appreciated.

Martin Frolich

by **Carl-Johan Wi** » Fri, 03 Jul 1998 04:00:00

in vb a would use "appenchunck", I don't know is this used in asp to, check
it out in the help

cjw
MCT

>Hello,

>I'm not very experienced in SQL programming. Can anyone tell me if there is
>a soulution for my problem, please?

>I need to create and update records in MSSQL table. There is a TEXT
datatype
>field within my table in which I have to write text data from ASP page. It
>works fine if length of the text is less than 102400 bytes. I simply
>executed
><%connection.execute ( "INSERT INTO mytable VALUES ( '.... < 102400 bytes
of
>text...' ) " )%>
>If more data is sent, no error, no warning, field is just filled with
>incorrect data. Is there any way to send more than 102400 bytes of data
????

>Any help greatly appreciated.

>Martin Frolich

Very Computer

using TEXT and IMAGE datatypes

using TEXT and IMAGE datatypes

using TEXT and IMAGE datatypes