Solved

Script for searchable database (Access)?

Posted on 1998-12-17
15
280 Views
Last Modified: 2013-12-25
Hi!  I need a good cgi script (or perhaps something else?) to enable users to search an Access database from a web site.  (I'm designing the web site.)  I understand the beta version of Office 2000 enables this process, but I'm wondering if there's another way... by the way, the database is 20,000 entries (but only about 3 columns).  Thanks!  Carol Clark
0
Comment
Question by:CarolClark
[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
15 Comments
 
LVL 6

Expert Comment

by:PBall
ID: 1857376
Please specify what scripting language? ASP? PERL? something else?

Or are you also considering client-side data-binded pages?

0
 

Author Comment

by:CarolClark
ID: 1857377
Well, looks like I'm already over my head again.  I have a little experience with cgi/perl but not with asp... and I've never heard of client-side data-binded pages.  So... although I thought it would be a matter of simply plugging in a cgi/perl script, it may be a much bigger project?  If so, PBall, what would you charge to engineer this for me?

Thanks.

Carol
0
 

Expert Comment

by:dhinckle
ID: 1857378
Carol,

What do you need for this script to do? I may be able to help you out.

DLH
0
Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

 

Expert Comment

by:dhinckle
ID: 1857379
I can't chew gum and think at the same time...

I'll rephrase the question: What do you need this script to do?

LOL

David
0
 

Author Comment

by:CarolClark
ID: 1857380
David,

Here's how I would like this to look, from the user's point of view:  Web site has a search blank and button.  User types in, e.g., "red" and the script searches for everything in the database that has "red" in it, then puts up a page with a listing of all the "red" items.  If we can get a little fancier, I'd like the user to be able to click on, say, the third item on the list and have that line of info be inserted into an e-mail to the site owner so the user can order that particular item.  (We're not going to do credit cards yet, but the site owner wants people to order items through e-mail.)

Carol
0
 

Expert Comment

by:dhinckle
ID: 1857381
I can't chew gum and think at the same time...

I'll rephrase the question: What do you need this script to do?

LOL

David
0
 

Expert Comment

by:dhinckle
ID: 1857382
Carol,

Are you running your own NT server or is someone else hosting the database?

How will the database be maintained? If updating from a browser (records added, deleted, edited), will images/pictures be required?

Can you provide a complete description of the database, including field names? Also will need to know the fields you want to search on and how you want to search them...

You might want to email this stuff to me...

David

hinckle@swbell.net
0
 
LVL 4

Expert Comment

by:mcix
ID: 1857383
Carol,

If David is unable to help you, please let us know...

Mc!IX
0
 

Author Comment

by:CarolClark
ID: 1857384
Thanks, mcix (Mc!|X?)... David and I are slinging emails back and forth, trying to get this nailed down... when we come up with a solution (assuming we do), I'll post the overview here... and I'll keep you in mind if he and I can't resolve this... thanks again...

Carol
0
 
LVL 4

Expert Comment

by:raoool
ID: 1857385
Likewise.. good luck. If you need an alternative and...

If you're hosting you're own NT server (or want to host with a provider that allows NT CGIs such as dev-com.com), can provide a simple CGI executable <$150>  that provides search of a FoxPro DBF file (easily exportable from Access); returns list of found records as links to individual records formatted as you'd like. Simple application/all setups and things accomplished in the HTML files. <see www.balancedcare.com/locations/bcclocator.htm as an example -- this looks up records based on state and/or services.

Raoool
0
 

Author Comment

by:CarolClark
ID: 1857386
Thanks, Raoool... I'll keep it in mind...

I'll be back later with more info...

Carol
0
 

Accepted Solution

by:
AnitaP earned 100 total points
ID: 1857387
Hi, I you need help I can be helpful. I am a web page developper and designer. I work for an internet provider and create web pages from A-Z. I can help you for FREE if you like. My services are volunteer work. I have designed this http://www.fantaisie.com site (which is a lingeray site only) it was all done with ASP. I have created the shopping basket from 0. I can help you if you need any help. You can also email me at

agwebdesign@yahoo.com

0
 

Author Comment

by:CarolClark
ID: 1857388
Thank you all... I would like to close the question at this time because, as it turns out, my ISP will be able to do the searchable database plus an auction.  It was easier (and probably less expensive) to sub out that part of the contract to them rather than for me to reinvent the wheel.

My understanding is that they'll use a SQL server to manage this... but I still don't know the fine points...

Thanks!

Carol
0
 
LVL 18

Expert Comment

by:mgfranz
ID: 1857389
I suggest a quick lesson in ASP... run down to your local tech book store and get a good book on building ASP sites.   Everything you ask can be done with a few simple ASP scripts, I know... ;-)
0
 

Author Comment

by:CarolClark
ID: 1857390
I have this site up and running now.  Check it out at www.goldengaterecords.com.  I worked with a programmer at my ISP and I believe he used mostly cgi/Perl to accomplish the backend data crunching.  I'd appreciate any comments people might have--email me at carol@cdclark.com.

Thanks!
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

756 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