Web Scraper and Web Macros FAQs

How do I interact with the database in Web Macros?

Modified: 2009/08/13 19:25 by craig - Categorized as: Web Macros
DECLARE $SqlQuery Provider=SQLOLEDB;SERVER=.\PROVIDUSSTD;USER=sa;PASSWORD=velocityscape;DATABASE=YourDatabaseName "SELECT * FROM YourTable"
DECLARE @i
SET     @i 0

LABEL Loop

// $SqlQuery [@i][0] is like a variable and can be placed along side literals or by itself. The addressing is $SqlQuery[@RowNumber][@ColumnNumber] base zero. // So the following reference is to YourTable at the i'th row, column zero. GO $SqlQuery [@i][0]

// Use datapage GUID in EXTRACT command EXTRACT 649FAB65-590E-496E-88E7-34855093DAC2

INCREMENT @i

JUMP Loop
Image
Create a Page | Administration | File Management | Login/Logout | Language Selection | Your Profile |Create Account