这个ASP问题到底应该如何解决
问了许多人,但答案还是不行,为何?我是在用台湾王国荣
的《ASP与数据库》中的例子“留言本”(附带光盘的例子,第10章的),但它老是说“查询值的数目与目标字段中的数目不同。 ”,
其中gform.asp如下:
<!--#include file="adovbs.inc" -->
<%
Function SqlStr( data )
SqlStr = "'" & Replace( data, "'", "''" ) & "'"
End Function
Name = Request("Name")
Email = Request("Email")
Subject = Request("Subject")
Memo = Request("Memo")
If Name = "" Or Email = "" Or Subject = "" Or Memo = "" Then
Response.Write "字段不能空白!"
Response.End
End If
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("gbook.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq= C:\MYASP\gbook.mdb"
sql = "Insert Into GuestBook (姓名,Email,主题,留言) Values( "
sql = sql & SqlStr(Name) & ", "
sql = sql & SqlStr(Email) & ", "
sql = sql & SqlStr(Subject) & ", "
sql = sql & SqlStr(Memo) & ")"
conn.Execute sql
Response.Redirect "gbook.asp"
%>