The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How can I build a Dynamic Query?

I am trying to build a page that checks the query string as the page is loaded. On the previous page, the person can select either an author or a title, thus producing the url article.asp?author=daniel or article.asp?title=ASP Tutorial.

How can I dynamically create my SQL Statement so I dont have to repeat code?

In your If statements you could build up the SQL string, and not execute it until the end. Depending on what you want to do, you could just build up the WHERE clause inside the If to avoid more repetition. So it might be something like:

Obviously you could change the structure of the If statements as needed - you may allow both author AND title to be queried on for example, or you may allow partial searches using LIKE. But the general idea is to build up your SQL string in the If's, so you only need to write the rest once.