Blue Reef Technical Support ResellersAbout Blue Reef Consulting, Inc.

EcommerceSearch
Return to Blue Reef Virtual Servers Home Page
Order virtual servers, software, computers, and more!
Return to Blue Reef Main Home Page
Specials
Site Map
Support Solutions to help you do business with your Virtual Server.



Virtual Servers Home Page
Virtual Server Support
Virtual Server Addons
Database Solutions
Database Overview
mSQL Overview
mSQL and MS Access
mSQL and W3-msql
mySQL Overview
MySQL and MS AccessMySQL and MS Access
MySQL and ColdFusionMySQL and ColdFusion
PostreSQL Overview
Request help using our Problem Tracking System
Order a Blue Reef Virtual Server now!


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
Programming the Perl DBI


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

Amazon.com logo
Search for :
Enter keywords...