高铁二等座位是17排吗:紧急！关于SQL数据库的修改代码！请教高手！

同时更改几个字段的数据的代码格式：
dim strinsert
strinsert="update member set(datestar='"&strtime&"' and huiyuan='"&biaoshi&"' and dateover='"&strtimeover&"') where userid='"&session("name")&"'"
格式有错，运行不了。
请问哪里错了，快帮帮我！谢谢！
还是不行啊！！
格式有错： <%
dim strkanumber
dim strkapassword
dim biaoshi,strtime,strtimeover
dim rs,sql,aa,strInsert,strdelete,bb
strkanumber=request.form("number")
strkapassword=request.form("password")
biaoshi=1
strtime=date
strtimeover=dateadd("m",1,date)

strdelete="delete from kainfo where number='"&strkanumber&"'"
strinsert="update member set(datestar='"+strtime+"' and huiyuan='"+biaoshi+"' and dateover='"+strtimeover+"') where userid='"&session("name")&"'"
set rs=server.CreateObject("adodb.recordset")
sql="select number from KaInfo where number='"&strkanumber&"' and password='"&strkapassword&"'"
rs.open sql,conn,1,3

if not rs.eof then
set aa=server.CreateObject("adodb.recordset")
aa.open strdelete,conn,1,3
set aa=nothing

set bb=server.CreateObject("adodb.recordset")
bb.open strinsert,conn,1,3
set bb=nothing
用户名为英文。