sql = "update eip_faq set fanswer='"&request("fanswer")&"',fanswerpeople='"&session("uname")&"',fanswertime='"&now()&"',fattachfilename='"&request("beforeupfilename")&"',fattachfileaddress='"&request("filepath")&"' where fid='"&request("fid")&"'"我的fanswertime是datetime類型 可是我在執行的時候就出錯
update eip_faq set fanswer='fdddff',fanswerpeople='admin',fanswertime='2006/12/8 下午 03:10:22',fattachfilename='Sams.Ajax.for.Web.Application.Developers.Oct.2006',fattachfileaddress='attachments/month_0612/t2006128144032.chm' where fid='29'出現錯誤如下
從字元 (char) 字串轉換到 datetime 的語法錯誤
請教該怎嚜寫
update eip_faq set fanswer='fdddff',fanswerpeople='admin',fanswertime='2006/12/8 下午 03:10:22',fattachfilename='Sams.Ajax.for.Web.Application.Developers.Oct.2006',fattachfileaddress='attachments/month_0612/t2006128144032.chm' where fid='29'出現錯誤如下
從字元 (char) 字串轉換到 datetime 的語法錯誤
請教該怎嚜寫
是的但是我在別的地方用rs.addnew的時候
rs("fquestiontime")=now()就可以,
所以我覺得很奇怪
cast(left(now(),10)as datetime) 但是這樣寫在sql會錯
sql = "update eip_faq set fanswer='"&request("fanswer")&"',fanswerpeople='"&session("uname")&"',fanswertime=getdate(),fattachfilename='"&request("beforeupfilename")&"',fattachfileaddress='"&request("filepath")&"' where fid='"&request("fid")&"'"
會不支持getdate()的.