请高手赐教！！！！！如果对了，马上给分！！！！！！！！

[yc820220]

dim goodsids
goodsids = request.form("goodsid")
session("goodsids")=goodsids

connstr="driver={SQL Server};server=127.0.0.1;uid=sa;pwd=allow;database=goodmanage"
strsql2="SELECT * FROM goodsview WHERE goodsid like '"&trim(goodsids)&"%' "
Set rs = Server.CreateObject("ADODB.RECORDSET")
rs.CursorType = 3
rs.LockType = 3

rs.Open strsql2,connstr ',,,adCmdtext
IF rs.EOF THEN
rs.CLOSE
Response.Redirect "sorry.asp"
' Response.End
else
rs("returndate")=now()

rs.update
rs.close
end if

为什么rs.update 是错的

[snowcloud2002]

请换成这样
sql="update table set returndate="&now
set rs=conn.execute(sql)

[haper99]

Set conn = Server.CreateObject("ADODB.Connection")'缺
connstr="driver={SQL Server};server=127.0.0.1;uid=sa;pwd=allow;database=goodmanage"
conn.Open connstr'缺
strsql2="SELECT * FROM goodsview WHERE goodsid like '"&trim(goodsids)&"%' "
Set rs = Server.CreateObject("ADODB.RECORDSET")
rs.CursorType = 3
rs.LockType = 3

rs.Open strsql2,connstr ',,,adCmdtext

-----------------------------------------------------------------------
connstr="driver={SQL Server};server=127.0.0.1;uid=sa;pwd=allow;database=goodmanage"
strsql2="SELECT * FROM goodsview WHERE goodsid like '"&trim(goodsids)&"%' "
Set rs = Server.CreateObject("ADODB.RECORDSET")
rs.CursorType = 3
rs.LockType = 3

rs.Open strsql2,connstr ',,,adCmdtext

[haper99]

Set conn = Server.CreateObject("ADODB.Connection")'缺
connstr="driver={SQL Server};server=127.0.0.1;uid=sa;pwd=allow;database=goodmanage"
conn.Open connstr'缺
strsql2="SELECT * FROM goodsview WHERE goodsid like '"&trim(goodsids)&"%' "
Set rs = Server.CreateObject("ADODB.RECORDSET")
rs.CursorType = 3
rs.LockType = 3

rs.Open strsql2,connstr ',,,adCmdtext

-----------------------------------------------------------------------
connstr="driver={SQL Server};server=127.0.0.1;uid=sa;pwd=allow;database=goodmanage"
strsql2="SELECT * FROM goodsview WHERE goodsid like '"&trim(goodsids)&"%' "
Set rs = Server.CreateObject("ADODB.RECORDSET")
rs.Open strsql2,conn,3,3 ',,,adCmdtext

[haper99]

Set conn = Server.CreateObject("ADODB.Connection")'缺
connstr="driver={SQL Server};server=127.0.0.1;uid=sa;pwd=allow;database=goodmanage"
conn.Open connstr'缺
strsql2="SELECT * FROM goodsview WHERE goodsid like '"&trim(goodsids)&"%' "
Set rs = Server.CreateObject("ADODB.RECORDSET")
rs.Open strsql2,conn,3,3 '改
-----------------------------------------------------------------------
connstr="driver={SQL Server};server=127.0.0.1;uid=sa;pwd=allow;database=goodmanage"
strsql2="SELECT * FROM goodsview WHERE goodsid like '"&trim(goodsids)&"%' "
Set rs = Server.CreateObject("ADODB.RECORDSET")
rs.CursorType = 3
rs.LockType = 3

rs.Open strsql2,connstr ',,,adCmdtext

[yc820220]

不对

[prqin]

模式不对
rs.Open strsql2,connstr,3,3

[haper99]

SqlServer将now()改成getdate()