Formatting options 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
Master-details
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
Dynamic 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
Data Access Layer
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
Enterprise Edition
Online report/chart builder
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
ASPRunner 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


Visual Editor - "Edit as" settings

 

You can customize your data appearance on the add/edit/advanced search pages using formatting options on the "Edit as" settings dialog. To control the filed appearance on the page click right button over the field and choose Properties. Depending on selected format you will see different box-dialogs.

"Edit as" formats

Fields format you've chosen is preserved on the Advanced search page, for example, drop-down boxes, date-pickers, checkboxes formats.

Text field - simple text box

See list of available validation types here.

Default value

Now() - current datetime

Session("UserID") - user id of person who updated the record

Request.ServerVariables("remote_addr") - IP address

Apply on the Edit page as well

If you check off this check box default value will be applied every time record is updated. You can use this feature to keep track of who and when updated the record.

Text area - mutlitrow text area. For advanced WYSIWYG edit capabilities check off "Use Rich Text Editor" checkbox.

More info about choosing Rich Text Editor.

Password - password field. All entered characters appear as "*".

Date - date edit control. You can choose between simple edit text box, drop-down boxes with day, month and year selection, and advanced datepicker.

Simple edit box with datepicker also allows to enter time.

Radio-button - use a radio button control to limit a user's selection to a single value within a set of values.

 

Checkbox - checkbox control. Works best with the following datatypes:

MS Access: Yes/No field

SQL Server: TINYINT or BIT field

MySQL: TINYINT

Oracle: NUMBER(1)

Image/File- depending on field type this control allows to upload images and files to the database (binary field) or to some directory on the Web server (text field). ASPRunner also makes it possible to create thumbnails on the fly. If you want to do this then you should select the appropriate checkbox and:

Binary field - choose thumbnail size and the field name in which the thumbnail will be saved.

Text field - choose thumbnail size and thumbnail prefix.

For example, if the original image file's name is example.gif and thumbnail file's name is th_example.gif correspondingly then the thumbnail prefix should have the value of "th_".

Note: To work with thumbnails you need to have ASPJpeg component installed on the Web server. Most Web hosting companies have this component installed.

Lookup wizard - drop-down box with list of values.

Readonly - use this format for a field that should not be edited.

The CHM file was converted to HTML by chm2web software.