循环插入数据库的问题!
我用循环让用户添各单选项即radio,然后提交到另一个asp文件,将这些选项结果存入数据库。我用了一个select语句,可是,每次提交后提示loop语句出错!
语句如下:
<%
do while not rs.EOF
names= rs("name") '数据库中的字段
'response.Write(rs("name")) 说明是select语句的错误!
select case "selected"&i
case "1" Set rs = conn.execute("update vote set selecta = selecta+1 WHERE name='"&names&"'")
case "2" Set rs = conn.execute("update vote set selectb = selectb+1 WHERE name='"&names&"'")
case "3" Set rs = conn.execute("update vote set selectc = selectc+1 WHERE name='"&names&"'")
case "4" Set rs = conn.execute("update vote set selectd = selectd+1 WHERE name='"&names&"'")
rs.MoveNext
i=i+1
Loop%>