Database Serach

I look after a site for a national organisation in the UK. They have a
membership of around 700. I have been asked to develop a search facility so
that the public can search and find a member in their area, probably by
county, (similar to State in the USA).



Or by a form that allows 2 search criteria, i.e., 1) Town and 2) County.



The organisation keep the membership list in Excel but I could import this
into Access. What I need is a way to search the database, (i.e., located
somewhere on the server) from a web page and then give the results of the
search.



Anybody got any simple solutions? Javascript maybe?

[Ian Lewis]

I have what sounds like a similar search funstion on one of my sites.
It's a fairly simple .asp script looking at an Access database which is
not in the html files area (though it could be). You would need asp on
your server, of course. The database has around 400 entries.

Take a look at www.farnfilm.com/uktv.htm. I'd be happy to send you the
code if this appears to do what you want.
Ian



jim@ajs-digital.co.uk wrote:
> I look after a site for a national organisation in the UK. They have a
> membership of around 700. I have been asked to develop a search facility so
> that the public can search and find a member in their area, probably by
> county, (similar to State in the USA).
>
>
>
> Or by a form that allows 2 search criteria, i.e., 1) Town and 2) County.
>
>
>
> The organisation keep the membership list in Excel but I could import this
> into Access. What I need is a way to search the database, (i.e., located
> somewhere on the server) from a web page and then give the results of the
> search.
>
>
>
> Anybody got any simple solutions? Javascript maybe?
>
>

Thanks Ian,

It looks like it may just be the thing that I need.
I have played around with the "Data Publishing" features in Fusion 10 but
have this very confusing as I cant seem to just search data held on the
server.

My email address is below if you could send me your asp file.

Many thanks,
Jim Shorrock

"Ian Lewis" <ian@farnfilm.com> wrote in message
news:f39bgl$bkq2@flsun90netnews01.netobjects.com.. .
>I have what sounds like a similar search funstion on one of my sites. It's
>a fairly simple .asp script looking at an Access database which is not in
>the html files area (though it could be). You would need asp on your
>server, of course. The database has around 400 entries.
>
> Take a look at www.farnfilm.com/uktv.htm. I'd be happy to send you the
> code if this appears to do what you want.
> Ian
>
>
>
> jim@ajs-digital.co.uk wrote:
>> I look after a site for a national organisation in the UK. They have a
>> membership of around 700. I have been asked to develop a search facility
>> so that the public can search and find a member in their area, probably
>> by county, (similar to State in the USA).
>>
>>
>>
>> Or by a form that allows 2 search criteria, i.e., 1) Town and 2) County.
>>
>>
>>
>> The organisation keep the membership list in Excel but I could import
>> this into Access. What I need is a way to search the database, (i.e.,
>> located somewhere on the server) from a web page and then give the
>> results of the search.
>>
>>
>>
>> Anybody got any simple solutions? Javascript maybe?
>>