asp 写入数据库的问题

[lihui451]

写进数字就没问题，写进字母或者汉字就有问题！

<div id="shenbao">

<form name="sb" method="post" action="shenbao_do.asp">
<div>
<dl><h1>课程申报表</h1>
<dd>姓　　名：<input type="text" name="tname" class="text"></dd>
<dd>课程名称：<input type="text" name="cname" class="text"></dd>
<dd>总学时数：<input type="text" name="xueshi" class="text"></dd>
<dd>课程学分：<input type="text" name="xuefen" class="text"></dd>
<dd>上课地点：<input type="text" name="didian" class="text"></dd>
<dd><input type="submit" name="tijiao" class="submit" value="提交"></dd>
</dl>
</div>




--------------------------------------------



<%
Response.Charset="GBK"
%>

<%
dim tname,cname,xueshi,xuefen,didian,sql,tijiao
tname = request.form("tname")
cname = request.form("cname")
xueshi = request.form("xueshi")
xuefen = request.form("xuefen")
didian =request.form("didian")

if tname= "" or len(tname) < 1 then
response.write "<script>alert('姓名不得为空或者少于一位');history.back();</script>"
response.end
end if

if cname= "" or len(cname) < 2 then
response.write "<script>alert('课程名称不得为空或者少于两位');history.back();</script>"
response.end
end if
%>
<!--#include file="conn.asp"-->
<%
sql ="insert into teacher (tname,cname,xueshi,xuefen,didian) values ("&tname&","&cname&","&xueshi&","&xuefen&","&didian&")"
set rs = server.createobject("adodb.recordset")
conn.execute(sql)
call close_conn
response.write "<script>alert('恭喜你，申报成功！');location.href='liebiao.asp'</script>"
%>









改成字母或汉字








数据库是ACCESS 2003

[lihui451]

http://wenwen.soso.com/z/q167701389.htm


防止图片被屏蔽。。。。问问上有

[Dogfish]

sql ="insert into teacher (tname,cname,xueshi,xuefen,didian) values ('" & tname & "','" & cname & "'," & xueshi & "," & xuefen & ","&didian&")" 

是字符类型的，要加上单引号。

[lihui451]

十分感谢 dogfish !

[he900401]

ding

[春天的气息]

是不是你的库数据类型定义的有问题呀？