Access 2000, Javascript or ????

[Jon]

I am trying to make a little project.

I have some data that looks like this

8/9202/1000 through 8/9202/1012 = Location "A" with a given contact.

10/9505/1345 through 10/9505/1353 = Location "B" with a given contact.

I have about 25 of these types of entries.

What I would like to create is a little web page that would allow the user to enter, say 8/9202/1008 in a form and have an answer displayed for them that would tell them you need Location "A" with a given contact.


What would be the best way to handle this? I am limited in the fact that I can't use perl, cgi, php etc..

tia

Jon

[FunK]

How are you housing this data again? I'm assuming Access from the title of the thread.

I have not used javascript with a database (not sure if you can), but I think you could use javascript wthout a database if you needed to.

Basically you would have to define your variables. One range = A and the other range = B. Then just write a quick IF THEN statement.

How have you tried it so far? Have you got an example of the code and can you tell us the meaning of the number ranges? It may be hard to define variables if the ranges aren't really chronological.

[Jon]

So far I have the data housed in Access 2000. I've got this working the way I want. The user is prompted for the numbers and a box displays the correct contact and addresses.

I've played around with javascript and can not figure out how to get it to work.

The numbers mean this:


8/9202/1000,
8/9202/1001
all the way through
8/9202/1012

define a length of highway with maintenance and Jurisdiction being under the responsibilty of Mr. A

10/9505/1345
10/9505/1346
10/9505/1347 through 10/9505/1353

define a length of highway with maintenance and Jurisdiction being under the responsibilty of Mr. B.

Could you show me a quick example of the type of conditional you are talking about?

tia
Jon

[FunK]

I had to save this as a txt file as I was having a hard time lining everything up after posting.


Click here for post (http://telecomgeeks.com/Misc/DB.txt)

I'll post back again if you have questions.
I'll also try to dig up some more info on the javascript stuff.

FunK

[Jon]

Thank You very much!

I am going to work on it again tonight if I get some time.

[FunK]

If you don't mind me asking, what kind of a server is this running on? Have you thought of, or do you have the means to run this on a site that supports PHP? It would make things a whole lot easier. PHP is the bomb!


BTW, this is a GREAT Site for web programming.

http://www.devguru.com/

I was doing some quick searches and didn't find anything right away about javascript and databases.

I'll search some more, probably tomorrow.