VBScript - Building Variable Names

to assign value to all of them you can do it like this.
for i = 0 to 11
  acct(i) = "Value " & i
next
now acct will contain
value 0
value 1
value 3
value 4
etc

don't forget to declare it as i showed in first comment
Dim acct(12)

Marine changed the proposed answer to a comment

you can't build variable names like you want to. Why don't you want to use array ?

you can use concanitation on variables but that won't build a variable for you. use array.

The execute function is what you're lookig for here.  Here's a code snippet demoing this (this is clinet side for ASP the msgbox won't work):

<script language=vbscript>
      dim act3,act4
      dim x
      x=3
        act4=7
      execute("act" & x & "=5")
      msgbox act3:msgbox act4
</script>

Also note that I've included the syntax for putting multiple statements on a line - use a colon to distinguish each statement

thats not what he wants. you still have 2 declared separate variables he want to build them at run time which will generate them. It's not possible. All variables must be explicitly defined, thats not true in vb or asp but this means if one doesn't exist you can create one like you want.

The execute command will still do the job:

<script language=vbscript>
      Option explicit
      dim x
      x=3
      execute ("dim act"&x)
      execute("act" & x & "=5")
      msgbox act3
</script>

or

<script language=vbscript>
      Option explicit
      execute ("dim act"&cstr(3))
      execute("act" & 3 & "=5")
      msgbox act3
</script>

with no variables at all created : note the need to explicitly convert to string in the dim statement in the second sample.

First, thanks for all the responses.

I can/will use an array, but I need to eventually assign them to variables as I explained in the initial question.

I'm trying the execute() function, but I get a syntax error. Here's the code snippet...

<%
dim x
for x = 1 to 12
            execute("dim PassExp"&cstr(x))
            execute("PassExp"&cstr(x)&" = '1/1/01'")
next

for x = 1 to 12
            response.write "PassExp"&cstr(x)&"="&execute("PassExp"&cstr(x))&"<br>"
next
%>


The syntax error is on the 2nd execute stmt where I try to assign a date. Any ideas?

Also, any way to code multiple statements per line using VBScript & ASP?

Thanks.

i also tried using execute and got same error. It seems to me that's that invalid statement. Mr devid_levin you will get better performance using arrays then using variables that have the same use for them just a point. From my experience this can't be done as you try to do it.

I think I narrowed it down. I shouldn't use cstr() in the code I posted.

That last error I need to get around has to do with the response.write statement I posted. I need it to put out the value for the variable. In your code, you hard-coded the variable. Is there a way to refer to the variable all on it's own?

Here's the statement that gets an error now:
response.write "PassExp"&x&"="&execute("PassExp"&x)&"<br>"

when executed in the loop produces the following error:
Microsoft VBScript runtime error '800a000d'

Type mismatch: 'PassExp1'

I guess it doesn't know what to do with just the expression PassExp1.

Any ideas?

Ok, got ! :)

If I break out the response.write and make the variable piece, on it's own line as:

execute("Response.write PassExp"&x)

it works!

Ok, do you know if you can put multiple commands per line?

Respond and I'll give you the points.

Multiple commands per line???

Thanks mattyk! Exactly what I needed!!

The colon is the way to code multiple stmts per line. Thanks for that!

And thanks for the answer!

Comment accepted as answer

still i don't understand the use of this method.

Marine,

I'll use an array internally on the page, but if I want to for example, post a form with variables, I need to set/get them into an array.

Here's an example:

You can have up to 12 different values for something. I create 12 different form fields, each with a unique name like Exp1, Exp2, ... Exp12

Those values are posted from the form and I get read them using Request.Form("Exp1")

Well, like I mentioned in the original question, I can do something like:
Exp(1) = Request.Form("Exp1")
Exp(2) = Request.Form("Exp2") etc

Or now I can do the following in a loop instead of individually coding each:

Exp(x) = evaluate("Request.Form('Exp"&x&"')")

Make sense?

Marine, kinda slick... I had to look it up too;

The Execute method allows you to call another ASP page from inside an ASP page. When the called ASP page completes its tasks, you are then returned to the calling ASP page. The overall effect is very similar to a function or subroutine call. Any text or output from the called ASP page will be displayed on the calling ASP page. The Execute method is a more useful alternative to using server-side includes.

In contrast, the Transfer method allows you to transfer from one ASP page to another without returning to the calling ASP page.

There is one mandatory argument.

Path

The Path argument is a string specifying either the absolute or relative path of the ASP page being called. The file name must be included in the path. The entire Path must be enclosed inside a pair of quotes. The Path argument can also include a query string.

Code:
----------CallingAsp.asp----------
<HTML>
<BODY>

How now <%Server.Execute("CalledAsp.asp")%> cow?

</BODY>
</HTML>

----------CalledAsp.asp----------
<%
Response.Write "pink"
%>

Output:
How now pink cow?

So, we are all Experts here, so if someone still has questions, feel free to ask!

I converted the long ASP page to a much shorter page using the execute and eval functions.

David