• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 159
  • Last Modified:

Local Database search

I have a informative CD that I created that is set up like a website but housed on the CD.  I want to create a rate seach where the client puts in a sales price and it returns rates from different catagories.  The rates will be housed in a database on the cd.  Is this something that is possible and how do I do it?

Thanks for any help!!!

0
liv4fun
Asked:
liv4fun
  • 3
  • 2
  • 2
  • +1
1 Solution
 
rockmansatticCommented:
Not using basic methods of database search.  Definitly not use DW.  this question would be better asked in another section.  

Becasue the database and the website will be onthe local machine, the user would have to have IIS running on their machine and I could see a lot of complication hapening.  
For basic search functions of a database, you must first have a connection , with usually is via asp or php code and the presents of IIS or SQL server.  Since this cannot be on the CD, then no, wont be that easy.

I will look further into it for you.

Rockman
0
 
rockmansatticCommented:
The only thing I could find would be a possible Javascript solution
I you could connect to the database via js and have it search, that may work.


this may help
http://www.oreilly.com/catalog/jscook/chapter/ch01.html

Good Luck
0
 
liv4funAuthor Commented:
I should say it is a Database.  I am just trying to do a basic look up.  An amount return 3 different figures.  Is it that much work to do that?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
rockmansatticCommented:
I have never done that much Javascript, but I would think that it woulnt be too difficult considering how easy JS is as a whole.

Rockman
0
 
Neil_SimpsonCommented:
If you are only doing a basic lookup then you could just store the required values in a Javascript array which will be contained within your webpage and will therefore work online as well as on a CD.
0
 
liv4funAuthor Commented:
Can anyone give me an example of how the JS should be written.
0
 
Neil_SimpsonCommented:
You would use a technique similar to http://www.experts-exchange.com/Web/Q_21020448.html.

Rather than populate a second menu with the value from the drop down menu, you could use the value as your lookup to determine which numbers to use in your calculation.
0
 
nishasrilankanCommented:
if you are suing MS-Access databse, You can use data accesspage...its so easy
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now