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]]

Dave Karmens wrote:

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")

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Dave Karmens]

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

Bob Barrows [MVP] wrote:

Dave Karmens wrote:

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]

Basically, I want to get all the flds into:

values( )

Bob Barrows [MVP] wrote:

Dave Karmens wrote:

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")

[Bob Barrows [MVP]]

Dave Karmens wrote:

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
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray at]

See your other post on this topic.

Ray at work

"Dave Karmens" <sp*************@yahoo.ca> wrote in message
news:uX*************@TK2MSFTNGP12.phx.gbl...

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

Bob Barrows [MVP] wrote:

Dave Karmens wrote:

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]

Thanks Bob, that worked.

Bob Barrows [MVP] wrote:

Dave Karmens wrote:

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