Solved

CGI and searching an Access DB

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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

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…
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 strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
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…

829 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