passing variables to Access query

Hi there.

I have a simple query in an access db named "test" as shows below :

PARAMETERS test Text ( 255 );
SELECT Category.Description
FROM Category
WHERE Category.Name=test;

How do I call this query from a asp-page and how do I pass a variabel into a query from a asp-page ?

regards
Michael

The best way to run a parameter query from an ASP page is to create the query at run time (inside the asp page).
Try this:
1. create a parameter query;
2. save the query and select Export
3. select save as type ASP page
At the end of the wizard two file will be created: html page and asp page.
html page will call the asp page passing it the value of the parameter.
If you look at the asp code you can see that query is created at runtime.

Hi.

Thanks for the tip.
That was really easy.
I did not know I just could export queries as asp-pages.
I think I will play around some more with that feature.

Regards
Michael :)