100分求助一个发布信息的文本框插入图片的问题

[apassion1]

我做了一个浏览网页的用户发布信息的页面，所填的内容都插入数据库。现在我用了个编辑框。
插入代码如下
<%set com=server.createobject("adodb.connection")
com.open "DBQ="& Server.MapPath("databases/21asp.mdb") &";Driver={Microsoft Access Driver (*.mdb)};"

t1=replace(request("t1"),"<","〈")
t1=replace(t1,"'","''")
t2=replace(request("t2"),"<","〈")
t2=replace(t2,"'","‘’")
t4=replace(request("t4"),"<","〈")
t4=replace(t4,"'","‘’")
t5=replace(request("t5"),"<","〈")
t5=replace(t5,"'","‘’")
gq=replace(request("gq"),"<","〈")
gq=replace(gq,"'","‘’")
n=replace(request("n"),"<","〈")
n=replace(n,"'","‘’")
d1=replace(request("d1"),"<","〈")
d1=replace(d1,"'","''")
mContent=trim(Request.form("cnWords"))
mContent=Replace(mContent,"<script","<sscript")
mContent=Replace(mContent,"/script>","/scripts>")
mContent=Replace(mContent,"/script >","/scripts>")
mimageNum=Request.form("imageNum")
firstImageName=trim(Request.form("editFirstImageName"))
sz = "'" & t1 & "','" & t2 & "','" & t4 & "','" & t5 & "','" & gq & "','" & n &"','" & d1 &"','" & now & "','" & mContent & "','" & mimageNum & "','" & firstImageName & "',#" & dateadd("d",request("d2"),date) & "#"
'if session("ad")=0 then
com.Execute("INSERT INTO msg ( tit,mal,tel,lxr,gq,kin,whe,tim,msg,ImageNum,FirstImageName,edt ) VALUES(" & sz & ")")%>

这样写没有错。可是内容叉不进数据库。但是如果去掉'" & mContent & "','" & mimageNum & "','" & firstImageName & "'。这样就插的进

qq：99080047
有源码提供的可发到我邮箱：[e-mail]

[ahhisoft]

检查一下这几个字段的字段类型
另外测试一下在页面执行时这几个变量有没有被赋值。

[zhanghongwen]

写数据库罢了,一般把sql语句response.write出来,再看看参数什么的有没有传过来就能解决问题了

[flyingsnowy]

一步一步的response.write
response.end
接点分

[apassion1]

试一下

[cjl8882000]

检查字段类型 会不会有可能是数据太大导致
另外再把SQL打出来 直接到查询里 看能不能添加

[pcworld]

www.lincent-tech.com