Web Scraper and Web Macros FAQs

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


Compare Page Revisions



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


Page Revision: 2008/02/19 20:44


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 create field lengths of varchar(MAX) by making the field length -1 in your Datapage -> Field Properties -> Database Tab -> Column Length
PoweredBy
Create a Page | Administration | File Management | Login/Logout | Language Selection | Your Profile |Create Account