Introduction

Welcome

System requirements

Licensing details

What is the registration

Quick start guide

Using ASPRunnerPro

Working with projects

Navigation bar

Templates

What are templates

Cars

Classified ads

Events

Jobs

Knowledge base

News

Paypal

Real estate

Sporting

Vacation houses

Connecting to the database

Datasource tables

Master-detail relationship between tables

SQL query page

About SQL query designer

Query Designer

SQL

Results

Charts

Creating chart

Chart parameters

Chart appearance

Using SQL to shape chart data

Reports

Creating report and setting parameters

Report totals and layout

Choose pages

Choose fields

Fields order and totals

Miscellaneous settings

Security

Login page

User login settings

Advanced security settings

User group permissions

Dynamic permissions

Choose theme

Visual Editor

About

Toolbars

Page Elements

Adding ASP code snippet

"View as" settings

"View as" settings: Custom

"Edit as" settings

Validation types

Lookup wizard

Menu builder

Events

Output directory settings

After you are done

FTP upload

FrontPage Publishing

Advanced topics

Events

Predefined actions

Send a simple email

Send an email with new data

Send an email with old data

Save new data in another table

Save old 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

Sample events

Appearance

Add dropdown list box with values for search

Add foldable section

Change cell background color

Change row background color

Disable record editing

Hide controls on Add/Edit pages, based on logged user name

Redirect to details page after master record was added

Show data from master table on detail view/edit/add page

Show pop-up window

Make search button return data only when search value was entered

Database

Before deleting a record check if related records exist

Show list of customer orders

Select multiple values from checkboxes or a list field and have them appear as individual database entries

Update multiple records on the List page

Update multiple tables

Dynamic SQL query

Record locking

Email

Email selected records

Send an email with updated fields only

Send mass email to all users

Upload

Check size and extension of uploaded files

Rename uploaded files

Upload files to users folders

Misc

Check if start date is ealier than end date

Speed up data entry using events

Save user data in session variables

Implementing 'single sign on' feature

Redirect to user info edit page

Global events

Login page

Before process

Before login

After successful login

After unsuccessful login

Before display

Menu page

Before process

Before display

Register page

Before process

Before registration

After successful registration

After unsuccessful registration

Before display

Change password page

Before process

Before change password

After password changed

Before display

Remind password page

Before process

Before password reminder sent

After password reminder sent

Before display

After application initialized

Table events

Add page

Before process

Before record added

After record added

Before display

Copy page

OnLoad

Edit page

Before process

Before record updated

After record updated

Before SQL query

Before display

List page

Before process

Before record deleted

After record deleted

After group of records deleted

Before SQL query

Before record processed

After record processed

Before display

Printer-friendly page

Before process

Before SQL query

Before record processed

After record processed

Before display

View page

Before process

Before SQL query

Before display

Search page

Before process

Before display

Export page

Before process

Before SQL query

After table initialized

Page life cycle overview

Programming topics

ASPRunnerPro session variables

ASPRunnerPro templates

Data Access Layer

Debugging tips

How to control Inline Add/Edit functionality from script

Master-details relationships

runner_mail function

Template files processing rules (Files.txt)

Template language

Troubleshooting "Operation must use an updateable query" errors

Useful functions and links

Using JOIN SQL queries

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

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

Enterprise Edition

Online report/chart builder

Online report/chart builder v2.0 - Installation notes

Creating web report

Creating web chart

Internet Information Services (IIS)

ODBC

AJAX-based Functionality

Multilanguage support

Stylesheets

Rich Text Editor plugins

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 ASPRunnerPro online

Send an email with updated fields only

To send an email with updated fields only use the following code in Edit page: Before record updated event.

Note: Change the values listed in red to match your specific needs.

set rmail=CreateDictionary()



body = "Changed fields" & vbcrlf

for each key in values.Keys

    if not IsEqual(values(key),oldvalues(key)) then _

        body=body & key  & ": "  & values(key) & vbcrlf

next

rmail("to")="test@test.com"

rmail("subject")="Sample subject"

runner_mail(rmail)