Page life cycle overview Home

Introduction
Welcome
System requirements
Licensing details
What is the registration
Using ASPRunner
Working with projects
Templates
What are templates
Cars
Classified ads
Events
Jobs
Knowledge base
News
Paypal
Real estate
Sporting
Vacation houses
Connecting to the database
Datasource tables
SQL query page
About SQL query designer
Query Designer
SQL
Results
Charts
Creating chart and setting parameters
Chart appearance
Using SQL to shape chart data
Reports
Creating report and setting parameters
Report totals and layout
Choose pages
Login page
User login settings
Advanced security settings
User group permissions
Fields order and totals
Miscellaneous settings
Choose theme
Visual Editor
About
Toolbars
Page Elements
"View as" settings
"Edit as" settings
Validation types
Lookup wizard
Events
Output directory settings
After you are done
FTP upload
FrontPage Publishing
Advanced topics
Connecting to database
Connecting to MS Access database
Connecting to MS SQL Server database
Connecting to FoxPro database
Connecting to MySQL database
Connecting to Oracle database
Connecting to MS Excel database
Connecting to CSV or Text file
Events
More about events
Global events
Table events
Page life cycle overview
Predefined actions
Send simple email
Send email with new data
Save new data in another table
Insert a record into another table
Check if specific record exists
Display a message on the Web page
Redirect to another page
Custom code
Sample code
Show list of customer orders
Check if start date is ealier than end date
Before deleting a record check if related records exist
Speed up data entry using events
Publishing ASP application to the remote Web server
Using third party FTP client to publish ASP pages to the remote Web server
Using FrontPage to publish ASP pages to the remote Web server
Demo account
What is the Demo Account?
Terms and Conditions
Master-details relationships
Using JOIN SQL queries
AJAX-based Functionality
ASPRunner session variables
Debugging tips
Template files processing rules (Files.txt)
Multilanguage support
Useful functions and links
Smarty templates
Stylesheets
Template language
Rich Text Editor plugins
How to control Inline Add/Edit functionality from script
Troubleshooting "Operation must use an updateable query" errors
ODBC
Upgrade Guide from ASPRunnerPro 4.0 and older
Frequently Asked Questions
Error: Operation must use an updateable query.
Error: Syntax error in UPDATE statement.
Error: Syntax error in INSERT INTO statement
Error: Login failed for user 'MACHINE_NAME\IUSR_MACHINE_NAME'
Error: Data type mismatch in criteria expression
Error: The Microsoft Jet database engine cannot open the file (unknown).
Error: Unable to open registry key 'Temporary (volatile) Jet DSN for process ...
Error: Data provider could not be initialized
Error: Invalid use of Null: 'Replace'
Error: Specified driver could not be loaded due to system error 5 (Oracle in OraHome92)
How can I add new ODBC Datasource
Error: Too many fields defined
Error: I enter correct login and password but receive Invalid Login error. I use SQL Server.
I cannot find ODBC Administrator applet on Windows 2000 machine
I cannot connect to my Excel (Access) database
Where can I download latest ODBC drivers
How to work with Access database stored on the remote computer?
Reserved Access, T-SQL, ODBC keywords.
Order ASPRunner online

 
 ASPRunner manual


Page life cycle overview

When a ASPRunner-generated page runs, the page goes through a life cycle in which it performs a series of processing steps. These include initialization, retrieving data, instantiating controls and rendering. It is important to understand the page life cycle so that you can write code at the appropriate life-cycle stage for the effect you intend.

 

List/Print pages

BeforeProcessList

BeforeProcessPrint

 

Occurs when page processing starts and database connection is established.

Use this event for the following:

- change database connection to point to another database

- read request data and populate session variables

- redirect to another page

BeforeDelete

This event will be executed once for each record to be deleted.

Use this event for the following:

- prevent a record from being deleted

- save deleted record in another table

 

AfterDelete

Occurs once for each record after it was deleted

AfterMassDelete

Occurs after bulk delete opearation

BeforeQueryList

BeforeQueryPrint

Occurs right before SQL query that retrieves data is executed. Use this event to modify SQL query i.e. to add an additional filter (WHERE clause).

BeforeProcessRowList

BeforeProcessRowPrint

Occurs after database record is retrieved from the database before formatting is applied.

Use this event for the following:

- modify value of any column

- prevent certain records from being displayed on the page

- calculate/display your own totals and subtotals

BeforeMoveNextList

BeforeMoveNextPrint

Occurs after database record is retrieved from the database and formatting is applied.

Use this event for the following:

- display an empty row or a header between group of records.

- apply additional formatting to any column

 

BeforeShowList

BeforeShowPrint

Ocurrs after page is processed and ready to be displayed in the browser.

Use this event for the following:

- define a new Smarty variable or change the value of existing one

- display different template

 

Edit/Add pages

BeforeProcessEdit

BeforeProcessAdd

Ocurrs after page is processed and ready to be displayed in the browser.

Use this event for the following:

- define a new Smarty variable or change the value of existing one

- display different template

BeforeEdit

BeforeAdd

Occurs before new data is written to the database.

Use this event for the following:

- prevent data record from being added or edited

- send an email

- save old record in another table

- add a record to the log table

AfterEdit

AfterAdd

Occurs after data was written to the database.

Use this event for the following:

- send an email

- add a record to the log table

BeforeQueryEdit

Occurs right before SQL query that retrieves data is executed. Use this event to implement additional security i.e. set SQL query to empty string if for any reason editing is not allowed at this moment.

BeforeShowEdit

BeforeShowAdd

Ocurrs after page is processed and ready to be displayed in the browser.

Use this event for the following:

- define a new Smarty variable or change the value of existing one

- display different template

 

Login/Registration pages

BeforeProcessLogin

BeforeProcessRegister

Ocurrs after page is processed and ready to be displayed in the browser.

Use this event for the following:

- define a new Smarty variable or change the value of existing one

- display different template

BeforeLogin

BeforeRegister

Occurs before user logs in or new user data is written to the database.

Use this event for the following:

- prevent user from being logged in or registered

- send an email

- add a record to the log table

 

AfterSuccessfulLogin

AfterSuccessfulRegistration

Occurs after user is logged in or registered successfully.

Use this event for the following:

- redirect user to another page

- send an email

- add a record to the log table

 

AfterUnsuccessfulLogin

AfterUnsuccessfulRegistration

Occurs if user was not logged in or was not registered.

 

BeforeShowLogin

BeforeShowRegister

Ocurrs after page is processed and ready to be displayed in the browser.

Use this event for the following:

- define a new Smarty variable or change the value of existing one

- display different template

 

View/Search/Report pages

  1. BeforeProcess<PageName>

  2. BeforeQuery<PageName>

  3. BeforeShow<PageName>

 

 

 

The CHM file was converted to HTML by chm2web software.