Page History: How do I interact with the database in Web Macros?
Compare Page Revisions
Page Revision: 2008/07/21 18:26
DECLARE $SqlQuery Provider=SQLOLEDB;SERVER=.\PROVIDUSSTD;USER=sa;PASSWORD=velocityscape;DATABASE=YourDatabaseName "SELECT * FROM YourTable"
DECLARE @i
SET @i 0
LABEL Loop
// $SqlQuery @i0 is like a variable and can be placed along side literals or by itself. The addressing is $SqlQuery@RowNumber@ColumnNumber base 0
// So the following reference is to YourTable at the i'th row, column zero.
GO $SqlQuery @i0
// Use datapage GUID in EXTRACT command
EXTRACT 649FAB65-590E-496E-88E7-34855093DAC2
INCREMENT @i
JUMP Loop