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
Solved

Script for searchable database (Access)?

Posted on 1998-12-17
15
274 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
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
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
keyword rich ebay title, description 2 47
ebay devID, appID, certID, userToken 2 51
hbo knew my windows software 4 62
Setting up JqueryUI with MVC 5 in Visual Studio 5 24
Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

856 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