FmPro Migator VFP Code Converter FmPro Script Diff SQLite Diff Screenshot Toolbar Printer Maintainer

CGIScripter Demo Available for download...

CGIScripter creates 15 files (including Perl, HTML, and SQL code) for each form which has been defined within the CGIScripter application. This page provides descriptions of the generated output files, links to sample files created by CGIScripter and flowcharts for Perl CGI script processing. Click on the link to the example filename to see the output file generated by CGIScripter.

Filename	Features
example_create_table1.sql	This sql script creates the Oracle user, tablespace and table for the web application data. Notes: The Oracle DBA should review and update the DDL code within this file prior to creating the tablespaces, table, sequence, and trigger. The sequence start value (if implemented) should have the starting number determined by the DBA. The Oracle VARCHAR2 column widths should be reduced to the maximum size actually used within the web application. CLOB/BLOB datatype columns may be stored within locally managed tablespaces with Oracle 9.2.0. Otherwise, a dictionary managed tablespace should be used.
example_instructions.txt	This file contains the setup, usage and troubleshooting instructions for the Perl CGI scripts generated by CGIScripter.
example_submit1.html                   Submit Form Flowchart	This HTML submit page POSTs information to the example_submit1 CGI script.
example_submit1	This Perl program accepts web submitted form data, provides data validation and auto-enter processing, then writes the entered data into the database.
example_query1.html                     Query Form Flowchart	This HTML query page POSTs information to the example_query1 CGI script.
example_query1                                   Sample Query List	This Perl program processes web queries which are displayed as a list of query results retrieved from the database.
example_display_record1              Sample Display Record	This Perl program accepts the primary key value passed in the URL then retrieves and displays this one record from the database. If the cnum parameter is passed to this script in the URL, then this script simply passes the GIF or JPEG image data to the browser.
example_update1.html                  Update Form Flowchart	This HTML update page POSTs information to the example_update1 CGI script.
example_update1                                Sample Update List	This Perl program processes web queries which are displayed as a list of query results retrieved from the database.
example_update_record1             Sample Update Record	This Perl program accepts the primary key value passed in the URL then retrieves and displays this one record from the database with updatable fields. If the cnum parameter is passed to this script in the URL, then this script simply passes the GIF or JPEG image data to the browser.
example_update_record_validate1	This Perl program accepts web submitted form data from the update script, provides data validation then updates the specified record in the database.
example_delete1.html                    Delete Form Flowchart	This HTML update page POSTs information to the example_delete1 CGI script.
example_delete1                                   Sample Delete List	This Perl program processes web queries which are displayed as a list of query results retrieved from the database.
example_delete_record_display1     Sample Delete Record	This Perl program accepts the primary key value passed in the URL then retrieves and displays this one record from the database. If the cnum parameter is passed to this script in the URL, then this script simply passes the GIF or JPEG image data to the browser.
example_delete_one_record1	This Perl program accepts the primary key value passed in via an HTTP POST then deletes that one record from the database. For security reasons the primary key column name is hard coded into this script. Also, the referer URL must match the delete_record_display script - or the record will not be deleted.

 

Home | Products | Services | Downloads | Order | Support | Contact

Legal Notices