p2p.wrox.com Forums

Need to download code?

View our list of code downloads.

  Return to Index  

asp_forms thread: Insert and retrieve sql server text / blob field via ASP

Message #1 by "Alex Bienz" <alex@v...> on Wed, 29 May 2002 10:06:52 +0100

We've spent quite a lot of time trying to find out how best to insert data
into SQL Server TEXT (blob / long text) fields.
We found something on the Microsoft site but it didn't seems particularly

Basically, this is our situation:
We have a website. We use ASP and Stored Procedures to insert data. We need
to insert more than 8000 characters to one field so are going to have to
change a field from VarChar to a TEXT field.
But we can't find out how we'll insert into this text field.

We also currently search against this field - will this change when we
convert from varchar to text?

Thanks in advance

  Return to Index