mycom.commandtext="update col set col=col-cast(myint as int)"
mycom.commandtext="update col set col=col-"+cint(myint);
myint=request.form("myint") mycom.commandtext="update col set col=col-cint(myint)"cint是vbscript的数据类型转换的写法,既然你用sql语法就应该用sql的写法,如下:myint=request.form("myint") mycom.commandtext="update col set col=col-convert(int,myint)"
myint是变量,不应该放在双引号内
同意楼上的,应该改为:mycom.commandtext="update col set col=col-"+cint(myint)
mycom.commandtext="update col set col=col-cint(myint)"cint是vbscript的数据类型转换的写法,既然你用sql语法就应该用sql的写法,如下:myint=request.form("myint")
mycom.commandtext="update col set col=col-convert(int,myint)"