Is there a way to convert a string and return the variable value
Here is some code to show what I'm doing.

dim conn, rs,strSQL,i, tempstr,strSQL1,strSQL2 'etc....

strconn = "connection string"
strSQL = "insert into Guestbook (Name,Comment) "
strSQL1 = "Values('Name 1','Comment 1')"
strSQL2 = "Values('Name 2','Comment 2')"
'etc.

Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
conn.Open strConn


for i=1 to 36
   tempstr = strSQL & Cstr("strSQL" & i)

'at this point I would want tempstr to be
"insert into Guestbook (Name,Comment) Values('Name 1','Comment 1')"
'but I'm getting "insert into Guestbook (Name,Comment) strSQL1

   rs.Open tempstr,conn
   rs.Close
next

conn.Close
set rs = nothing
set conn = nothing

The only way you can achieve this is if you put strSQL1 and strSQL2 into an array and made a call like this:

tempstr = strSQL & Cstr(arr[i])

You can not dynamically reference variables in the manner you have laid out above.

hth.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

I needed this same info for a different use and found an answer that worked. After seeing this answer I'm loading a dictionary and using the constructed string to match the key but....

I seemed to be able to cast the constructed string as my predefined variable by using Eval.

example:

strRegValue = Eval("g_str" & strName & "RegValue")
strMessage = Eval("g_str" & strName & "Msg")
strCommand = Eval("g_str" & strName & "Command")

wscript.Echo strRegValue
wscript.Echo strMessage
wscript.Echo strCommand

Returned my g_str......... variables for each strname in my loop.

I'm new here so hate to speak out but seems to work for me..

Thanks for the input Twisted. I was unaware of Eval() ability to do this. Personally I still prefer some sort of collection as opposed to dynamically referencing a variable name, but that's just me.

-Doug

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========

Thanks,
I ended up creating an array and it works fine.
I'll give the eval() function a try.
I wasn't aware you could use eval that way.
I wonder if there is any difference in processing time between the two approaches.