UC知道ASP程序出了个错误，找人帮我看看
来源：百度知道 编辑：UC知道 时间：2024/06/12 02:45:48
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="Connections/StudentConn.asp" -->
<!--#include file="CheckLogin.asp"-->
<%
strSheetName = Request.QueryString("SheetName")
%>
<%
' *** Edit Operations: declare variables
MM_editAction = CStr(Request("URL"))
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 = ""
%>
<%
' *** Update Record: set variables
If (CStr(Request("MM_update")) <> "" And CStr(Request("MM_recordId")) <> "") Then
MM_editConnection = MM_StudentConn_STRING
MM_editTable = strSheetName
MM_editColumn = "
<!--#include file="Connections/StudentConn.asp" -->
<!--#include file="CheckLogin.asp"-->
<%
strSheetName = Request.QueryString("SheetName")
%>
<%
' *** Edit Operations: declare variables
MM_editAction = CStr(Request("URL"))
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 = ""
%>
<%
' *** Update Record: set variables
If (CStr(Request("MM_update")) <> "" And CStr(Request("MM_recordId")) <> "") Then
MM_editConnection = MM_StudentConn_STRING
MM_editTable = strSheetName
MM_editColumn = "
按照你的流程，当进行到这一行If (i <> LBound(MM_fields)) Then
的时候。
如果这个值是真的话，就进入了吧，进入的话UPDATE语句会是什么呢？
MM_editQuery = "update " & MM_editTable & " set "
MM_editQuery = MM_editQuery & ","
？？？？
是什么？ UPDATE MM_editTable SET ,? 这个逗号是啥？
如果你不能保证这个IF语句的发生，请把这条IF放到MM_editQuery = MM_editQuery & MM_columns(i) & " = " & FormVal 之后
UPDATE语法错误难道你就没想过为什么会错吗？？
上面我已经给出解答了，希望你自己好好找一下，不要老看着编译的时候给你的那行错误就看准了那一行