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

 

[Bob Barrows [MVP]]

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/microsoft.public.inetserver.asp.db/msg/72e36562fee7804e


Actually, I prefer using saved parameter queries:
http://groups.google.com/groups?hl=...=1&[email protected]

http://groups.google.com/groups?hl=...=1&[email protected]

http://www.google.com/[email protected]&oe=UTF-8&output=gplain

http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&[email protected]

 

[Jeff]

thanks to both of you. Especially for the links. both wwere a great help.
Bam