上面的几条都能正常执行,可为什么
case else
sql = "update member set todate=DATEADD('y',"&adddates&",todate)"
这句执行不了呢?我把它改成
case “l”
sql = "update member set todate=DATEADD('y',"&adddates&",todate)"
也是一样的执行不了
那怎么我下面的代码有错啊:
adddates=cint(request("adddates"))+0
set rs=server.createobject("adodb.recordset")
select case request("seltype")
case "天"
sql = "update member set todate=DATEADD('d',"&adddates&",todate)"
case "月"
sql = "update member set todate=DATEADD('m',"&adddates&",todate)"
case "季"
sql = "update member set todate=DATEADD('m',"&adddates&",todate)"
case else
sql = "update member set todate=DATEADD('y',"&adddates&",todate)"
end select
conn.Execute(sql) '老是报这行有错,说是什么'无效字符'