Results 1 to 3 of 3

Thread: passing variables to Access query

  1. #1
    Join Date
    Apr 2004
    Posts
    2

    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

  2. #2
    Join Date
    Apr 2004
    Posts
    20
    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.

  3. #3
    Join Date
    Apr 2004
    Posts
    2

    wooow...

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •