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-2024 Triple Click Software
News & Updates

Privacy Policy & Terms of Use
PAD file·Old news