Agent System Variables

Content-type: text/html Agent System Variables

WebGroove is no longer supported. These docs are reference only.

Agent System Variables
The following Agent system variables may be of use to you in your scripts. They are stored in the sys hash and may be accessed as normal variables.

sql	Last SQL statement executed
num_rows	Number of rows returned by last SQL
row_num	Current row number
num_pages	Number of pages from last paged SQL
insert_id	Value of inserted auto increment column (MySQL only)
page_num	Current page number
prevpg_link	URL for previous database page
nextpg_link	URL for next database page
errtype	Last error type (RUN, SYS, SQL, PERL)
errcode	Last error code (ODBC error code, etc)
errtext	Last error message
path	Path of current script file
filename	Filename of current script
fileroot	Basename of current script (no extension)
date	Current date (mm/dd/yyyy)
time	Time script was started (hh:mm:ss)

Up To

Agent Variables

Error Handling

Query Paging

WebGroove® is a registered trademark of Creativision Publishing Corporation