Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

CGI and MSAccess

Posted on 1997-05-12
1
Medium Priority
?
179 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 5

Accepted Solution

by:
icd earned 150 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] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

It is a general practice to get rid of old user profiles on a computer  in a LAN environment. As I have been working with a company in a LAN environment where users move from one place to some other place at times. This will make many user profil…
Active Directory replication delay is the cause to many problems.  Here is a super easy script to force Active Directory replication to all sites with by using an elevated PowerShell command prompt, and a tool to verify your changes.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
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…
Suggested Courses

618 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