UC知道insert into语句语法错误。请大家帮忙
来源：百度知道 编辑：UC知道 时间：2024/05/29 08:46:35
<!--#include file=conn.asp-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>新增结果</title>
</head>
<body>
<%
response.Write ("您的姓名")&request.Form("t1")&("<br>")
response.Write ("您的学号")&request.Form("t2")&("<br>")
response.Write ("您的床号")&request.Form("t3")&("<br>")
response.Write ("您的专业")&request.Form("t4&qu
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>新增结果</title>
</head>
<body>
<%
response.Write ("您的姓名")&request.Form("t1")&("<br>")
response.Write ("您的学号")&request.Form("t2")&("<br>")
response.Write ("您的床号")&request.Form("t3")&("<br>")
response.Write ("您的专业")&request.Form("t4&qu
建议不要写得那么复杂...
很可能是你传入的参数里有"'"符号~`造成程序无法执行~`
你可以这样写
Set Rs = Server.CreateObject("ADODB.RecordSet")
SQL = "Select * From [2x307] Where ID is NULL"
Rs.Open SQL,Conn,1,3
Rs.AddNew
Rs("name") = Request.Form("t1")
Rs("Number") = Request.Form("t2")
......
Rs.Update
Response.Write "成功!"
补充:
1.确认你前面是否有连接数据库的代码
2.ID为你数据库的主键字段~`是自动编号的~`确认是否添加~`如果没有的话就把 Where ID is NULL 去掉就可以了
mycommand.commandtext= "insert into 2x307 ( name, number, bed, major, zubie, home ) values('"&request.Form('t1')&"','"&request.Form('t2')&"','"&request.Form('t3')&"','"&request.Form('t4')&"','"&request.Form('t5')&"','"&request.Form('t6')&"')"
把Form里面的""改成''试试`