Using W3-mSQL with mSQL

Configuring the Server to Automatically Process W3-mSQL Files

W3-mSQL provides a programatic interface to the mSQL database system from within an HTML document. It enables the development of entire programs within a WWW page while offering comprehensive access control and security features.

W3-mSQL achieves this by providing a complete programming language embedded within an HTML document. The language, called Lite, is similar is style and syntax to the C programming language and the ESL scripting language. Using W3-mSQL and the embedded Lite language, you can generate HTML code "on-the-fly" in the same way you do when you write custom CGI programs. What's more, you can mix normal HTML code with W3-mSQL code so that you only need to use the CGI styled approach where you actually have to.

Installation
To install W3-mSQL on your virtual server, connect to your Virtual Server using Telnet or SSH and untar the W3-mSQL archive file into your virtual server directory structure:

% cd    (this will put you in your home directory)
% vinstall w3-msql

Configuration
W3-mSQL enhanced html files must be preprocessed by the ~/www/cgi-bin/w3-msql executable before the server sends the results to the requesting client. Normally, this preprocessing requires the ~/www/cgi-bin/w3-msql executable to appear in the URL of each W3-mSQL file on your site:

http://www.yourdomain.com/cgi-bin/w3-msql/file.msql

The Apache Web Server can be configured to automatically preprocess W3-mSQL files with the .msql file extension. To setup W3-mSQL redirection, add the following lines to the httpd.conf file on your virtual server:

AddHandler htmsql msql
Action htmsql /cgi-bin/w3-msql

After doing this, it is possible to access W3-mSQL files this way:

http://YOUR-DOMAIN.NAME/file.msql

The .msql files are automatically pre-processed by the ~/www/cgi-bin/w3-msql CGI without the ~/www/cgi-bin/w3-msql CGI appearing in the URL path.

SEE ALSO:

Miva/HTMLScript

mSQL User's Guide

mySQL User's Guide

PostgreSQL User's Guide

CGI Scriptorium

Server Add-ons

BOOKS TO HELP YOU:

Programming the Perl DBI

The Data Webhouse Toolkit : Building the Web-Enabled Data Warehouse