新手小改,请帮忙!
<%
wtfb_id=trim(request("wtfb_id"))
hfwt_rq=trim(request("hfwt_rq"))
call connopen()
set rs=server.createobject("adodb.recordset")
rs.open "Select * from wentifabu where wtfb_id ="&wtfb_id,conn,3,3
rs("hfwt_rq")=hfwt_rq
rs.update
%>
想要修改表wentifabu中指定ID(wtfb_id)的hfwt_rq 字段,修改成现在的日期和时间,试了好多遍,请高手帮忙了!
[解决办法]
或者
SQL数据库
sql = "update wentifabu set wtfb_id = getdate() where wtfb_id="&wtfb_id
conn.execute(sql)
ACCESS数据库
sql = "update wentifabu set wtfb_id = now() where wtfb_id="&wtfb_id
conn.execute(sql)
[解决办法]
<%
wtfb_id=trim(request("wtfb_id"))
call connopen()
sql = "update wentifabu set hfwt_rq=now() where wtfb_id=" & wtfb_id
conn.execute(sql)
%>