How to pass a variable to a query?

[Tom Murphy]

I want to enter a url of the form "http://www...../index.htm?MC001" and pass the "MC001" to a query string. The query string I have now is:

 qry = "SELECT QRID, QRContent FROM " & tablename & WHERE QRID= '" & request.querystring() & "'"
 

Why does this not work?

[Frinavale]

It doesn't work because you need to specify the variable to retrieve from the QueryString.

Right now you have no variable name defined...which is your first problem.

Your query string should look like

"http://www...../index.htm?idCode=MC001"

Now you can retrieve "idCode" from the QueryString to get MC001:

Dim idCode As String = Request.QueryString("idCode")
 

-Frinny