|
Description
Function BeforeQuery<PageName> is executed
before SELECT SQL query is processed. Use this event if you like to
modify default SQL query, add a WHERE clause etc.
Syntax
|
BeforeQuery<PageName>($strSQL,$strWhereClause,$strOrderBy)
|
Arguments
$strSQL - SQL query to be
executed.
$strWhereClause - WHERE clause applied
to the SQL query. Example: "active=1".
$strOrderBy - ORDER BY query applied
to the SQL query. Example: "ORDER BY LastName,FirstName".
Applies to pages
List, Print, Export,
Chart
Recommended predefined actions
and sample events
Send
a simple email
Insert a record into
another table
Check to see if a specific
record exists
Display a message on the
Web page
Redirect to another page
Dynamic SQL Query
|
