Handling SQL SELECT result

See also: Running a SQL statement in a Microsoft SQL server database Running a SQL statement in a MySQL server database Running a SQL statement in a ODBC-compatible database Example – Complete newsletter system with subscription handling and email delivery

    If you use an SQL SELECT sentence in any of the database actions available (MySQL, SQL Server or ODBC) Email Parser will automatically add to the available fields the retrieved data. For example:  
Table name: parts
part_id name quantity
1 Screwdriver 5cm 234H 432
2 White scotch type 129
3 Black plastic panel 34
  If you use the following SQL sentence:
SELECT part_id, name, quantity FROM parts;

    The resulting fields are made available to the next actions:

  With these set of fields you can then use Run a set of actions multiple times┬áto launch actions for each fetched row.

© 2008-2021   FrozenFrog Software    PAD file     Privacy Policy & Terms of Use