Using Excel database

[Michael Hoeben]

I wish to enable a search facility on my site so users
can search a product list. But the result does not
display any records or show "no records found".

I followed this article which appeared in an earlier
thread dated 4/10/04,
http://support.microsoft.com/default.aspx?scid=268948
and set up a new connection from scratch - but the issue
remains.

When I first tried the search this message appeared,
Method Not Allowed
The requested method POST is not allowed for the
URL /productsearch.asp.

so i change the method to GET and still nothing - not
even the message of "no records found"
I have saved the page as asp. My example can be seen here.
http://www.kleeneze-people.co.uk/productsearch.asp

I use frontpage2000.

Can anyone help please?

Thanks
Michael

 

[Guest]

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

 

[Michael Hoeben]

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