How can I extract fields/columns longer than 8000 characters?

If you have Web Scraper Plus+ 5.5 or greater with SQL2K5 (Express) installed you can do the following:

Run the following SQL query in [http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en|SQL Server Management Studio Express]<BR>
{{{{USE [ProvidusDB]
GO

ALTER TABLE ProvidusDB.dbo.TASK_INSTANCE_DOCS
ALTER COLUMN URI VARCHAR(MAX)
 
ALTER TABLE ProvidusDB.dbo.TASK_DOC_LOCATIONS
ALTER COLUMN SOURCE VARCHAR(MAX)
 
INSERT ProvidusDB.dbo.SETTINGS
SELECT 'IsSQL2k5' as name, 'True' as val, 'bool' as datatype, NULL as parent}}}}


Now you can change change field lengths to varchar(MAX) by making the field length -1 in your Datapage -> Field Properties -> Database Tab -> Column Length

!!!NOTE: There is a bug that doesn't allow you to create a field with an initial length of -1. You have to make it a positive number like 6000 to create the field. Then go back and change it to -1 and save.

Web Scraper and Web Macros FAQs

Navigation

How can I extract fields/columns longer than 8000 characters?