Page History: How do I interact with the database in Web Macros?
Compare Page Revisions
Page Revision: 2008/07/21 18:19
// Run setup to create tables
DECLARE $SqlQuery Provider=SQLOLEDB;SERVER=.\PROVIDUSSTD;USER=sa;PASSWORD=velocityscape;DATABASE=YourDatabaseName "SELECT * FROM YourTable"
DECLARE @i
SET @i 0
GO https://www.example.com
LABEL Loop
IF SourceContains "Some identifying text on the page"
BEGIN
JUMP Scrape
END
// Effective ELSE
JUMP Done
Label Scrape
// $SqlQuery
@i0 is like a variable and can be placed along side literals or by itself.
GO $SqlQuery
@i0
// Use datapage GUID in EXTRACT command
EXTRACT 649FAB65-590E-496E-88E7-34855093DAC2
LABEL ClickGoodJobs
IF @j != $GoodJobs.Count
BEGIN
INCREMENT @i
JUMP ClickGoodJobs
END
SET @j 0
JUMP Loop
Label Done