Solved

CGI and searching an Access DB

Posted on 1998-07-15
1
155 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
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In this tutorial I will aim to show you how simple is making a small application in WhizBase, how to add, remove and update data in the DB. I will make a small address book application where you can add, browse, update and remove addresses. I wi…
If you get a (Blue Screen of Death), your system writes a small file called a minidump. Your first step is to make certain your computer is setup to record memory dumps. Right click My Computer, choose properties. Click on the advanced tab, an…
Learn the basics of lists in Python. Lists, as their name suggests, are a means for ordering and storing values. : Lists are declared using brackets; for example: t = [1, 2, 3]: Lists may contain a mix of data types; for example: t = ['string', 1, T…
Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …

762 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

19 Experts available now in Live!

Get 1:1 Help Now