asp与SQL的问题，等ing
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
源代码如下：出问题的语句有标记。如何解决，谢过先
<%@ Language = "VBScript" %>
<!-- #Include file="..\include\adovbs.inc" -->
<!-- #Include file="..\include\cod_ado.inc" -->
<%
strTitle = Request.Form("title")
strTitle = Trim(strTitle)
strTitle = replace(strTitle,"'","''")
strTitle = server.HTMLEncode(strTitle)
'strTitle = replace(strTitle,"<","<")
'strTitle = replace(strTitle,">",">")
strflag_attention = Request.Form("flag_attention")
if strflag_attention = "on" then
flag_attention = 1
else
flag_attention = 0
end if
strText = Request.Form("detail")
strText = replace(strText,"'","''")
'strText = server.HTMLEncode(strText)
'strText = replace(strText,chr(13)&chr(10),"<br/>")
'strText = replace(strText," "," ")
strText = replace(strText,"<","<")
strText = replace(strText,">",">")
dim objCnn,rs
strDSN = "dsn=newdata;uid=;pwd=;"
strSQL = "SELECT MAX(idnum) from board"
cod_AdoOpen objCnn,rs,strDSN,strSQL
if isnull(rs(0)) then
idnum=1
else
idnum=rs(0)+1
end if
rs.close
strSQL = "insert into board(IDNUM,title,flag_attention,detail) values (" &idnum &",'" &strTitle & "'," & flag_attention & ",'" & strText & "')"
'Response.Write strSql
objCnn.Execute(strSQL) 提示是这一句的问题！
objCnn.close
set objCnn = nothing
response.redirect "bulletin.asp"
%>
问题点数：100、回复次数：7Top
1 楼youbest（冲天飞豹）回复于 2003-05-01 15:12:12 得分 0
strSQL = "insert into board(IDNUM,title,flag_attention,detail) values (" &idnum &",'" &strTitle & "'," & flag_attention & ",'" & strText & "')"
改成
strSQL = "insert into board (IDNUM,title,flag_attention,detail) values ('" &idnum &"','" &strTitle & "','" & flag_attention & "','" & strText & "')"Top
2 楼fason（咖啡人生）回复于 2003-05-01 15:16:39 得分 0
flay_attention的类型是什么?
楼上,数值不必加' 'Top
3 楼wlxz（网络学子）回复于 2003-05-01 15:16:48 得分 0
看看数据库中idnum是不是数字型
Top
4 楼jumpray（jumpray）回复于 2003-05-01 19:23:51 得分 0
flay_attention 的类型是 bit 型Top
5 楼jumpray（jumpray）回复于 2003-05-01 19:24:27 得分 0
idnum 是 int 型
Top
6 楼cmsoft（韦小宝是我的老乡)(草根在路上）回复于 2003-05-01 19:32:03 得分 0
response.write sql到查询分析器里看看Top
7 楼eoco（vovo）回复于 2003-05-03 22:28:53 得分 100
idnum是自动编号要标记Top
