Solved

CGI and searching an Access DB

Posted on 1998-07-15
1
161 Views
Last Modified: 2013-12-25
For the time being my question is quite easy. I want to use form information from my HTML to search an Access DB located on my own server, and then return the findings to my web page. My problem is that I'm just generally vague in this whole area. I need to know things like: is Access the best medium in which to keep my data? / I am thinking of using VB to search the DB, is this the best method to use? etc. If anyone can point me in the right direction and give me some tips, then that would be great. I know I could research this myself, but time is an issue, and I want to know that at least I'm on the right path before I seriously look into it.

Thanks.......
0
Comment
Question by:nsmith080197
[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 7

Accepted Solution

by:
jconde earned 50 total points
ID: 1830775
Hi nsmith.

First, Access is good enough if you have a "small" ammount of records or information in your database.  With small I mean less than 300,000 records TOPS!

Now, since access is a SQL powered DBM, you don't really need VB to access the database!  All you need to do is create a ODBC and work from there.  Using VB will just  make everything much more complicated and less efficient!  why not install Cold Fusion in your web server?

Cold Fusion is a HTML code extender used primarily to access and display database information in a web page....for example...
Pretend you want to display in a web page table all the records in a database table.  The code would be the following  (In your HTML page)

<HTML>
<BODY>
<CFQUERY NAME="QUERY_NAME1" DATASOURCE="DATASOURCE_NAME1">
SELECT *
FROM TABLE1
</CFQUERY>

<TABLE>
<CFLOOP QUERY="QUERY_NAME1">
<TR>
<TD><CFOUTPUT>#RECORD_NAME_IN_TABLE1#</CFOUTPUT></TD>
</TR>
</CFLOOP>
</TABLE>
</BODY>
</HTML>

I really recomend you try Cold Fusion out......It's Great!
A Trial version of cold  fusion can be found at:
http://www.allaire.com

bye
jorge
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

Title # Comments Views Activity
Example unit tests with AngularJS 3 50
Need some help with powershell script 5 61
powershell switch statement 7 34
.dn property wont validate - Powershell 2 23
I hope you'll find this tutorial useful and interesting. So let's try to extend Tcl with a new package.  For anyone more deeply interested please check out the book "Practical Programming in Tcl and Tk". It's really one of the best written books abo…
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…
Learn the basics of modules and packages in Python. Every Python file is a module, ending in the suffix: .py: Modules are a collection of functions and variables.: Packages are a collection of modules.: Module functions and variables are accessed us…
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 …

726 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