3 Replies - 2899 Views - Last Post: 19 November 2012 - 06:15 AM Rate Topic: -----

#1 Pmister  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 16-October 12

probelm submitting page

Posted 16 October 2012 - 08:54 AM

My page allow user to add in expenditure for the current time period. It grabs the line items from a table, loops thru the dataset adding formatted input tag in to a cfform. When I press the submit button I get the 500 server if the number of rows are greater than 30. Each row has two input fields. So the total number of values is 60. It does not matter where I start and end in the loop (i.e. startrow = 40 endrow =70), as long as I stay under 30 it works anything over that it bombs out.
<CFLOOP query="getserviceinfo">
            <cfoutput>
              <tr align="center" valign="bottom" bgcolor="#iif(currentRow mod 2 is 0, DE('EBF5EF'), DE('FFFFFF'))#" class="body">
                <td align="center" nowrap><strong>#CurrentRow#</strong></td>
                <td nowrap>#cid#</td>
                <td colspan="2" align="left" nowrap>#service_typex#</td>
                <td width="85" align="center">#DateFormat(service_begin_date, 'mm/dd/yyyy')#</td>
                <td width="85" align="center">#DateFormat(service_end_date, 'mm/dd/yyyy')#&nbsp; </td>
                <td align="center">
                  <cfinput name="#sid#actual" type="text" value="#NumberFormat(expend_amount,"999999.99")#" size="11" maxlength="10" tabindex="1" required="no" style="text-align: right">
                  <input type="hidden" name="#sid#ssn" value="#ssn#">
                </td>
                <td align="center">
                  <cfinput name="#sid#projected" type="text" value="#NumberFormat(projected_expend_amount,"999999.99")#" size="11" maxlength="10" tabindex="1" required="no" style="text-align: right">
                </td>
                <CFSET total = (expend_amount + projected_expend_amount)>
                <td align="right"><span class="body">
                  <cfif total EQ 0>
                    <font color="red">
                    <cfelse>
                    <font color="black">
                  </cfif>
                  #NumberFormat(total,"999999.99")#</font></span><img src="../html/images/clear.gif" width="20" height="1" alt=""></td>
              </tr>
            </cfoutput>
          </CFLOOP>




Is This A Good Question/Topic? 0
  • +

Replies To: probelm submitting page

#2 Craig328  Icon User is offline

  • I make this look good
  • member icon

Reputation: 1947
  • View blog
  • Posts: 3,488
  • Joined: 13-January 08

Re: probelm submitting page

Posted 16 October 2012 - 02:33 PM

Pmister, welcome to D.I.C.

I've had a glance at your code and, unfortunately, as it is I can't really tell you what your problem is. You didn't include the remainder of the form but that's really more for my own curiosity's sake than it possibly being pertinent to your error.

The error you said you're receiving is a 500, internal server error. There's all kinds of things that might could be. If your form is of method="get" (rather than method="post") then the form variables, I believe, get converted to URL and it could be that the maximum URL value is being reached. That's just a WAG though.

If on the form receiving page, you put as your first line
<cfdump var="#form#"><cfdump var="#URL#"><cfabort>
, what do you see? Does it get that far? If not, try it with 30 rows and see what you see.

This post has been edited by Craig328: 16 October 2012 - 02:34 PM

Was This Post Helpful? 1
  • +
  • -

#3 Pmister  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 16-October 12

Re: probelm submitting page

Posted 16 October 2012 - 02:58 PM

hi Craig,
the method is "post" and ur right the i try the "get" method and it placed everything in the URL. where I quick reached the max size. when I place the dump in on the page I can see the values that are in the 30 row range. anything after that gave me the 500 sever error.
cfform action="submitreport.cfm?RequestTimeout=500" method="post" enablecab="yes" >
  <div align="center">
    <p><span class="body">Do not use commas or Dollar signs($). Amounts should be in 999999.99 format. Indicate negative numbers with a minus sign -500.00</span></p>
    <p>    
      </p>
  </div>
  <table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
    <cfoutput>
     
      <input type="hidden" name="date" value="#DateFormat(Now(), "MM/DD/YY")#">
      <input type="hidden" name="fy" value="2012">
      <input type="hidden" name="shortfy" value="12">
     </cfoutput>
    <tr>
      <td valign="top">
        <table width="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC" bordercolorlight="White">
           <tr align="center" bgcolor="#F5F5F5" class="body" >
            <td align="center" VALIGN="bottom"><font color="black">&nbsp;</font></td>
            <td colspan="2" align="left" VALIGN="bottom" bgcolor="#F5F5F5"><font color="black"><strong> Service Type </strong></font></td>
            <td width="85" VALIGN="bottom"><font color="black"><strong>Service<br>
              Beginning<br>
              Date</strong></font></td>
            <td width="85" VALIGN="bottom"><font color="black"><strong>Service <br>
              Actual<br>
              Ending Date</strong></font></td>
            <td VALIGN="bottom"><font color="black"><strong> Actual <br>
              FY12 YTD<br>
              Expenditures </strong></font></td>
            <td VALIGN="bottom"><font color="black"><strong>Projected<br>
              Additional FY12<br>
              Expenditures<br>
              </strong></font></td>
            <td VALIGN="bottom"><font color="black"><strong><font color="red">*</font>Total<br>
              Projected<br>
              FY12<br>
              Expenditures </strong></font></td>
          </tr>
          <CFLOOP query="getserviceinfo">
            <cfoutput>
              <tr align="center" valign="bottom" bgcolor="#iif(currentRow mod 2 is 0, DE('EBF5EF'), DE('FFFFFF'))#" class="body">
                <td align="center" nowrap><strong>#CurrentRow#</strong></td>
		<td nowrap>#cid#</td> 
                <td colspan="2" align="left" nowrap>#service_typex#</td>
                <td width="85" align="center">#DateFormat(service_begin_date, 'mm/dd/yyyy')#</td>
                <td width="85" align="center">#DateFormat(service_end_date, 'mm/dd/yyyy')#&nbsp; </td>
                <td align="center">
                  <cfinput name="#sid#actual" type="text" value="#NumberFormat(expend_amount,"999999.99")#" size="11" maxlength="10" tabindex="1" required="no" style="text-align: right">
                  <input type="hidden" name="#sid#ssn" value="#ssn#">
                </td>
                <td align="center">
                  <cfinput name="#sid#projected" type="text" value="#NumberFormat(projected_expend_amount,"999999.99")#" size="11" maxlength="10" tabindex="1" required="no" style="text-align: right">
                </td>
                <CFSET total = (expend_amount + projected_expend_amount)>
                <td align="right"><span class="body">
                  <cfif total EQ 0>
                    <font color="red">
                    <cfelse>
                    <font color="black">
                  </cfif>
                  #NumberFormat(total,"999999.99")#</font></span><img src="../html/images/clear.gif" width="20" height="1" alt=""></td>
              </tr>
            </cfoutput>
          </CFLOOP>
          <tr align="center" valign="bottom"  bgcolor="#F4F4F4" class="body">
            <td height="20" nowrap bgcolor="#F4F4F4">&nbsp;</td>
            <td height="20" nowrap>&nbsp;</td>
            <td height="20" align="left" nowrap><font color="black">&nbsp;<strong> <cfoutput>#getserviceinfo.recordcount#</cfoutput> Services Listed</strong></font></td>
            <td colspan="3" align="right" nowrap><strong><font color="black">Totals</font></strong></td>
            <cfoutput query="getserviceinfo2">
              <td height="20"><img src="../html/images/clear.gif" width="25" height="1" alt =""><strong><font color="black">#DecimalFormat(expendsum)#</font></strong></td>
              <td height="20"><img src="../html/images/clear.gif" width="25" height="1" alt =""><strong><font color="black">#DecimalFormat(projsum)#</font></strong></td>
              <CFSET totalallchild = (expendsum + projsum)>
              <td><img src="../html/images/clear.gif" width="5" height="1" alt =""><strong><font color="black">#DecimalFormat(totalallchild)#</font></strong></td>
            </cfoutput> </tr>
        </table>
      </td>
    </tr>
  </table>
  <br>
  
   <div align="center">
 <table width="97%" border="1" cellpadding="1" cellspacing="0" bordercolor="#CCCCCC" bordercolorlight="White">
    <tr align="left" background="images/ltgreen.gif">
      <td colspan="2" class="headerblack" background="images/ltgreen.gif"><span class="reportheader2"><font face="Arial, Helvetica, sans-serif">RECOVERIES </font></span> </td>
    </tr>
    <tr align="center">
      <td align="left" class="body">Recoveries <strong>Annual</strong>Projection</td>
      <td>
        <cfinput name="recoveries" type="text" value="#NumberFormat(recoveries,"999999.99")#" size="11" maxlength="10" tabindex="1" required="no" style="text-align: right">
      </td>
    </tr>
  </table>
  <br>
  <input type="submit" name="Submit" value="Calculate Report">
  &nbsp;
  <input type="submit" name="Submit" value="Pend Report">
  &nbsp;
  <input type="submit" name="Submit" value="Submit Report">
</cfform>



Was This Post Helpful? 0
  • +
  • -

#4 bethpaxtony  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 19-November 12

Re: probelm submitting page

Posted 19 November 2012 - 06:15 AM

That's just a WAG though.
Posted Image
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1