Updating A Column Based On A Form Value

[LongFeiFengWu]

Here's what I want to do:

<%

SQL = "SELECT * FROM SCORE WHERE SUPID='"& request.form("SUPID") & "' "
SQL = SQL & "AND YEAR1 = "& request.form("YEAR1") &" "

objrec.open SQL,objcon,3,3

objrec(request.form("COLNAME")) = request.form("ITEMVALUE")

objrec.update

%>

Is this something that can be done? Am I going about it the wrong way?

Any help is greatly appreciated as always.


&quot;If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo.&quot; ~ Bruce Lee

 

[LongFeiFengWu]

Nevermind, I fixed it. Yay Me!

&quot;If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo.&quot; ~ Bruce Lee