[thelist] ASP Loop Question

[Salvatore Palmisano]

You're defiing the variable as 'variable_x' and then asking the sql to
insert that into the table.

Replace
 variable = "variable_" & x
With
 variable = "string" & x

.Salvatore

-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Feingold Josh S
Sent: Wednesday, March 20, 2002 10:31 AM
To: 'thelist at lists.evolt.org'
Subject: [thelist] ASP Loop Question

I want to insert the variable data into a database as a separate row.  I
would also like to automate this process.

I tried:

for x = 1 to 10
    variable = "variable_" & x
    rs.Open "INSERT INTO database (column) VALUES (' " & variable & " ')"
next

Does anyone know what I am doing wrong?

Thanks,
Josh