首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > ASP >

不知道哪出有关问题了,帮帮忙,解决一下,多谢!

2012-02-12 
不知道哪出问题了,帮帮忙,解决一下,谢谢!!!%@LANGUAGE VBSCRIPT CODEPAGE 936 %!--#includefile

不知道哪出问题了,帮帮忙,解决一下,谢谢!!!
<%@LANGUAGE= "VBSCRIPT "   CODEPAGE= "936 "%>
<!--#include   file= "../Connections/conn.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   &   "? "   &   Server.HTMLEncode(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_conn_STRING
    MM_editTable   =   "admin_gsjj "
    MM_editRedirectUrl   =   "../Company.asp "
    MM_fieldsStr     =   "textarea|value "
    MM_columnsStr   =   "user_gsjj| ',none, ' ' "

    '   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   reset
Dim   reset_numRows

Set   reset   =   Server.CreateObject( "ADODB.Recordset ")
reset.ActiveConnection   =   MM_conn_STRING
reset.Source   =   "SELECT   *   FROM   admin_gsjj "
reset.CursorType   =   0
reset.CursorLocation   =   2
reset.LockType   =   1
reset.Open()

reset_numRows   =   0
%>
<!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> 后台控制1 </title>
<style   type= "text/css ">
<!--
#Layer1   {
position:absolute;
left:2px;
top:2px;
width:729px;
height:244px;
z-index:1;
}
.STYLE6   {
font-size:   14px;
font-weight:   bold;
}
#Layer2   {
position:absolute;
width:100%;
height:356px;
z-index:1;
}
.STYLE7   {font-size:   12px}
-->
</style>
</head>


[解决办法]
什么问题?给出那么长的代码,到底你要问的什么问题却没有说...
[解决办法]
DW生成的代码是恶心...

热点排行