frontpage results from excel database

[Michael Hoeben]

Can anyone help please? Perhaps I phrased the SUBJECT
line incorrectly so I have copied the original problem &
some subsequent developments into this new thread.

Thanks
Michael

-----Original Message-----
I forgot to mention that I don't need to save the search
results anywhere. They just need to be displayed to the
user.

Michael

Have made a bit of progress.
I created a new page & a new database connection. Added
one field (product code) as my criteria & saved the page

I can input the search term (a product code) but the
entire excel database spreadsheet appears instead of just
the item I required.

Frankly, I don't even know what I did to get THAT to
work, but I went & added a 2nd field (description) to the
criteria. Saved the page & uploaded it.

However, when I do a search on that field, the entire
database spreadsheet appears which I don't want.

Advice appreciated please (before I lose ALL my hair ;-(
Thanks
Michael

.

..

 

[MD Websunlimited]

Michael,

What is it you wish to accomplish?

 

[Michael Hoeben]

I want any surfer to my site to be able to search for a
product by specific code or description or product
category.

The result must appear, then they can either click BACK &
perform another search or surf away.

The result does not need to be saved anywhere.

I have made the database connection, edited the list of
fields I want them to see in the results, selected the 3
criteria above (productcode "equals", description &
category "CONTAINS" and using "OR" for each.

I have selected output of 1 per row. Display all records
together, and checked the Add search box. Then saved the
page as ASP.

That doesn't work so I edit the form properties changing
the method to "GET" but I don't know what to put in the
ACTION field apart from the filename.

Sorry its so long winded, but I wanted to explain that I
have looked at a number of things, but I cannot see the
wood for the trees.

Thanks
Michael

-----Original Message-----
Michael,

What is it you wish to accomplish?

--
Mike -- FrontPage MVP '97-'02
J-Bots 2004 Released Special Pricing
http://www.websunlimited.com
FrontPage Add-ins Since '97 FP 2003 / 2002 / 2000 Compatible

"Michael Hoeben" <[email protected]>

wrote in message [email protected]...

 

[Michael Hoeben]

Thanks for everyones help, but my host advises that they don't support ASP as
I am on a Unix/Linux server.
So now I need to look at PHP or cgi scripts for what I want to do.

Thanks again
Michael

 

[Ronx]

Unix will not support Excel or Access either. You will have to use mySQL
database, or flat .csv text files.