帮忙解决一个语法错误 (操作符丢失)的问题!
程序为: <!--#include file="conn.asp"--> <% post_time=date&"-"&time user_id=session("user_id") msg_title=request.form("msg_title") msg_content=request.form("msg_content") exec="insert into msg(user_id,post_time,msg_title,msg_content)values('"+user_id+"',"+post_time+",'"+msg_title+"','"+msg_content+"')" conn.execute exec conn.close set conn=nothing response.write "公告发布成功!" 错误为:
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 '2005-9-6-15:05:12' 中。
/msg_refer.asp,行8