using variable in script

[Jeff]

using access db and asp

i have a variable from a form
sRound = request.form("round") and for now let us say this value is 3

now i want to include that 3 in sql, but it is part of a field name which
is round3_report

cm.CommandText ="UPDATE rounds SET round" & sRound & "_report = '" & var5 &
"' WHERE Name ='" & sName & "' AND meeting = " & var4 & ""
cm.execute

this isn't working. i keep getting parameter error. i know there is a way to
join a word with a variable in order to make a field name in asp/sql, but I
don't remember how

can you help?
thanks

[Ray Costanzo [MVP]]

Response.Write out the SQL query to see what's being passed.

Ray at work

"Jeff" <gi*****@adelphia.net> wrote in message
news:vJ********************@adelphia.com...

using access db and asp

i have a variable from a form
sRound = request.form("round") and for now let us say this value is 3

now i want to include that 3 in sql, but it is part of a field name which
is round3_report

cm.CommandText ="UPDATE rounds SET round" & sRound & "_report = '" & var5
& "' WHERE Name ='" & sName & "' AND meeting = " & var4 & ""
cm.execute

this isn't working. i keep getting parameter error. i know there is a way
to join a word with a variable in order to make a field name in asp/sql,
but I don't remember how

can you help?
thanks

[Bob Barrows [MVP]]

Jeff wrote:

using access db and asp

i have a variable from a form
sRound = request.form("round") and for now let us say this value is 3

now i want to include that 3 in sql, but it is part of a field name
which is round3_report

cm.CommandText ="UPDATE rounds SET round" & sRound & "_report = '" &
var5 & "' WHERE Name ='" & sName & "' AND meeting = " & var4 & ""
cm.execute

this isn't working. i keep getting parameter error. i know there is a
way to join a word with a variable in order to make a field name in
asp/sql, but I don't remember how

can you help?
thanks

Instead of dynamic sql, use parameters:
http://groups-beta.google.com/group/...e36562fee7804e
Actually, I prefer using saved parameter queries:
http://groups.google.com/groups?hl=e...tngp13.phx.gbl

http://groups.google.com/groups?hl=e...TNGP11.phx.gbl

http://www.google.com/groups?selm=eE...&output=gplain

http://www.google.com/groups?hl=en&l...TNGP12.phx.gbl

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

[Jeff]

thanks to both of you. Especially for the links. both wwere a great help.
Bam
"Jeff" <gi*****@adelphia.net> wrote in message
news:vJ********************@adelphia.com...

using access db and asp

i have a variable from a form
sRound = request.form("round") and for now let us say this value is 3

now i want to include that 3 in sql, but it is part of a field name which
is round3_report

cm.CommandText ="UPDATE rounds SET round" & sRound & "_report = '" & var5
& "' WHERE Name ='" & sName & "' AND meeting = " & var4 & ""
cm.execute

this isn't working. i keep getting parameter error. i know there is a way
to join a word with a variable in order to make a field name in asp/sql,
but I don't remember how

can you help?
thanks