UC知道请大家帮忙看一下我的ASP怎么添加不起数据啊
来源：百度知道 编辑：UC知道 时间：2024/07/04 03:31:56
大家帮忙看一下吧是那个地方出错了啊
<%
mc=request.form("mc")
Set conn = Server.CreateObject("ADODB.Connection")
strcon="provider=microsoft.jet.oledb.4.0;data source="& _
server.mappath("6649.mdb")
conn.Open strcon%>
<%
mc=request.form("mc")
singer=request.form("singer")
url=request.form("url")
gs=request.form("gs")
time=request.form("time")
tyeid=request.form("tyeid")
set rs=Server.CreateObject("ADODB.Recordset")
sqlstr="insert to 6649 (mc,singer,url,gs,time,tyeid)values('"+mc'",'"+singer+'",'"+url+'",'"+gs+'","+time+",'"+tyeid+'")"
rs.open sqlstr,conn,3,3
%>
小弟谢谢大家了啊我的QQ305136058
我用了各位的设置还是不行啊..我是直接上传到网站上面的..没有通过本地设置IIS
<%
mc=request.form("mc")
Set conn = Server.CreateObject("ADODB.Connection")
strcon="provider=microsoft.jet.oledb.4.0;data source="& _
server.mappath("6649.mdb")
conn.Open strcon%>
<%
mc=request.form("mc")
singer=request.form("singer")
url=request.form("url")
gs=request.form("gs")
time=request.form("time")
tyeid=request.form("tyeid")
set rs=Server.CreateObject("ADODB.Recordset")
sqlstr="insert to 6649 (mc,singer,url,gs,time,tyeid)values('"+mc'",'"+singer+'",'"+url+'",'"+gs+'","+time+",'"+tyeid+'")"
rs.open sqlstr,conn,3,3
%>
小弟谢谢大家了啊我的QQ305136058
我用了各位的设置还是不行啊..我是直接上传到网站上面的..没有通过本地设置IIS
改了
----------------------------------------------------------
tyeid=request.form("tyeid")
改为
typeid=request.form("typeid")
sqlstr="insert to 6649 (mc,singer,url,gs,time,tyeid)values('"+mc'",'"+singer+'",'"+url+'",'"+gs+'","+time+",'"+tyeid+'")"
rs.open sqlstr,conn,3,3
改为
sqlstr="insert to [6649] (mc,singer,url,gs,time,typeid)values('"&mc&"','"&singer&"','"&url&"','"&gs&"',"&time&",'"&typeid&"')"
rs.open sqlstr,conn,1,3
是不是你的iis没有设好呀
sqlstr="insert into 6649 (mc,singer,url,gs,time,tyeid)values('"&mc&"','"&singer&'",'"&url&'",'"&gs&'","&time&",'"&tyeid&'")"
请问你那个数据库里面的表