Assign vars from a for loop

[Dave Karmens]

for each inputField in Request.Form
for each inputValue in Request.Form(inputField)
response.write inputField & " = " & inputValue & "<br>"
next
next

Let's say this returns:

fld = fish
fld = dog
fld = cat
fld = bird
fld = emu

How can I get those values into a variables that I can then put into a
SQL string?

insert into tbl_tmp
(critter1, critter2, critter3, critter4, critter5)
values
(?????)

 

[Bob Barrows [MVP]]

for each inputField in Request.Form
for each inputValue in Request.Form(inputField)
response.write inputField & " = " & inputValue & "<br>"
next
next

Let's say this returns:

fld = fish
fld = dog
fld = cat
fld = bird
fld = emu

How can I get those values into a variables that I can then put into a
SQL string?

insert into tbl_tmp
(critter1, critter2, critter3, critter4, critter5)
values
(?????)

I think you can simply do this:

Response.Write Request.form("fld")

 

[Dave Karmens]

For each of the values? Won't that just return the same thing each time?

 

[Dave Karmens]

Basically, I want to get all the flds into:

values( )

 

[Bob Barrows [MVP]]

For each of the values? Won't that just return the same thing each
time?

Try it!! It would have taken you 10 seconds to try my suggestion. Instead,
you posted two replies and wasted several minutes of your time ...

The variable will return a comma-delimited list of the values.

Bob Barrows

 

[Ray at]

See your other post on this topic.

Ray at work

For each of the values? Won't that just return the same thing each time?

 

[Dave Karmens]

Thanks Bob, that worked.

Try it!! It would have taken you 10 seconds to try my suggestion. Instead,
you posted two replies and wasted several minutes of your time ...

The variable will return a comma-delimited list of the values.

Bob Barrows