Web Scraper and Web Macros FAQs
Navigation
Home
All Pages
Categories
Quick Search
Advanced Search »
Back
History
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.
Create a Page
|
Administration
|
File Management
|
Login/Logout
|
Language Selection
|
Your Profile
|
Create Account