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

Compare Page Revisions

3 2 1 0 Current 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2008/03/21 21:38

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 SQL Server Management Studio Express

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

FORMATTER ERROR (Malformed List)