Solved

CGI and MSAccess

Posted on 1997-05-12
1
176 Views
Last Modified: 2013-12-25
I am setting up a Website that will have a form webpage that the data will be submitted to a MSAccess db, then run some VB functions on the database, then call another program to use the output to create a new .dxf file to view on their browser(or download to their disk), can you give me an outline of such a script in Visual Basic(we have a VB programmer on site)?
0
Comment
Question by:varname
1 Comment
 
LVL 5

Accepted Solution

by:
icd earned 50 total points
ID: 1828010
When a form is submitted the form 'action' will be to call the VB program. All of the form data will then be available to the VB program to do with as it wishes.

The VB program should verify the data received and output an HTML document (to stdout) which it generates depending upon the action it is taking (e.g. report any errors in the data or confirm that the data has been accepted) as well as updating the database.

If you are creating another .dxf file then presumably you will need to create HTML links to it. I assume that this will require modification to an 'index' html file which has the URL to each database file. The VB script will need to modify this file as well by adding the new link.

I suggest that you should create 'dummy' html documents which show how the generated HTML should look. e.g. one for a typical error condition, one for the confirmation that the database has been updated. Check that the HTML is correct first (e.g. the links work and the layout is correct) and then use these 'templates' as part of the specification for the VB programmer.

There are likely to be standard library routines that allow a VB program to access the form data and make your VB programmers job easier. Look for something like 'cgi lib' although they are not difficult to write.

0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This tutorial will discuss the log-in process using WhizBase. In this article I assume you already know HTML. I will write the code using WhizBase Server Pages, so you need to know some basics in WBSP (you might look at some of my other articles abo…
In this tutorial I will show you how to make a simple HTML bar chart with the usage of WhizBase, If you want more information about WhizBase please read my previous articles at http://www.experts-exchange.com/ARTH_5123186.html (http://www.experts-ex…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question