Sending Variables with ASP, to SQL

Sending Variables with ASP, to SQL

I don’t even know if I said that correctly. I have been using FrontPage2k for some time now. I am getting ride of it today so I can learn to be a real we developer. Now that I will not have some program to build my ASP pages I am going to be doing it by hand, however, I am having some problems.

First of all, I am currently using a DSN connection. I would like to get rid of that and use a DSNless connection.

Secondly and more important: One of the sites I admin consists of a single page (pages.asp), with a menu that simply sends a variable title back to its self. Then pages.asp query a database for the correct content.

I know the link should apprear as, "pages.asp?title=Home"

I have the connection set up, and it is working, the only problem is the SQL statement.
The statement:
sql = "SELECT * FROM Documents WHERE title = 'About Us' ";
Will correctly bring up the “About Us” page so I suppose the variable title needs to somehow replace ‘About Us’ but I cant find much documentation on this and nothing I have tried has worked.

Any links to more information or help would be greatly appreciated.

Thanks,
Bill Dailey

Ammmm, what exactly is your question? It's a bit unclear from what you said. Do you want to have people navigate your one page site by your ASP script parsing a querystring value called title? And if so, do you want to change the value of title for diff pages?