出错在哪里?求助!
hsyun 2010-12-27 02:13:49 saveTheme.asp文件内容如下
<%@ LANGUAGE="VBSCRIPT" %>
<%
Dim author,ip_addr,theme,pic_path,content
author=Trim(Request.Form("txtAuthor"))
ip_addr=Request.ServerVariables("REMOTE_ADDR")
theme=Trim(Request.Form("txtTheme"))
pic_path=Request.Form("optPic")
content=Trim(Request.Form("txtContent"))
%>
<html>
<head>
<base href="file:///C:/Inetpub/wwwroot/saveTheme.asp" fptype="TRUE">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>保存主题</title>
</head>
<body>
<%
Dim id,cnn,rst,ssql
Set cnn=Server.CreateObject("ADODB.Connection")
cnn.ConnectionString="DSN=mydsn;uid=sa;pwd=wwwfox"
cnn.Open
ssql="insert into articles(art_id,author,ip_addr,theme,pic_path,content,view_times,reply_times)"
ssql=ssql & "values (22,'" & author & "','" & ip_addr & "','"
ssql=ssql & theme & "','" & "images/" & pic_path & "','" & content & "',0,0)"
cnn.Execute ssql, ,adCmdText
%>
<p>主题保存成功!</p>
<p><a href="forum.asp">返回论坛首页</a></p>
</body>
</html>
错误信息:
ASP服务器发现运行时错误,以下是错误的详细描述:
Microsoft OLE DB Provider for ODBC Drivers
错 误 码:0x80040E14
错误代码:cnn.Execute ssql, ,adCmdText
错误描述:[Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: ',' 附近有语法错误。
文件名称:c:\inetpub\wwwroot\saveTheme.asp
所在行号:34
出错在哪里?求助