How do I interact with the database in Web Macros?

{{{{DECLARE $SqlQuery Provider=SQLOLEDB;SERVER=.\PROVIDUSSTD;USER=sa;PASSWORD=velocityscape;DATABASE=YourDatabaseName "SELECT * FROM YourTable"
<nowiki>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</nowiki>
}}}}

Web Scraper and Web Macros FAQs

Navigation

How do I interact with the database in Web Macros?