执行的是插入记录,到底哪里错了
这是出错提示:[/font][/size]
本页无法显示
试图访问的网页出现问题，无法显示。

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

请尝试以下方法：

单击 刷新按钮或者梢候再试。

打开 localhost 主页，然后查找与所需信息相关的链接。
HTTP 500.100 - 内部服务器错误 - ASP 错误
Internet 信息服务

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

技术信息（适用于支持人员）

错误类型：
Microsoft JET Database Engine (0x80040E14)
/TMPxea8pvns0.asp, 第 116 行


浏览器类型：
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)

页：
POST 173 bytes to /TMPxea8pvns0.asp

POST 数据:
u_name=432&u_title=321&u_oicq=321&u_mail=321&u_sex=321&u_face=312&u_beizu=312&u_contant=312&u_ip=127.0.0.1&u_time=2003-12-14+17%3A02%3A27&Submit=%CC%E1%BD%BB&MM_insert=form1

时间：
2003年12月14日, 17:02:34


详细信息：
Microsoft 支持

[size=6][font=黑体][font=楷体_GB2312]这是我做的程序的源代码[/font]
<%@LANGUAGE="VBSCRIPT"%>

<!--#include file="Connections/gbook.asp" -->
<%
' *** Edit Operations: declare variables

Dim MM_editAction
Dim MM_abortEdit
Dim MM_editQuery
Dim MM_editCmd

Dim MM_editConnection
Dim MM_editTable
Dim MM_editRedirectUrl
Dim MM_editColumn
Dim MM_recordId

Dim MM_fieldsStr
Dim MM_columnsStr
Dim MM_fields
Dim MM_columns
Dim MM_typeArray
Dim MM_formVal
Dim MM_delim
Dim MM_altVal
Dim MM_emptyVal
Dim MM_i

MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")
If (Request.QueryString <> "" Then
MM_editAction = MM_editAction & "?" & Request.QueryString
End If

' boolean to abort record edit
MM_abortEdit = false

' query string to execute
MM_editQuery = ""
%>
<%
' *** Insert Record: set variables

If (CStr(Request("MM_insert") = "form1" Then

MM_editConnection = MM_gbook_STRING
MM_editTable = "use"
MM_editRedirectUrl = "index.asp"
MM_fieldsStr = "u_name|value|u_title|value|u_oicq|value|u_mail|value|u_sex|value|u_face|value|u_beizu|value|u_contant|value|u_ip|value|u_time|value"
MM_columnsStr = "u-name|',none,''|u-title|',none,''|u-oicq|',none,''|u-email|',none,''|u-sex|',none,''|u-face|',none,''|u-beizu|',none,''|u-contant|',none,''|u-ip|',none,''|u-time|',none,NULL"

' create the MM_fields and MM_columns arrays
MM_fields = Split(MM_fieldsStr, "|"
MM_columns = Split(MM_columnsStr, "|"

' set the form values
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i)))
Next

' append the query string to the redirect URL
If (MM_editRedirectUrl <> "" And Request.QueryString <> "" Then
If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "" Then
MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString
Else
MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString
End If
End If

End If
%>
<%
' *** Insert Record: construct a sql insert statement and execute it

Dim MM_tablevalues
Dim MM_dbvalues

If (CStr(Request("MM_insert") <> "" Then

' create the sql insert statement
MM_tablevalues = ""
MM_dbvalues = ""
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
MM_formVal = MM_fields(MM_i+1)
MM_typeArray = Split(MM_columns(MM_i+1),","
MM_delim = MM_typeArray(0)
If (MM_delim = "none" Then MM_delim = ""
MM_altVal = MM_typeArray(1)
If (MM_altVal = "none" Then MM_altVal = ""
MM_emptyVal = MM_typeArray(2)
If (MM_emptyVal = "none" Then MM_emptyVal = ""
If (MM_formVal = "" Then
MM_formVal = MM_emptyVal
Else
If (MM_altVal <> "" Then
MM_formVal = MM_altVal
ElseIf (MM_delim = "'" Then ' escape quotes
MM_formVal = "'" & Replace(MM_formVal,"'","''" & "'"
Else
MM_formVal = MM_delim + MM_formVal + MM_delim
End If
End If
If (MM_i <> LBound(MM_fields)) Then
MM_tablevalues = MM_tablevalues & ","
MM_dbvalues = MM_dbvalues & ","
End If
MM_tablevalues = MM_tablevalues & MM_columns(MM_i)
MM_dbvalues = MM_dbvalues & MM_formVal
Next
MM_editQuery = "insert into " & MM_editTable & " (" & MM_tablevalues & " values (" & MM_dbvalues & ""

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command"
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

If (MM_editRedirectUrl <> "" Then
Response.Redirect(MM_editRedirectUrl)
End If
End If

End If
%>
<%
Dim rsu
Dim rsu_numRows

Set rsu = Server.CreateObject("ADODB.Recordset"
rsu.ActiveConnection = MM_gbook_STRING
rsu.Source = "SELECT * FROM use"
rsu.CursorType = 0
rsu.CursorLocation = 2
rsu.LockType = 1
rsu.Open()

rsu_numRows = 0
%>
<%
if Session("count" <> (Request.QueryString("u-ID") then
count=rsu("u-dangj"
count=count+1
rsu("u-dangj"=count
rsu.update
end if
Session("count" = Request.QueryString("u-ID"
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>留言</title>
</head>

<body>
<form name="form1" method="POST" action="<%=MM_editAction%>">

<table width="75%" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>
<td width="19%">姓名：</td>
<td width="81%"> <input name="u_name" type="text" id="u_name2"></td>
</tr>
<tr>
<td>标题：</td>
<td> <input name="u_title" type="text" id="u_title2"></td>
</tr>
<tr>
<td>OICQ:</td>
<td> <input name="u_oicq" type="text" id="u_oicq2"></td>
</tr>
<tr>
<td>E-mail:</td>
<td> <input name="u_mail" type="text" id="u_mail2"></td>
</tr>
<tr>
<td>性别：</td>
<td> <input name="u_sex" type="text" id="u_sex2"></td>
</tr>
<tr>
<td height="18">头像:</td>
<td> <input name="u_face" type="text" id="u_face2"></td>
</tr>
<tr>
<td>备注:</td>
<td> <input name="u_beizu" type="text" id="u_beizu2"></td>
</tr>
<tr>
<td>留言内容：</td>
<td> <input name="u_contant" type="text" id="u_contant2"></td>
</tr>
<tr>
<td>&nbsp;</td>
<td> <input name="u_ip" type="hidden" id="u_ip2" value="<%=request.servervariables("LOCAL_ADDR"%>">
<input name="u_time" type="hidden" id="u_time" value="<%=now()%>"> </td>
</tr>
<tr>
<td colspan="2"> <div align="center">
<input type="submit" name="Submit" value="提交">
</div></td>
</tr>
</table>

<input type="hidden" name="MM_insert" value="form1">
</form>
</body>
</html>
<%
rsu.Close()
Set rsu = Nothing
%>