Solved

CGI and MSAccess

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction:   Welcome to my first article ever. To begin with, the reason I write this article.  I participated in a question on Experts Exchange about the start command in Windows and there were some discussion about the usage. The discussio…
Batch, VBS, and scripts in general are incredibly useful for repetitive tasks.  Some tasks can take a while to complete and it can be annoying to check back only to discover that your script finished 5 minutes ago.  Some scripts may complete nearly …
Learn the basics of while and for loops in Python.  while loops are used for testing while, or until, a condition is met: The structure of a while loop is as follows:     while <condition>:         do something         repeate: The break statement m…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

920 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now