html - Coldfusion 9 HTML 表单 500 内部服务器错误-6ren

html - Coldfusion 9 HTML 表单 500 内部服务器错误

转载作者：太空狗更新时间：2023-10-29 14:11:20

我有一台安装了 Coldfusion 9 的 Windows 2008 服务器。我有一个提交表单的应用程序，提交后得到 500 Internal Server Error 页面。我检查了日志，那里没有任何记录。我听说过提交超过 100 个表单字段的问题，但我的表单最多提交 64 个。我已选中启用稳健异常信息，并添加了我的 IP 地址，未选中 HTTP 状态代码。我可以看到所有页面上的所有调试信息，直到错误页面。我已将页面放入表单字段的所有信息输出到一个文件，并创建了一个仅包含那些表单字段和那些值的页面，并且提交正常。我已经坚持了一个星期了。我不知道还有什么可以尝试的。有什么建议么？？？请!!!!

<!---  #Include Header Page Here --->
<cfset session.headertitle = "Budget Revision to Sponsored Project-Calculation">
<!--- <cfinclude template="grantsys_header_nogif.cfm"> --->
<cfinclude template="../ps_common_scripts/header.cfm">
<CFINCLUDE template="grants_logincheck.cfm"> 
<cfset tfile=''>

<!--- Get Page Inputs --->
<CFIF IsDefined ("Form.Setid") AND IsDefined("Form.SpeedType") AND IsDefined("Form.SpeedType_Sub")>
    <CFSET Setid = Trim(UCase(Form.Setid))>
    <CFSET SpeedType1 = Trim(UCase(Form.SpeedType))>
    <CFSET SpeedType2 = Trim(UCase(Form.SpeedType_Sub))>
    <CFLOCK SCOPE="SESSION" TYPE="EXCLUSIVE" TIMEOUT="2">
        <CFSET Session.SpeedType2 = Trim(UCase(Form.SpeedType_Sub))>
    </CFLOCK>
<CFELSEIF IsDefined("URL.SpeedType") AND IsDefined("URL.SpeedType_Sub")>
    <CFSET Setid = Trim(UCase(Form.Setid))>
    <CFSET SpeedType1 = Trim(UCase(URL.SpeedType))>
    <CFSET SpeedType2 = Trim(UCase(URL.SpeedType_Sub))>
    <CFSET Session.SpeedType2 = Trim(UCase(URL.SpeedType_Sub))>
<CFELSE>
    <P><B>Error:</B> Expected page inputs are missing.</P>
    <CFINCLUDE template="br_footer.cfm">
    <CFABORT>
</CFIF>

<!--- If a SubSpeedType is specified (not NEW or blank)... --->
<CFIF SpeedType2 NEQ "NEW" AND SpeedType2 NEQ "">
    <!---Get Subheader data--->
    <CFQUERY name="qHdr2" datasource="#Application.DSN#">
        SELECT /*+ FIRST_ROWS */ SP.DEPTID, SP.FUND_CODE, 
            PF.GT_FUND_TITLE, 
            PJ.GT_CONTR_NO, 
            PJ.GT_PROJ_STARTDT, 
            PJ.GT_PROJ_EXPDT, 
            PJ.GT_SPON_NAME, 
            PJ.GT_PROJ_TITLE,
            PD.GT_PROJ_DIR, 
            PT.DESCR,
            PE.NAME 
        FROM    SYSADM.PS_SPEEDTYP_TBL SP, 
                SYSADM.PS_GT_GM_PROJ PJ, 
                SYSADM.PS_GT_GM_PROJ_PDPI PD,   
                SYSADM.PS_DEPT_TBL PT, 
                SYSADM.PS_GT_GM_HR_DATA PE,
                SYSADM.PS_GT_GM_FUND PF 
        WHERE SP.SETID = '#Setid#' 
            AND SP.SPEEDTYPE_KEY = '#SpeedType2#'  
            AND SP.BUDGET_REF = (   SELECT MAX(BUDGET_REF) 
                                    FROM SYSADM.PS_SPEEDTYP_TBL 
                                    WHERE SETID = SP.SETID 
                                    AND SPEEDTYPE_KEY = SP.SPEEDTYPE_KEY 
                                    ) 
        AND PJ.SETID        =   SP.SETID 
        AND PJ.PROJECT_ID   =   SP.SPEEDTYPE_KEY 
        AND PJ.FUND_CODE(+) =   SP.FUND_CODE
        AND PJ.FUND_CODE BETWEEN 'A0000'  AND 'Z9999'
        AND PJ.EFF_STATUS   =   'A' 
        AND PJ.EFFDT = ( 
                        SELECT  MAX(PJ_ED.EFFDT) 
                        FROM    SYSADM.PS_GT_GM_PROJ  PJ_ED
                        WHERE   PJ_ED.SETID = PJ.SETID 
                        AND     PJ_ED.PROJECT_ID = PJ.PROJECT_ID 
                        AND     PJ_ED.EFFDT <= SYSDATE )
        AND PD.SETID(+)     = PJ.SETID 
        AND PD.PROJECT_ID(+) = PJ.PROJECT_ID
        AND PD.EFFDT(+)     = PJ.EFFDT  
        AND PT.SETID        =   SP.SETID
        AND PT.DEPTID       =   SP.DEPTID
        AND PT.EFF_STATUS   =   'A' 
        AND PT.EFFDT = ( 
                        SELECT  MAX(PT_ED.EFFDT)   
                        FROM    SYSADM.PS_DEPT_TBL PT_ED
                        WHERE   PT_ED.SETID = PT.SETID 
                        AND     PT_ED.DEPTID = PT.DEPTID
                        AND     PT_ED.EFFDT <= SYSDATE  )   
        AND PE.EMPLID(+)    =   PD.GT_PROJ_DIR  
        AND PF.SETID        =   SP.SETID 
        AND PF.FUND_CODE    =   PJ.GT_GM_FUND 
        AND PF.EFF_STATUS   =   'A' 
        AND PF.EFFDT = ( 
                        SELECT  MAX(PF_ED.EFFDT) 
                        FROM    SYSADM.PS_GT_GM_FUND PF_ED
                        WHERE   PF_ED.SETID = PF.SETID 
                        AND     PF_ED.FUND_CODE = PF.FUND_CODE 
                        AND     PF_ED.EFFDT <= SYSDATE  )
        ORDER BY PD.GT_PRIME_PDPI DESC  
    </CFQUERY>
    <cfif "#qHdr2.RecordCount#" EQ 0>
        <P align="center"><B>Error:</B> Project ID# <cfoutput><strong>#SpeedType2#</strong></cfoutput> cannot be found. Please go back and enter a valid Project ID.</P>
        <CFINCLUDE template="br_footer.cfm">
        <CFABORT>
    </cfif>
</CFIF>

<!--- Display Data --->
<CFFORM action="br_submit_test.cfm?tfile" method="post" name="frmCalc" id="frmCalc">
    <TABLE align="center" border="1" width="100%">
        <TR bgcolor="Navy">
            <TD colspan="2" align="left">&nbsp;

            </TD>
            <TD colspan="3" align="center">
                <FONT size="+2" color="White">From</FONT>
            </TD>
            <TD colspan="3" align="center">
                <FONT size="+2" color="White">To</FONT>
            </TD>
        </TR>
        <CFOUTPUT>
            <TR> 
                <TD colspan="2" align="left">
                    Setid: <FONT><B>#Setid#</B></FONT>                  
                </TD>
                <TD colspan="3" align="center">
                    <B>#SpeedType1#</B>&nbsp;
                    <INPUT type="hidden" name="SpeedType1" value="#SpeedType1#">
                    <cfset tfile=#tfile#&"SpeedType1 #SpeedType1#"><br>
                </TD>
                <TD colspan="3" align="center">
                    <CFIF SpeedType2 NEQ "NEW" AND SpeedType2 NEQ "">

                        <B>#SpeedType2#</B>&nbsp;
                        <INPUT type="hidden" name="SpeedType2" value="#SpeedType2#">
                        <cfset tfile=#tfile#&"SpeedType2 #SpeedType2#"><br>
                    <CFELSEIF SpeedType2 EQ "NEW">
                        SpeedType: <input type="hidden" value="NEW" name="SpeedType2" size="10"> (NEW)
                        <cfset tfile=#tfile#&"SpeedType2 NEW #SpeedType2#"><br>
                    <CFELSE>
                        &nbsp;
                        <INPUT type="hidden" name="SpeedType2" value="">
                    </CFIF>
                </TD>
            </TR>
            <TR>
                <TD colspan="2">
                    School/Center/Lab:
                </TD>
                <TD colspan="3">
                     #qHdr1.DESCR# - #qHdr1.DEPTID#&nbsp;
                    <INPUT type="hidden" name="DEPTID1" value="#qHdr1.DEPTID# - #qHdr1.DESCR#&nbsp;">
                    <cfset tfile=#tfile#&"qHdr1.DEPTID - qHdr1.DESCR  #qHdr1.DEPTID# - #qHdr1.DESCR#"><br>
                </TD>
                <TD colspan="3">
                    <CFIF SpeedType2 NEQ "NEW" AND SpeedType2 NEQ "">
                        #qHdr2.DESCR# - #qHdr2.DEPTID#&nbsp;
                        <INPUT type="hidden" name="DEPTID2" value="#qHdr2.DEPTID#">
                        <cfset tfile=#tfile#&"qHdr2.DEPTID #qHdr2.DEPTID#"><br>
                    <CFELSEIF SpeedType2 EQ "NEW">
                        <CFQUERY name="querydeptid2" datasource="#Application.DSN#">
                            SELECT DISTINCT DEPTID, DESCR 
                            FROM SYSADM.PS_DEPT_TBL
                            ORDER BY DESCR
                        </CFQUERY>              
                        <SELECT size="1" name="DEPTID2">
                            <CFLOOP query="querydeptid2">
                                <CFIF Trim(DESCR) EQ "">
                                    <OPTION value="#DEPTID#">
                                        #DEPTID#
                                    </OPTION>
                                <CFELSE>
                                    <OPTION value="#DEPTID#">
                                        #Left(DESCR,30)# - #DEPTID#
                                    </OPTION>
                                </CFIF>
                            </CFLOOP>
                        </SELECT>
                    <CFELSE>
                        &nbsp;
                    </CFIF>
                </TD>
            </TR>
            <TR>
                <TD colspan="2">
                    Fund:
                </TD>
                <TD colspan="3">
                    #qHdr1.FUND_CODE# - #qHdr1.DESCR#&nbsp;
                    <INPUT TYPE="hidden" name="FUND_CODE1" value="#qHdr1.FUND_CODE# - #qHdr1.DESCR#">
                    <cfset tfile=#tfile#&"qHdr1.FUND_CODE - qHdr1.DESCR #qHdr1.FUND_CODE# - #qHdr1.DESCR#"><br>
                </TD>
                <TD colspan="3">
                <!--- CC8254 - Begin --->
                <CFIF SpeedType2 EQ "NEW">
                    #qHdr1.FUND_CODE# - #qHdr1.DESCR#&nbsp;
                <CFELSEIF SpeedType2 EQ "">
                      &nbsp;
                <CFELSE>
                    #qHdr2.FUND_CODE# - #qHdr2.DESCR#&nbsp;
                </CFIF>
                <!--- CC8254 - End --->
                </TD>
            </TR>
            <TR>
                <TD colspan="2">
                    Project Director:
                </TD>
                <TD colspan="3">
                    #qHdr1.GT_PROJ_DIR# - #qHdr1.NAME#&nbsp;
                    <INPUT TYPE="hidden" name="NAME1" value="#qHdr1.GT_PROJ_DIR# - #qHdr1.NAME#">
                    <cfset tfile=#tfile#&"qHdr1.GT_PROJ_DIR - qHdr1.NAME #qHdr1.GT_PROJ_DIR# - #qHdr1.NAME#"><br>
                </TD>
                <TD colspan="3">
                    <CFIF SpeedType2 NEQ "NEW" AND SpeedType2 NEQ "">
                        #qHdr2.GT_PROJ_DIR# - #qHdr2.NAME#&nbsp;
                        <INPUT TYPE="hidden" name="NAME2" value="#qHdr2.GT_PROJ_DIR# - #qHdr2.NAME#">
                        <cfset tfile=#tfile#&"qHdr2.GT_PROJ_DIR - qHdr2.NAME #qHdr2.GT_PROJ_DIR# - #qHdr2.NAME#"><br>
                        #qHdr2.DEPTID#
                    <CFELSEIF SpeedType2 EQ "NEW">
                        <CFQUERY name="queryprojdir2" datasource="#Application.DSN#">
                            SELECT  DISTINCT A.GT_PROJ_DIR EMPLID, B.NAME
                            FROM    SYSADM.PS_GT_GM_FUND_PDPI A,
                                    SYSADM.PS_GT_GM_HR_DATA B
                            WHERE A.GT_PROJ_DIR = B.EMPLID
                            UNION
                            SELECT  DISTINCT A.GT_PROJ_DIR EMPLID, B.NAME
                            FROM    SYSADM.PS_GT_GM_PROJ_PDPI A,
                                    SYSADM.PS_GT_GM_HR_DATA B
                            WHERE A.GT_PROJ_DIR = B.EMPLID
                            ORDER BY 2,1 
                        </CFQUERY>
                        <SELECT size="1" name="NAME2">
                            <CFLOOP query="queryprojdir2">  
                                    <OPTION value="#EMPLID#">
                                        #NAME# - #EMPLID#
                                    </OPTION>
                            </CFLOOP>
                        </SELECT>
                    <CFELSE>
                        &nbsp;
                    </CFIF>
                </TD>
            </TR>
            <TR>
                <TD colspan="2">
                    Award No.:
                </TD>
                <TD colspan="3">
                    #qHdr1.GT_CONTR_NO#&nbsp;
                    <INPUT TYPE="hidden" name="GT_CONTR_NO1" value="#qHdr1.GT_CONTR_NO#">
                    <cfset tfile=#tfile#&"qHdr1.GT_CONTR_NO #qHdr1.GT_CONTR_NO#"><br>
                </TD>
                <TD colspan="3">
                <!--- CC8254 - Begin--->
                <CFIF SpeedType2 NEQ "">                    
                    #qHdr1.GT_CONTR_NO#&nbsp;
                    <INPUT TYPE="hidden" name="GT_CONTR_NO2" value="#qHdr1.GT_CONTR_NO#">
                    <cfset tfile=#tfile#&"qHdr1.GT_CONTR_NO #qHdr1.GT_CONTR_NO#"><br>
                </CFIF>&nbsp; 
                <CFIF SpeedType2 EQ "NEW">
                    #qHdr1.GT_CONTR_NO#&nbsp;
                <CFELSEIF SpeedType2 EQ "">
                      &nbsp;
                <CFELSE>
                    #qHdr2.GT_CONTR_NO#&nbsp;
                </CFIF>
                <!--- CC8254 - End --->
                </TD>
            </TR>
            <TR>
                <TD colspan="2">
                    Submission Date:
                </TD>
                <TD colspan="3">
                    #DateFormat(Now(), "mm/dd/yyyy")#
                    <INPUT TYPE="hidden" name="DATE1" value="#DateFormat(Now(), "mm/dd/yyyy")#">
                    <cfset tfile=#tfile#&"Date 1 #DateFormat(Now(), "mm/dd/yyyy")#<br>">
                </TD>
                <TD colspan="3">
                    <CFIF SpeedType2 NEQ "">
                        #DateFormat(Now(), "mm/dd/yyyy")#
                        <INPUT TYPE="hidden" name="DATE2" value="#DateFormat(Now(), "mm/dd/yyyy")#">
                        <cfset tfile=#tfile#&"Date 2 #DateFormat(Now(), "mm/dd/yyyy")#<br>">
                    <CFELSE>
                        &nbsp;
                    </CFIF>
                </TD>
            </TR>
            <TR>
                <TD colspan="2">
                    Start Date: 
                </TD>
                <TD colspan="3">
                    #DateFormat(qHdr1.GT_PROJ_STARTDT, "mm/dd/yyyy")#&nbsp;
                    <INPUT TYPE="hidden" name="GT_PROJ_STARTDT1" value="#DateFormat(qHdr1.GT_PROJ_STARTDT, "mm/dd/yyyy")#">
                    <cfset tfile=#tfile#&"qHdr2.GT_PROJ_STARTDT1 #DateFormat(qHdr2.GT_PROJ_STARTDT, "mm/dd/yyyy")#<br>">
                </TD>
                <TD colspan="3">
                    <CFIF SpeedType2 NEQ "NEW" AND SpeedType2 NEQ "">
                        #DateFormat(qHdr2.GT_PROJ_STARTDT, "mm/dd/yyyy")#&nbsp;
                        <INPUT TYPE="hidden" name="GT_PROJ_STARTDT2" value="#DateFormat(qHdr2.GT_PROJ_STARTDT, "mm/dd/yyyy")#">
                        <cfset tfile=#tfile#&"qHdr2.GT_PROJ_STARTDT2 #DateFormat(qHdr2.GT_PROJ_STARTDT, "mm/dd/yyyy")#<br>">
                    <CFELSEIF SpeedType2 EQ "NEW">
                        <input type="text" name="GT_PROJ_STARTDT2" size="30" onChange = "return( isValidDate(this) && CheckDate(this) )">
                    <CFELSE>
                        &nbsp;
                    </CFIF>
                    <CFIF SpeedType2 EQ "new">(mm/dd/yyyy)</CFIF>
                </TD>
            </TR>
            <TR>
                <TD colspan="2">
                    End Date: 
                </TD>
                <TD colspan="3">
                    #DateFormat(qHdr1.GT_PROJ_EXPDT, "mm/dd/yyyy")#&nbsp;
                    <INPUT TYPE="hidden" name="GT_PROJ_EXPDT1" value="#DateFormat(qHdr1.GT_PROJ_EXPDT, "mm/dd/yyyy")#">
                    <cfset tfile=#tfile#&"qHdr2.GT_PROJ_EXPDT1 #DateFormat(qHdr2.GT_PROJ_EXPDT, "mm/dd/yyyy")#<br>">
                </TD>
                <TD colspan="3">                    
                    <CFIF SpeedType2 NEQ "NEW" AND SpeedType2 NEQ "">
                        #DateFormat(qHdr2.GT_PROJ_EXPDT, "mm/dd/yyyy")#&nbsp;
                        <INPUT TYPE="hidden" name="GT_PROJ_EXPDT2" value="#DateFormat(qHdr2.GT_PROJ_EXPDT, "mm/dd/yyyy")#">
                        <cfset tfile=#tfile#&"qHdr2.GT_PROJ_EXPDT2 #DateFormat(qHdr2.GT_PROJ_EXPDT, "mm/dd/yyyy")#<br>">
                    <CFELSEIF SpeedType2 EQ "NEW">                      
                        <input type="text" name="GT_PROJ_EXPDT2" size="30" onChange="return( isValidDate(this) && CheckDate(this) )">
                    <CFELSE>
                        &nbsp;
                    </CFIF>
                    <CFIF SpeedType2 EQ "new">(mm/dd/yyyy)</CFIF>
                        </TR>

                </TD>
            <TR>
                <TD colspan="2">
                    Sponsor:
                </TD>
                <TD colspan="3">
                    #qHdr1.GT_SPON_NAME#&nbsp;
                    <INPUT TYPE="hidden" name="GT_SPON_NAME1" value="#qHdr1.GT_SPON_NAME#">
                    <cfset tfile=#tfile#&"qHdr1.GT_SPON_NAME1 #qHdr1.GT_SPON_NAME#<br>">
                </TD>
                <TD colspan="3">
                <!--- CC8254 - Begin--->
                <CFIF SpeedType2 NEQ "">
                    #qHdr1.GT_SPON_NAME#&nbsp;
                    <INPUT TYPE="hidden" name="GT_SPON_NAME2" value="#qHdr1.GT_SPON_NAME#">
                    <cfset tfile=#tfile#&"qHdr1.GT_SPON_NAME2 #qHdr1.GT_SPON_NAME#<br>">
                </CFIF>&nbsp;
                <CFIF SpeedType2 EQ "NEW">
          #qHdr1.GT_SPON_NAME#&nbsp;
                <CFELSEIF SpeedType2 EQ "">
                      &nbsp;
                <CFELSE>
          #qHdr2.GT_SPON_NAME#&nbsp;
                </CFIF>
                <!--- CC8254 - End --->
                </TD>
            </TR>
            <TR>
                <TD colspan="2">
                    Name of Project:
                </TD>
                <TD colspan="3">
                    #qHdr1.GT_PROJ_TITLE#&nbsp;
                    <INPUT TYPE="hidden" name="GT_PROJ_TITLE1" value="#qHdr1.GT_PROJ_TITLE#">
                    <cfset tfile=#tfile#&"qHdr2.GT_PROJ_TITLE1 #qHdr2.GT_PROJ_TITLE#<br>">
                </TD>
                <TD colspan="3">
                    <CFIF SpeedType2 NEQ "NEW" AND SpeedType2 NEQ "">
                        #qHdr2.GT_PROJ_TITLE#&nbsp;
                        <INPUT TYPE="hidden" name="GT_PROJ_TITLE2" value="#qHdr2.GT_PROJ_TITLE#">
                        <cfset tfile=#tfile#&"qHdr2.GT_PROJ_TITLE2 #qHdr2.GT_PROJ_TITLE#<br>">
                    <CFELSEIF SpeedType2 EQ "NEW">
                        <input type="text" name="GT_PROJ_TITLE2" size="30">
                    <CFELSE>
                        &nbsp;
                    </CFIF>
                </TD>
            </TR>
        </CFOUTPUT>

        <!--- Display Budget Totals & Input Fields --->
        <TR bgcolor="Navy">
            <TD colspan="2">
                <FONT color="White"><B>BUDGET CATEGORY</B></FONT>
            </TD>
            <TD align="right">
                <FONT color="White"><B>CURRENT<BR>BUDGET</FONT>
            </TD>
            <TD align="right">
                <FONT color="White"><B>INCREASE+<BR>DECREASE-</FONT>
            </TD>
            <TD align="right">
                <FONT color="White"><B>REVISED<BR>BUDGET</FONT>
            </TD>
            <TD align="right">
                <FONT color="White"><B>CURRENT<BR>BUDGET</FONT>
            </TD>
            <TD align="right">
                <FONT color="White"><B>INCREASE+<BR>DECREASE-</FONT>
            </TD>
            <TD align="right">
                <FONT color="White"><B>REVISED<BR>BUDGET</FONT>
            </TD>
        </TR>       
        <CFQUERY name="qData" datasource="#Application.DSN#">
            SELECT  X.FIELDVALUE, X.XLATSHORTNAME, 
                    H.PROJECT_ID PID1, H.BUDG_LTD BUD1, H.FISCAL_YEAR FY1, 
                    H.ACCOUNTING_PERIOD P1, H2.PROJECT_ID PID2, 
                    H2.BUDG_LTD BUD2, H2.FISCAL_YEAR FY2, 
                    H2.ACCOUNTING_PERIOD P2 
<!---       FROM    SYSADM.XLATTABLE X, SYSADM.PS_GT_GS_AMTS_HDR H, SYSADM.PS_GT_GS_AMTS_HDR H2    --->
            FROM    SYSADM.XLATTABLE_VW X, SYSADM.PS_GT_GS_AMTS_HDR H, SYSADM.PS_GT_GS_AMTS_HDR H2 
            WHERE   X.FIELDNAME = 'GT_SPONSORED_CAT'
                AND X.FIELDVALUE NOT IN ('S89','SDT','SCH')
                AND X.FIELDVALUE LIKE 'S%'
<!---           AND X.LANGUAGE_CD = 'ENG'   --->
                AND X.EFF_STATUS = 'A'
                AND X.EFFDT = (
                 SELECT MAX(EFFDT)
<!---            FROM SYSADM.XLATTABLE   --->
                 FROM SYSADM.XLATTABLE_VW
                 WHERE FIELDNAME = 'GT_SPONSORED_CAT'
                 AND FIELDVALUE = X.FIELDVALUE
<!---                AND LANGUAGE_CD = X.LANGUAGE_CD   --->
                 AND EFF_STATUS = X.EFF_STATUS
                 )
                AND H.SETID (+) = '#Setid#' 
                AND H.PROJECT_ID (+) = '#SpeedType1#'
                AND H.GT_SPONSORED_CAT (+) = X.FIELDVALUE
                AND (H.FISCAL_YEAR = (
                    SELECT MAX(FISCAL_YEAR) 
                    FROM SYSADM.PS_GT_GS_AMTS_HDR 
                    WHERE SETID = H.SETID 
                    AND PROJECT_ID = H.PROJECT_ID
                    ) 
                    OR
                    H.FISCAL_YEAR IS NULL) 
                AND (H.ACCOUNTING_PERIOD = (
                    SELECT MAX(ACCOUNTING_PERIOD) 
                    FROM SYSADM.PS_GT_GS_AMTS_HDR 
                    WHERE SETID = H.SETID 
                    AND FISCAL_YEAR = H.FISCAL_YEAR 
                    AND PROJECT_ID = H.PROJECT_ID
                    ) 
                    OR 
                    H.ACCOUNTING_PERIOD IS NULL) 
                AND H2.SETID (+) = '#Setid#' 
                AND H2.PROJECT_ID (+) = '#SpeedType2#'
                AND H2.GT_SPONSORED_CAT (+) = X.FIELDVALUE
                AND (H2.FISCAL_YEAR = (
                    SELECT MAX(FISCAL_YEAR) 
                    FROM SYSADM.PS_GT_GS_AMTS_HDR 
                    WHERE SETID = H2.SETID 
                    AND PROJECT_ID = H2.PROJECT_ID
                    ) 
                    OR
                    H2.FISCAL_YEAR IS NULL) 
                AND (H2.ACCOUNTING_PERIOD = (
                    SELECT MAX(ACCOUNTING_PERIOD) 
                    FROM SYSADM.PS_GT_GS_AMTS_HDR 
                    WHERE SETID = H2.SETID 
                    AND FISCAL_YEAR = H2.FISCAL_YEAR 
                    AND PROJECT_ID = H2.PROJECT_ID
                    ) 
                    OR 
                    H2.ACCOUNTING_PERIOD IS NULL) 
            ORDER BY X.FIELDVALUE 
        </CFQUERY>
        <CFSET TCurrBud = 0>
        <CFSET TCurrBudSub = 0>
        <CFOUTPUT query="qData">
        <CFQUERY name="qCat" datasource="#Application.DSN#">
                SELECT CAT.GT_LBL_#qData.FIELDVALUE# LABEL, CAT.GT_CAT_#qData.FIELDVALUE# CATEGORY
                FROM SYSADM.PS_GT_GM_PROJ_CAT CAT
                WHERE CAT.SETID = '#Setid#'
                    AND CAT.PROJECT_ID = '#SpeedType1#'
                    AND CAT.GT_CAT_KEY = 'CAT'
                    AND CAT.EFFDT = (
                        SELECT MAX(EFFDT)
                        FROM SYSADM.PS_GT_GM_PROJ_CAT CAT_DT
                        WHERE CAT_DT.SETID = CAT.SETID
                            AND CAT_DT.PROJECT_ID = CAT.PROJECT_ID
                            AND CAT_DT.GT_CAT_KEY = CAT.GT_CAT_KEY
                            )
            </CFQUERY>
            <CFQUERY name="qCatSub" datasource="#Application.DSN#">
                SELECT CAT.GT_LBL_#qData.FIELDVALUE# LABEL, CAT.GT_CAT_#qData.FIELDVALUE# CATEGORY
                FROM SYSADM.PS_GT_GM_PROJ_CAT CAT
                WHERE CAT.SETID = '#Setid#'
                    AND CAT.PROJECT_ID = '#SpeedType2#'
                    AND CAT.GT_CAT_KEY = 'CAT'  
                    AND CAT.EFFDT = (
                        SELECT MAX(EFFDT)
                        FROM SYSADM.PS_GT_GM_PROJ_CAT CAT_DT
                        WHERE CAT_DT.SETID = CAT.SETID
                            AND CAT_DT.PROJECT_ID = CAT.PROJECT_ID
                            AND CAT_DT.GT_CAT_KEY = CAT.GT_CAT_KEY
                            )
            </CFQUERY>
            <TR>
                <TD>
                    #FIELDVALUE#
                    <INPUT type="hidden" name="Cat#FIELDVALUE#" value="#FIELDVALUE#">
                    <cfset tfile=#tfile#&"Cat#FIELDVALUE# #FIELDVALUE#<br>">
                </TD>
                <TD>
                    #XLATSHORTNAME#
                    <INPUT type="hidden" name="CatName#FIELDVALUE#" value="#XLATSHORTNAME#">
                    <cfset tfile=#tfile#&"CatName#FIELDVALUE# #XLATSHORTNAME#<br>">
                </TD>
                <TD align="right">
                    <INPUT type="text" name="#FIELDVALUE#CurrBud" value="#NumberFormat(IIF(BUD1 IS "", "0", "BUD1"), "L9999999999.00")#" size="10" readonly>
                    <cfset tfile=#tfile#&"#FIELDVALUE#CurrBud #NumberFormat(IIF(BUD1 IS "", "0", "BUD1"), "L9999999999.00")#<br>">
                    <CFIF Bud1 NEQ "">
                        <CFSET TCurrBud = TCurrBud + Bud1>
                    </CFIF>
                </TD>
                <TD align="right">
<!---                   <INPUT type="Text" name="#FIELDVALUE#AdjBud" maxlength="10" size="10" onChange="return Calc('#FIELDVALUE#',0)"> --->
                    <CFIF "#qCat.CATEGORY#" EQ 'Y'>
                        <INPUT type="Text" name="#FIELDVALUE#AdjBud" maxlength="10" size="10" onChange="return CheckCalc('#FIELDVALUE#',0)">
                    <CFELSE>
                        <input type="text" name="#FIELDVALUE#AdjBud" size="10" maxlength="10" readonly onChange="return CheckCalc('#FIELDVALUE#',0)">
                    </cfif>
                </TD>
                <TD align="right">
                    <INPUT type="text" name="#FIELDVALUE#RevBud" value="#NumberFormat(IIF(BUD1 IS "", "0", "BUD1"), "L9999999999.00")#" size="10" readonly>
                </TD>
                <TD align="right">
                    <CFIF SpeedType2 NEQ "">
                        <INPUT type="text" name="#FIELDVALUE#CurrBudSub" value="#NumberFormat(IIF(BUD2 IS "", "0", "BUD2"), "L9999999999.00")#" size="10" readonly>
                        <cfset tfile=#tfile#&"FIELDVALUECurrBudSub #FIELDVALUE#CurrBudSub #NumberFormat(IIF(BUD2 IS "", "0", "BUD2"), "L9999999999.00")#<br>">
                        <CFIF Bud2 NEQ "">
                            <CFSET TCurrBudSub = TCurrBudSub + Bud2>
                            <cfset tfile=#tfile#&"TCurrBudSub #TCurrBudSub#<br>">
                        </CFIF>
                    <CFELSE>
                        &nbsp;
                    </CFIF>
                </TD>
                <TD align="right">
                    <CFIF SpeedType2 NEQ "">
                        <CFIF "#qCatSub.CATEGORY#" EQ 'Y' OR "#FORM.SpeedType_Sub#" EQ 'NEW'>
                            <INPUT type="Text" name="#FIELDVALUE#AdjBudSub" maxlength="10" size="10" onChange="return CheckCalc('#FIELDVALUE#',1)">
                        <CFELSE>
                            <INPUT type="Text" name="#FIELDVALUE#AdjBudSub" maxlength="10" size="10" onChange="return CheckCalc('#FIELDVALUE#',1)" readonly>
                            <cfset tfile=#tfile#&"FIELDVALUEAdjBudSub #FIELDVALUE#AdjBudSub<br>">
                        </CFIF> 
                    <CFELSE>
                        &nbsp;
                    </CFIF>
                </TD>
                <TD align="right">
                    <CFIF SpeedType2 NEQ "">
                        <INPUT type="text" name="#FIELDVALUE#RevBudSub" value="#NumberFormat(IIF(BUD2 IS "", "0", "BUD2"), "L9999999999.00")#" size="10" readonly>
                        <cfset tfile=#tfile#&"NumberFormat(IIF(BUD2 IS , 0, BUD2), L9999999999.00) #NumberFormat(IIF(BUD2 IS "", "0", "BUD2"), "L9999999999.00")#<br>">
                    <CFELSE>
                        &nbsp;
                    </CFIF>
                </TD>
            </TR>
        </CFOUTPUT>

        <!--- Display Totals --->
        <CFOUTPUT>
            <TR bgcolor="Navy">
                <TD colspan="2" align="right">
                    <FONT color="White">TOTALS:</FONT>
                </TD>
                <TD align="right">
                    <INPUT type="text" name="CurrBudTotal" value="#NumberFormat(TCurrBud, "L9999999999.00")#" size="10" readonly>
                </TD>
                <TD align="right">
                    <INPUT type="text" name="AdjBudTotal" value="#NumberFormat(0, "L9999999999.00")#" size="10" readonly>
                </TD>
                <TD align="right">
                    <INPUT type="text" name="RevBudTotal" value="#NumberFormat(TCurrBud, "L9999999999.00")#" size="10" readonly>
                </TD>
                <CFIF SpeedType2 NEQ "">
                    <TD align="right">
                        <INPUT type="text" name="CurrBudSubTotal" value="#NumberFormat(TCurrBudSub, "L9999999999.00")#" size="10" readonly>
                    </TD>
                    <TD align="right">
                        <INPUT type="text" name="AdjBudSubTotal" value="#NumberFormat(0, "L9999999999.00")#" size="10" readonly>
                    </TD>
                    <TD align="right">
                        <INPUT type="text" name="RevBudSubTotal" value="#NumberFormat(TCurrBudSub, "L9999999999.00")#" size="10" readonly>
                    </TD>
                <CFELSE>
                    <TD align="right">
                        <INPUT type="hidden" name="CurrBudSubTotal" value="0" size="10" readonly>
                    </TD>
                    <TD align="right">
                        <INPUT type="hidden" name="AdjBudSubTotal" value="0" size="10" readonly>
                    </TD>
                    <TD align="right">
                        <INPUT type="hidden" name="RevBudSubTotal" value="0" size="10" readonly>
                    </TD>
                </CFIF>
            </TR>
        </CFOUTPUT>
    </TABLE>

    <BR>

    <H2>Department/Unit Approval:</H2>

    Approved by:
    <INPUT type="Text" name="Approvedby" size="20" maxlength="35">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    Title:
    <INPUT type="Text" name="Title" size="20" maxlength="35">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    Date:
    <cfinput type="Text" name="Date" required="No" size="20" maxlength="35" onChange="return (isValidDate(this))">
    <BR>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <FONT color="black">(Department Officer/Project Director)</FONT>
    <HR>
        <P>E-mail copy (or copies) of this request to the following e-mail address(es): 
            <input type="text" name="CC_To" size="70" maxlength="250">
    <BR>
    <BR>
    <HR>
<!---
        <B>NOTIFICATION TO BE SENT TO:</B>(Please enter name and fax number of individuals to receive copy of completed form)
    <HR>

    <TABLE>
        <TR>
            <TD>
                <B>Title</B>
            </TD>
            <TD>
                <B>Name</B>
            </TD>
            <TD>
                <B>Fax Number</B>
            </TD>
        </TR>
        <TR>
            <TD>
                School/Department Director:
            </TD>
            <TD>
                <INPUT type="Text" name="SDC" size="30" maxlength="35">
            </TD>
            <TD>
                <INPUT type="Text" name="FaxNumber1" size="10" maxlength="15">
            </TD>
        </TR>
        <TR>
            <TD>
                Project Director-Main Project:
            </TD>
            <TD>
                <INPUT type="Text" name="PDMP" size="30" maxlength="35">
            </TD>
            <TD>
                <INPUT type="Text" name="FaxNumber2" size="10" maxlength="15">
            </TD>
        </TR>
        <TR>
            <TD>
                Project Director-Sub Project:
            </TD>
            <TD>
                <INPUT type="Text" name="PDSP" size="30" maxlength="35">
            </TD>
            <TD>
                <INPUT type="Text" name="FaxNumber3" size="10" maxlength="15">
            </TD>
        </TR>
        <TR>
            <TD>
                School/Department Administrator:
            </TD>
            <TD>
                <INPUT type="Text" name="SDA" size="30" maxlength="35">
            </TD>
            <TD>
                <INPUT type="Text" name="FaxNumber4" size="10" maxlength="15">
            </TD>
        </TR>
        <TR>
            <TD>
                Other: <INPUT type="Text" name="othername" size="30" maxlength="15">
            </TD>
            <TD>
                <INPUT type="Text" name="other" size="30" maxlength="35">
            </TD>
            <TD>
                <INPUT type="Text" name="FaxNumber5" size="10" maxlength="15">
            </TD>
        </TR>
    </TABLE>
--->    
    Remarks (Maximum characters: 250):
    <br>
    <!--<textarea name="remarks" wrap="physical" cols="75" rows="3" maxlength="500">  CC8230 disabled mk5 -->
    <!--</textarea>                                                                   CC8230 disabled mk5 -->

  <!-- CC8230 mk5 - Begin -->
  <TEXTAREA name="remarks" cols="75" onKeyDown="limitText(remarks,countdown,250);" 
            onKeyUp="limitText(remarks,countdown,250);">
  </TEXTAREA>
  <BR>
  You have <INPUT readonly type="text" name="countdown" size="3" value="250"> characters left.</font>
  <!-- CC8230 mk5 - End -->

    <HR>
    <BR>

<!-------------------------------------------------------------------------------------------->
<!--- For testing                                                                          --->
<cffile action="write" file="location\tf99.txt" output=#tfile#>
<!-------------------------------------------------------------------------------------------->
    <TABLE WIDTH = "100%">
        <TR COLSPAN= "100%">
            <TD align="right" width="50%">
                <INPUT type="submit" name="SubmitForm" value="Submit" onClick="return (CheckIfEmailEntered() && CheckFundTotalConsistency())">
            </TD>
            <TD align="left" width="50%">
                <INPUT type="reset" name="ResetForm" value="Clear Form">
            </TD>
        </TR>
    </TABLE>
</CFFORM>


<CFINCLUDE template="br_footer.cfm">

</HTML>

这是它提交到的页面(非常简单的页面，只是为了编写文本文件，它没有这样做):

<!--- For testing--->
<cffile action="write" file="\\eisdevl.nas.gatech.edu\coldfusion\test\cfapps\cfeis\grantsys\testing\tf100.txt" output=#URL.tfile#>

在表单之前的页面上，还有一个只有2个输入框的表单。如果您在该页面的第一个框 (SpeedType1) 中输入任何内容，一切都会正常进行。但是，如果您在第一个框 (SpeedType1) 和第二个框 (SpeedType2) 中输入任何内容，我就会在提交上述表格后收到错误页面。我还检查了 application.cfm 文件中的 cfcatch 和 cferror 标记。

最佳答案

... The most recent hotfix [sic] for ColdFusion 9 can cause problems for people that have very large form submissions. The fix imposes a form field limit of 100 fields on submit. There is an override available for the default behavior, though ...

引用:Adobe ColdFusion 9 Hotfix APSB12-06 Causes Problems with Large Forms

简而言之，您可以通过更改 <var name='postParametersLimit'> 来覆盖限制在 neo-runtime.xml 中设置

关于html - Coldfusion 9 HTML 表单 500 内部服务器错误，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/15182567/

文章推荐： git - Jenkins :gitlabCommitStatus 不工作

文章推荐： git - 检查 git repo 中是否存在分支而不进行克隆

文章推荐： android - 我可以直接从 calllog.calls 提供商处获取照片吗

coldfusion - 有没有办法从 Coldfusion 内部访问有关 Coldfusion 服务器负载的信息？
我正在编写一个我想经常运行的计划任务。问题是，如果服务器遇到高流量负载，我不希望运行此任务。除了从 java 获取空闲/总/最大内存之外，还有什么方法可以尝试确定此任务是否应该继续？最佳答案 G
coldfusion - COLDFUSION BUILDER 是否支持 Coldfusion 8？
我知道 coldfusion builder 已发布用于开发 coldfusion 9 应用程序。现在我的问题是 coldfusion builder 是否支持 COLDFUSION 8 开发？非常感
coldfusion - Coldfusion 开发版和企业版有什么区别？
我正在尝试出于学习目的测试 Coldfusion，但我真的不知道非免费企业版添加到免费开发者版的附加功能是什么。谢谢! 最佳答案从法律上讲，Enterprise 是供公众消费的，而 Dev 不是。
coldfusion - 表情符号和 ColdFusion
我一直在玩这个问题一段时间了。我想要实现的是保存到MySQL数据库，然后输出到窗口，一般确认的表情符号如😀😁😂(是的，21世纪问题) 经过大量的修补和遵循本网站上的各种教程和答案之后，我设法实现
coldfusion - 转换数字格式(coldfusion)
嗨伙计!我有一个关于coldfusion用户的简单问题，有没有人知道如何将动态数字转换为小数，例如我有一个代码:#number#，它等于，例如 10 但我需要将它写为 0.10 我该怎么做做吗？试过
coldfusion - 调用名称中带有变量的变量-coldfusion？
尝试使用方括号表示法来引用动态变量。 (我正在遍历由查询创建的一组产品，为每个与其唯一 SKU 相关联的字段创建字段，如果您对应用程序感到疑惑) 我已将其缩小到这段代码，当我尝试运行它时会抛出“无效表
coldfusion - 开始使用 ColdFusion？
我刚刚下载了 ColdFusion Builder (CFB)，现在我正在尝试编写一个简单的“Hello World”应用程序。但我首先需要某种服务器，不是吗？现在我到底在这里寻找什么？ “ColdF
coldfusion - ColdFusion 中常用函数的存储位置
我们正在运行 ColdFusion MX7。我们遇到的一个问题是，我们在很多页面中都使用了很多功能。将它们放在“全局”ColdFusion 范围内会很好，而不是必须将它们包含在我们所有的页面中。有
coldfusion - 将第一个数据证书导入 ColdFusion
我已经尝试使用 key 工具将证书从 First Data 导入到我的 ColdFusion 9 设置中: keytool -importcert -keystore MYCF9Dir\runtime
coldfusion - Coldfusion 可以在函数参数中定义数组类型吗？
在 ColdFusion 组件中，我声明了一个这样的函数: string function render(required Array actions) output=false { //... }
coldfusion - ColdFusion 有哪些问题？
背景 : 我有一个处于设计阶段的新站点，正在考虑使用 ColdFusion。服务器目前正在使用 ColdFusion 和 Python 进行设置(为我完成)。使用什么是我的选择，ColdFusion
coldfusion - 从 ColdFusion 7 迁移到 ColdFusion 11
我计划在服务器上从 ColdFusion MX7(Server 2003)迁移到 ColdFusion 11(Server 2012)。有一个其他服务器，我需要从 ColdFusion 8(服务器 2
coldfusion - ColdFusion 用户定义函数名称的有效字符是什么？
一些背景知识:我正在从事一个将另一种脚本语言的网络应用程序转换为 ColdFusion 的项目。我遇到的一个问题是旧技术有一些函数名称与 CF 中的函数相同，但工作方式略有不同。不幸的是，在大多数情况
coldfusion - 以特定用户身份运行 ColdFusion
在 this page ，它谈到了 Windows NT、2000、XP 和 2003。幸运的是，我有一台 Windows 7 机器。第一行说: In User Manager for Domain
coldfusion - ColdFusion 中获取季度第一天和最后一天的最快方法是什么？
ColdFusion 中获取季度第一天和最后一天的最快方法是什么？似乎没有为此内置功能。最佳答案季度第一天: FirstDayOfQuarter = CreateDate(year, (quar
coldfusion - 执行锁定步骤后无法更新 ColdFusion
我正在尝试在新的 Windows 服务器 (Windows Server 2012 R2) 上安装 ColdFusion 11(标准版)。安装显然是成功的，但是当我进入管理员安装最新更新时，我不能。当
coldfusion - Coldfusion 有没有办法将所有错误发送到特定的电子邮件？
我有: 服务器详情服务器产品 ColdFusion 版本 9,0,1,274733 版本标准操作系统 Windows Server 2008 操作系统版本 6.0 Adobe 驱动程序版本 4.0
coldfusion - ColdFusion 在本地系统帐户下运行时可以访问网络驱动器吗？
我们有一组文件需要 ColdFusion 复制到网络共享。但是，我们无法更改运行 ColdFusion 服务的用户，这意味着 ColdFusion 没有足够的权限访问任何网络共享。我们确实有可以访问的
coldfusion - Coldfusion 连接字符串设置的位置
这对我来说是新的:我正在查看 ColdFusion 网站。问题是我什至找不到连接字符串。在一些 qryXXX.cfm 文件中，我发现但我就是找不到这个数据源的存储位置。最佳答案数据源在 Co
coldfusion - 空白空间/Coldfusion
停止ColdFusion输出的空白的正确方法是什么？我知道有cfcontent和cfsetting enableCFoutputOnly。正确的方法是什么？最佳答案除了，和是。您可以使用它删

太空狗

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

html - Coldfusion 9 HTML 表单 500 内部服务器错误