急“insert”问题

[dwxq]

请各位看看我的代码写的正确吗？谢谢
<%
set conn=server.createobject("adodb.connection")
conn.open "test","sa"
set rs=server.createobject("adodb.recordset")
strsql="insert into jibenbiao(xingming,xingbie,chushengnianyue,dengluriqi,minzu,hunyinzhuangkuang,zhengzhimianmao,shengao,tizhong,zhaopian,huji,juzhudi,xiangongzuodi,jiankangzhuangkuang,jishuzhiwu,zhiyezige) values('"&thename&"','"&thesex&"','"&thedate&"','"&thehidden&"','"&thenationality&"','"&themar&"','"&thefeatures&"','"&theheight&"','"&theweight&"','"&thesex&"','"&thenativation&"','"&theplace&"','"&theworkplace&"','"&thehealth&"','"&thepost&"','"&thetitle&"')"
conn.execute(strsql)
%>

[qiangtian]

把这个语句放到查询分析器里试试不就行了

[lanying]

Please output "strsql" with "Response.Write" first.

[dwxq]

放到查询分析器里试过了，语法正确，但执行就报错。

[flashasp]

set conn=server.createobject("adodb.connection")
conn.open "test","sa"

->

DbPath = SERVER.MapPath("xxx.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=xxx.mdb;" & _
"Uid=test;" & _
"Pwd=sa"

[dnyz]

可能是字符串过长了，你试试将整个sql语句分开作为几个字符串来连接到一个变量中，如：

strsql="......"
strsql=strsql & "............."