Solved

CGI and searching an Access DB

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Reading variable length EBCDIC in SAS 9 108
PowerShell Get-Help 10 76
Batch command to determine the Office version installed 2 127
powershell code to list items in dropdown 6 60
In this tutorial I will show you how to provide a dynamic RTF document on your website generated with data from your database. For this tutorial you will need Microsoft Word or WordPad, WhizBase and Microsoft Access. In this tutorial I will show …
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.
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 …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

776 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