Variable's value instead of name

[JimEkleberry]

How do you use the value of a variable in a statement instead of it's name?

For example, you have a function

   Sub QueryDB(strRSName, strQuery)
      Set strRSName = Server.CreateObject("ADODB.Recordset")
      strRSName.Open strQuery, objConn, adOpenStatic, adLockReadOnly
   End Sub

but this function will create a recordset actually named strRSName instead of the value that it was passed.

I am sure that this is easy but I cannot find the answer after searching 3 web sites, including Microsoft, and 2 books.

Perhaps I just do not know the proper name to look for.

Thanks for any help that you can provide.

 

[tlhawkins]

Hey Jim,

Use Eval for this.

I think the syntax would be :
dothis = "Sub QueryDB(" & strRSName & ", strQuery)
Set strRSName = Server.CreateObject(""ADODB.Recordset"&quot"
eval(dothis)
dothis = strRSName & ".Open strQuery, objConn, adOpenStatic, adLockReadOnly"
eval(dothis)
End Sub

the idea is to create the line of text exactly as you want ASP to see it then EVAL(uate) that expression.

There is another way using Execute to do more then one line of code at a time but I don't use it often so I wont try to tell you how to use it.

I hope it helps...