Solved

CGI and MSAccess

Posted on 1997-05-12
1
175 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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Making a simple AJAX shopping cart Couple years ago I made my first shopping cart, I used iframe and JavaScript, it was very good at that time, there were no sessions or AJAX, I used cookies on clients machine. Today we have more advanced techno…
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 look for a specific file type in a local or remote server directory using PHP.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

808 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