Web Scraper and Web Macros FAQs

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

!!!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.
PoweredBy
Create a Page | Administration | File Management | Login/Logout | Language Selection | Your Profile |Create Account