Contents

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

 
Home
ASPRunner Professional 6.1 manual
Prev Page Next Page
 
 

Working with projects

 

Project structure

With ASPRunnerPro, you can save all your settings in a single project file and do not have to go through individual files if you simply need to change a single label or field format.

For each project ASPRunnerPro saves to its own directory with the following subdirectories:

  1. visual - Contains modified visual templates.

  2. tmp - Temporary storage of visual templates.
  3. output - Directory with output files. You can change or rename the Output directory.

The default directory for a new project is C:/Documents and Settings/Name/My Documents/ASPRunnerProjects/project_name. The Project file will be saved in the project directory as project_name.aspr.

When you open a project created with a previous version of ASPRunnerPro, you are prompted to choose a project directory. After you select a directory, your project file is copied to it. Then the next time you open your project it will be from the folder you selected, not from the original location.

If you upload files to the Web server using third party FTP client software, you must upload the entire contents of the output directory.

When you make a backup of your project, you should include all files in the project directory together with all subdirectories. At a minimum, you should backup the project file itself along with all files in the visual directory.

Click the Project button and select from the drop down list to open an existing project or to save the current one.

Creating new project

When you create a new project you have two options:

  • Create a new project from scratch using Application Wizard

  • Create a project from the template

More info on templates that are shipped with ASPRunnerPro.

Opening an existing project

To open existing project or save a current one, click the Project button any time.

Saving a project

If you want to save the current project under a different name - for example, development purposes or to create a backup - select the Save Project As option. A new project directory will be created and all necessary project files will be copied to it.

Note: ASPRunnerPro creates a new project automatically upon startup.

Saving your project as a Template

You can save your project as a template.

In this case, your database along with your project file and all files you have edited with the visual editor will be saved.

Note: Save Project As Template option is available only for those projects that have been built using MS Access database (MySql).

While saving Project As Template you need to type in the template name you wish your project to be saved under. The template will be saved in the Business Templates Directory (by default in C:\Program Files\ASPRunnerPro6.1\templates\business).

Note: After your template is saved, you can add files that are not generated by ASPRunnerPro to the template directory.

After that saved Template will be available on the list of templates when you create a new project.

You can also add a thumbnail image to the template that will be displayed on templates list. Place an image named preview.gif (JPG and PNG formats are supported also) to template folder. Image size should be 130x97.

Add template to the project

You can create new project using two templates or add a template to existing project. To aviod replacing template tables with existing all ASPRunnerPro business templates (tables and files) have prefix.

 

Converted from CHM to HTML with chm2web Standard 2.83 (unicode)