Participant

Question

cfform submission in a tabbed layout

Forum|Forum|16 years ago
July 14, 2009
2 replies
2956 views

I have an application which allows users to submit a benefits form.

Tab 1 shows forms which the logged in user has already submitted.

Tab 2 ("Create new form") contains a blank form. The form is loaded from a separate file, which has the entire form

I'm using cfform, as several of the fields are required, and I want to take advantage of the mask option.

I'm using a couple of different onchange javascript functions on many of the fields; one invokes ColdFusion.Ajax.submitForm to call a CFC calculator function to provide a running total as the user enters numbers, the other looks up some meta information and populates hidden form fields appropriately. All of that is working great.

When the user actually submits the form, I want to reload the entire page, so that the newly submitted data shows up on the list of submitted forms. I'm using the ColdFusion.navigate function for this.

The problem I''m having is that the form will not submit properly unless I include an "onsubmit" function in the cform tag:

It doesn't actually use the function, in fact it throws a JS error:

Error: SubFrm is not defined
Source File: http://www.inside.dev.nsf.gov/CFIDE/scripts/ajax/package/cfajax.js

The function in question is in the parent page, along with all the other functions that are found.

HOWEVER, other than that thrown JS errror, the page works perfectly -- the data is submitted and the page redraws fine.

I have tried:

removing the onsubmit attribute from cfform

making the onsubmit call the same as the onclick in the submit button

removing everything except the id attibute from cfform

screaming

none of which worked, although the screaming made me feel a bit better.

There may be a sainthood involved for anyone who can help me with this.

This topic has been closed for replies.

Dileep_NR

Inspiring

Could u plz paste the entire code

trineharAuthor

Participant

Hi:

I've uploaded the files.

thanks

Theresa

trineharAuthor

Participant

Okay, no uploads.

index.cfm =======================================

<!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=iso-8859-1" />

<title>Inside NSF: NSF Application for Transit Benefits</title>

<cfparam name="mytab1" default="Yes">
<cfparam name="mytab2" default="No">
<cfparam name="mytab3" default="No">
<cfparam name="mytab4" default="No">
<cfparam name="admintab" default="Yes">

<cftransaction>
        <cfinsert datasource="transit" tablename="rqst" tableowner="transit" formfields="addr_city,addr_st,addr_zip_code,smrt_bnft_srl,mnth_vre_cst,mnth_marc_cst,mnth_mta_cst,mnth_van_cst,mnth_oth1_txt,mnth_oth1_cst,mnth_oth2_txt,mnth_oth2_cst,mtro_fare,mtro_stn,daly_mtro_rail_day,daly_mtro_bus_day,daly_mtro_bus_cst,daly_vre_day,daly_vre_cst,daly_marc_day,daly_marc_cst,daly_mta_day,daly_mta_cst,daly_oth1_txt,daly_oth1_day,daly_oth1_cst,daly_oth2_txt,daly_oth2_day,daly_oth2_cst,daly_oth3_txt,daly_oth3_day,daly_oth3_cst,daly_oth4_txt,daly_oth4_day,daly_oth4_cst,cert1,cert2,cert3,cert4,cert5,cert6,cert7,cert8,last_updt_user,lan_id,tot_mnth_cost,tot_dly_cost,rqst_tot,appl_stts,myaction,appl_subm_date">
        <cfquery name="getRID" datasource="transit" dbtype="Sybase">
            select max(rqst_id) as MID from transit.rqst
            where lan_id = '#session.lan_id#'
        </cfquery>
        <cfset RID = #getRID.MID#>
        </cftransaction>
        <cfinvoke component="transit" method="sendSubmit"
                    RID="#RID#" returnvariable="EmailStatus">
</cfif>

<cftransaction>
        <cfquery name="update_cancel" datasource="transit" dbtype="Sybase">
            update transit.rqst
            set appl_exp_date = getdate(),
            appl_stts = 'cancelled',
            last_updt_tmsp = getdate(),
            last_updt_user = '#session.lan_id#'
            where rqst_id = #RID#
        </cfquery>
        </cftransaction>
         <cfinvoke component="transit" method="sendCancel"
                    RID="#RID#" returnvariable="EmailStatus">

</cfif>

    monthDiv.innerHTML = fData.MONTHSUB;
    monthDiv2.innerHTML = fData.MONTHSUB;
    dailyDiv.innerHTML = fData.DAILYSUB;
    dailyDiv2.innerHTML = fData.DAILYSUB;
    combDiv.innerHTML = fData.COMBTOTAL;
    if ( fData.COMBTOTAL <= 230 ) {
        monthtot_cert.innerHTML = fData.COMBTOTAL;
        document.getElementById('warn').innerHTML = ""
     } else {
        monthtot_cert.innerHTML = 230;
        document.getElementById('warn').innerHTML = "<br />Your costs exceed the maximum allowable transit benefit of $230."
    }

    metroRT.innerHTML = fData.METRORT;
    metroWK.innerHTML = fData.METROWK;
    metroMN.innerHTML = fData.METROMN;
    busWK.innerHTML = fData.BUSWK;
    busMN.innerHTML = fData.BUSMN;
    vreWK.innerHTML = fData.VREWK;
    vreMN.innerHTML = fData.VREMN;
    marcWK.innerHTML = fData.MARCWK;
    marcMN.innerHTML = fData.MARCMN;
    mtaWK.innerHTML = fData.MTAWK;
    mtaMN.innerHTML = fData.MTAMN;
    oth1WK.innerHTML = fData.OTH1WK;
    oth1MN.innerHTML = fData.OTH1MN;
    oth2WK.innerHTML = fData.OTH2WK;
    oth2MN.innerHTML = fData.OTH2MN;
    oth3WK.innerHTML = fData.OTH3WK;
    oth3MN.innerHTML = fData.OTH3MN;
    oth4WK.innerHTML = fData.OTH4WK;
    oth4MN.innerHTML = fData.OTH4MN;
    if (document.tran_app != null) {
    document.tran_app.tot_mnth_cost.value = fData.MONTHSUB;
    document.tran_app.tot_dly_cost.value = fData.DAILYSUB;
    document.tran_app.rqst_tot.value = fData.COMBTOTAL;
    }
}

myError = function(sc,msg){
alert('Error!!! ' +sc +' '+msg);
}

submitFrm = function(){
ColdFusion.Ajax.submitForm('tran_app', 'transit.cfc?method=calculator', myCB, myError);
return true;
}

subFrm = function(){
//ColdFusion.Ajax.submitForm('tran_app', 'transit.cfc?method=calculator', myCB, myError);
return true;
}

setStation = function(stn){
    var stn_name = stn;
    document.tran_app.mtro_stn.value = stn_name;
    //alert(stn_name);
}

mycallBack = function(){

    }

ViewWindow = function(RID) {
        window.open("view.cfm?RID="+RID, "View", "resizable=1,height=500,width=600,status=1,scrollbars=1")
    }
</script>

</head>
<a name="top" id="top"></a>
<body class="mainbody" onload="MM_preloadImages('/images/nsf_on.gif','/images/org_on.gif','/images/intserv_on.gif','/images/worklife_on.gif','/images/resources_on.gif')">
<cfinclude template="/ssi/inside-header.htm">
<table align="center" border="0" cellpadding="0" cellspacing="0" width="100%">
<tbody>
<tr>
<td><table align="center" border="0" cellpadding="0" cellspacing="0" width="750">
    <tbody>
    <tr>
      <td valign="top" width="750">
        <table border="0" cellpadding="0" cellspacing="0" width="100%">
          <tbody>
            <tr>
              <td colspan="4"><img src="../../../../../../images/headers/oirm_header.gif" alt="Office of Information Resource Management" width="750" height="31" /></td>
            </tr>
            <tr>
              <td rowspan="6" align="left" bgcolor="#9ea4ab" width="1"><img src="/images/x.gif" height="1" width="1"/></td>
              <td bgcolor="#95b6ed" height="1" width="748"><img src="/images/x.gif" height="1" width="1"/></td>
              <td rowspan="6" align="right" bgcolor="#9ea4ab" width="1"><img src="/images/x.gif" height="1" width="1"/></td>
            </tr>
            <tr>
              <td align="left" bgcolor="#c6dafa" height="12" valign="top"><img src="/images/under_header.gif" align="top" height="12" width="748"/></td>
            </tr>
            <tr>
              <td bgcolor="#95b6ed" height="1"><img src="/images/x.gif" height="1" width="1"/></td>
            </tr>
            <tr>
              <td colspan="2" align="left" valign="middle"><table border="0" cellpadding="0" cellspacing="0" width="97%">
                  <tbody>
                    <tr>
                      <td height="10" valign="top"><img src="/images/x.gif" height="10" width="10"/></td>
                      <td class="text" height="10"> </td>
                    </tr>
                    <tr>
                      <td valign="top" width="3%"><img src="/images/x.gif" height="1" width="1"/></td>
                      <td class="text" width="97%" valign="top">
                      <a name="content" id="content"></a><span class="pageheadline">NSF Application for Transit Benefits </span>
                          
<p><a href="index.cfm?myaction=logout">Log Out</a></p>
    <cflayout type="tab" name="mainTab" style="width:840px">

    <cflayoutarea title="My Applications" name="tab1" selected="#mytab1#">
    <h2>My Applications</h2>
    <cfif (myaction eq "submit") or (myaction eq "cancel")>
               <cfinclude template="confirm.cfm">
    </cfif>
<cfdiv id="cbtext">

</cfdiv>
    <table width="100%" border="0" cellspacing="0" cellpadding="6">
<tr>
      <td valign="top" class="tablehead" id="first_column_description">Date Submitted</td>
      <td valign="top" class="tablehead" id="second_column_description">Amount Requested</td>
      <td valign="top" class="tablehead" id="third_column_description">Status</td>
      <td valign="top" class="tablehead" id="fourth_column_description">Approval Date</td>
      <td valign="top" class="tablehead" id="fifth_column_description">Last Updated By </td>
      <td valign="top" class="tablehead" id="sixth_column_description"></td>
        <td valign="top" class="tablehead" id="seventh_column_description"></td>
</tr>
   <cfoutput query="AppList">
<tr>
      <td valign="top" class="tabletext">#DateFormat(AppList.appl_subm_date, "mm/dd/yyyy")#</td>
      <td valign="top" class="tabletext">#NumberFormat(AppList.rqst_tot,'9999.99')#</td>
      <td valign="top" class="tabletext">#AppList.appl_stts#</td>
      <td valign="top" class="tabletext">#DateFormat(AppList.appl_aprv_date, "mm/dd/yyyy")#</td>
<td valign="top" class="tabletext">#AppList.last_updt_user#</td>
      <td valign="top" class="tabletext">
      <a href="javascript:ViewWindow('#AppList.rqst_id#')" >VIEW</a></td>
<td valign="top" class="tabletext"><cfif (#AppList.appl_stts# EQ "verified") OR (#AppList.appl_stts# EQ "Submitted")><form action="index.cfm" method="post" id="cancel_action" name="cancel_action"><input type="hidden" name="RID" value="#AppList.rqst_id#"><input type="hidden" name="myaction" value="cancel"><input type="submit" name="CancelRQ" id="CancelRQ" value="Cancel Request"></form></td>
</cfif>
</tr>
    </cfoutput>
    </table>

    </cflayoutarea>

<cflayoutarea title="Edit/Create New Application" name="tab2" selected="#mytab2#" source="appl_form.cfm" overflow="visible">
<p> </p>
    </cflayoutarea>

<cfif (session.myrole EQ "admin")>
     <cflayoutarea title="Applications Awaiting Review" name="tab3" selected="#mytab3#" initHide="#admintab#">

    <cfinvoke component="transit" method="getPendingApps" returnvariable="PendList">
    <table width="100%" border="0" cellspacing="0" cellpadding="6">
    <tr>
      <td valign="top" class="tablehead" id="first_column_descrip">Requestor</td>
      <td valign="top" class="tablehead" id="second_column_descrip">Date Submitted</td>
      <td valign="top" class="tablehead" id="third_column_descrip">Amount Requested</td>
      <td valign="top" class="tablehead" id="fourth_column_descrip">Status</td>
      <td valign="top" class="tablehead" id="fifth_column_desrip"></td>
    </tr>

   <cfoutput query="PendList">
    <tr>
      <td valign="top" class="tabletext">#lan_id#</td>
      <td valign="top" class="tabletext">#DateFormat(appl_subm_date, "mm/dd/yyyy")#</td>
      <td valign="top" class="tabletext">#NumberFormat(rqst_tot,'9999.99')#</td>
      <td valign="top" class="tabletext">#appl_stts#</td>
      <td valign="top" class="tabletext">
      <a href="javascript:ViewWindow('#rqst_id#')" >VIEW</a></td>
    </tr>
    </cfoutput>

    </table>
    </cflayoutarea>

    <cflayoutarea title="Verified Applications" name="tab4" selected="#mytab4#" initHide="#admintab#">
    <cfinvoke component="transit" method="getVerifiedApps" returnvariable="VerList">
    <table width="100%" border="0" cellspacing="0" cellpadding="6">
    <tr>
      <td valign="top" class="tablehead" id="first_column_desc">Requestor</td>
      <td valign="top" class="tablehead" id="second_column_desc">Date Submitted</td>
      <td valign="top" class="tablehead" id="third_column_desc">Amount Requested</td>
      <td valign="top" class="tablehead" id="fourth_column_desc">Status</td>
      <td valign="top" class="tablehead" id="fifth_column_desc">Approval Date</td>
      <td valign="top" class="tablehead" id="sixth_column_desc">Approved By</td>
      <td valign="top" class="tablehead" id="seventh_column_desc"></td>
    </tr>

<cfoutput query="VerList">
    <tr>
      <td valign="top" class="tabletext">#VerList.lan_id#</td>
      <td valign="top" class="tabletext">#DateFormat(VerList.appl_subm_date, "mm/dd/yyyy")#</td>
      <td valign="top" class="tabletext">#NumberFormat(VerList.rqst_tot,'9999.99')#</td>
      <td valign="top" class="tabletext">#VerList.appl_stts#</td>
      <td valign="top" class="tabletext">#DateFormat(appl_aprv_date, "mm/dd/yyyy")#</td>
      <td valign="top" class="tabletext">#aprv_lan_id#</td>
      <td valign="top" class="tabletext">
      <a href="javascript:ViewWindow('#rqst_id#')" >VIEW</a></td>
</tr>
    </cfoutput>

    </table>
    </cflayoutarea>

</cfif>


</cflayout>


                          </td>
                    </tr>
                    <tr>
                      <td> </td>
                      <td class="text" align="right" valign="top"><a href="#top"><img src="/images/top.gif" alt="Back to Top" width="41" height="25" border="0" /></a></td>
                    </tr>
                  </tbody>
              </table></td>
            </tr>
            <tr bgcolor="#9ea4ab">
              <td colspan="4" height="1"><img src="/images/x.gif" height="1" width="1"/></td>
            </tr>
          </tbody>
        </table></td>
    </tr>
    </tbody>
    </table><br/></td>
</tr>
</tbody>
</table>
<cfset showLastModified = "true">
<cfset webmasterOrg = "das">
<cfset contentOwner = "tmclendo">
<cfinclude template="/ssi/inside-footer.cfm">
</body>

</html>

====================================== index.cfm end

appl_form.cfm ===============================

<p><span class="subhead">Applicant Information</span><br />
<img src="/images/bluefade.jpg" width="457" height="1" vspace="5" /></p>

<table width="100%" border="0" cellspacing="0" cellpadding="6">
   <tr>
     <td>Name</td>
     <td><cfoutput>#session.frst_name# #session.mid_name# #session.last_name#</cfoutput></td>
   </tr>
   <!---     <span class="red">*</span> Number</td>
     <td><cfinput name="addr_strt_num" type="text" id="addr_strt_num" size="10" required="No" /></td>
   </tr>
   <tr>
     <td>    <span class="red">*</span> Street</td>
     <td><cfinput name="addr_strt_name" type="text" id="addr_strt_name" size="40" required="No"/></td>
   </tr>

   <tr>
     <td>    <span class="red"></span> Apartment</td>
     <td><cfinput name="addr_apt_num" type="text" id="addr_apt_num" size="40" required="No"/></td>
   </tr>

<tr>
     <td> --->
   <tr>
     <td>Home Address<br />
           <span class="red">*</span> City</td>
     <td><cfinput name="addr_city" type="text" id="addr_city" size="40" required="Yes" /></td>
   </tr>
   <tr>
     <td>    <span class="red">*</span> State</td>
     <td><cfselect name="addr_st" id="addr_st" required="Yes">
       <option selected="selected" value="">select state:</option>
       <option value="DC">DC</option>
       <option value="MD">MD</option>
       <option value="VA">VA</option>
       <option value="WV">WV</option>
     </cfselect>     </td>
   </tr>
   <tr>
     <td>    <span class="red">*</span> Zip+4 (<a href="http://zip4.usps.com/zip4/welcome.jsp" target="_blank">USPS Zip+4 Lookup</a>)</td>
     <td><cfinput name="addr_zip_code" type="text" id="addr_zip_code" size="10" required="Yes" validate="zipcode" mask="99999-9999" /></td>
   </tr>
   <tr>
     <td>Work Address</td>
     <td nowrap="nowrap">NSF Headquarters, Wilson Boulevard, Arlington, VA 22230</td>
   </tr>
   <tr>
     <td>If using SmartBenefits please provide the 9-digit serial number on the back of your SmarTrip card</td>
     <td><cfinput name="smrt_bnft_srl" type="text" id="smrt_bnft_srl" size="15" /></td>
   </tr>
</table>
        <p><span class="subhead">Commuting Costs</span><br />
   <img src="/images/bluefade.jpg" width="457" height="1" vspace="5" /><br />
Note: This program does not cover parking fees or the biking subsidy. Please do not include them when computing your expenses. </p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
   <tr>
    <td valign="top" colspan="6"><p><strong>Monthly Passes and Fees<br />
</strong>Enter information about any monthly passes you buy or monthly fees you pay below.<br />
              <br />
              </p></td>
        </tr>
   <tr>
     <td colspan="5" valign="top" class="tablehead" id="first_column_description" >Mode of Transportation </td>
     <td class="tablehead" id="third_column_description" valign="top">Cost Per Month </td>
   </tr>
   <tr>
     <td colspan="5" valign="top" class="tabletext">Virginia Railway Express (VRE) </td>
     <td valign="top" nowrap="nowrap" class="tabletext">$
       <cfinput name="mnth_vre_cst" type="text" id="mnth_vre_cst" size="10" onchange="javascript:submitFrm();" validate="float" value="0"/></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td colspan="5" valign="top" class="tabletext">Maryland Area Regional Commuter (MARC) Train </td>
     <td class="tabletext" valign="top">$
       <cfinput name="mnth_marc_cst" type="text" id="mnth_marc_cst" size="10" onchange="javascript:submitFrm();" validate="float" value="0" /></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td colspan="5" valign="top" class="tabletext">Maryland Transit Administration (MTA) Bus </td>
     <td class="tabletext" valign="top">$
       <cfinput name="mnth_mta_cst" type="text" id="mnth_mta_cst" size="10" onchange="javascript:submitFrm();" validate="float" value="0"/></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td colspan="5" valign="top" class="tabletext">Vanpool </td>
     <td class="tabletext" valign="top">$
       <cfinput name="mnth_van_cst" type="text" id="mnth_van_cst" size="10" onchange="javascript:submitFrm();" validate="float" value="0"/></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td colspan="5" valign="top" class="tabletext">Other (specify):
       <cfinput name="mnth_oth1_txt" type="text" id="mnth_oth1_txt" /></td>
     <td class="tabletext" valign="top">$
       <cfinput name="mnth_oth1_cst" type="text" id="mnth_oth1_cst" size="10" onchange="javascript:submitFrm();" validate="float" value="0"/></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td colspan="5" valign="top" class="tabletext">Other (specify):
       <cfinput name="mnth_oth2_txt" type="text" id="mnth_oth2_txt" /></td>
     <td class="tabletext" valign="top">$
       <cfinput name="mnth_oth2_cst" type="text" id="mnth_oth2_cst" size="10" onchange="javascript:submitFrm();" validate="float" value="0"/></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td colspan="5" valign="top" class="tabletext"><strong>Total Monthly Passes and Fees </strong></td>
     <td align="right" valign="top" class="tabletext"><strong>$<span id="monthtot"></span></strong></td>
   </tr>

   <tr>
     <td valign="top" colspan="6">
          <p> </p>
          <p><strong>Daily Fares</strong><br />
            Enter information about any daily fares you pay below.<br />
            <br />
          </p></td>
          </tr>
   <tr>
     <td class="tablehead" id="first_column_description" valign="top" >Mode of Transportation </td>
     <td class="tablehead" id="second_column_description" valign="top">Number of Days Per Week Mode of Transportation Is Used </td>
     <td class="tablehead" id="second_column_description" valign="top">Roundtrip Cost </td>
     <td class="tablehead" id="third_column_description" valign="top">Cost Per Week</td>
     <td class="tablehead" id="third_column_description" valign="top">Average Weeks Per Month </td>
     <td class="tablehead" id="third_column_description" valign="top">Cost Per Month </td>
   </tr>

     <td class="tabletext" valign="top">Metro Rail
       <cfselect name="mtro_fare" id="mtro_fare" onchange="javascript:submitFrm();">
         <option selected="selected" value="0">select station:</option>
          <cfinclude template="metro.cfm" />
       </cfselect>
    <cfinput name="mtro_stn" type="hidden" value="" />
           </td>
     <td class="tabletext" valign="bottom"><cfselect name="daly_mtro_rail_day" id="daly_mtro_rail_day" onchange="javascript:submitFrm();">
       <option selected="selected" value="0" >days per week:</option>
       <option value="1">1</option>
       <option value="2">2</option>
       <option value="3">3</option>
       <option value="4">4</option>
       <option value="5">5</option>
     </cfselect>     </td>
     <td align="right" valign="bottom" nowrap="nowrap" class="tabletext">$<span id="metroRT"></span></td>
     <td align="right" valign="bottom" nowrap="nowrap" class="tabletext">$<span id="metroWK"></span></td>
     <td align="center" valign="bottom" class="tabletext">4.2</td>
     <td align="right" valign="bottom" class="tabletext">$<span id="metroMN"></span></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>

   <tr>
     <td class="tabletext" valign="top">Metro Bus </td>
     <td class="tabletext" valign="top"><cfselect name="daly_mtro_bus_day" id="daly_mtro_bus_day" onchange="javascript:submitFrm();">
       <option selected="selected" value="0">select # of days:</option>
       <option value="1">1</option>
       <option value="2">2</option>
       <option value="3">3</option>
       <option value="4">4</option>
       <option value="5">5</option>
     </cfselect></td>
     <td valign="top" nowrap="nowrap" class="tabletext">$
       <cfinput name="daly_mtro_bus_cst" type="text" id="daly_mtro_bus_cst" size="10" onchange="javascript:submitFrm();" value="0"/></td>
     <td align="right" valign="top" nowrap="nowrap" class="tabletext">$<span id="busWK"></span></td>
     <td align="center" valign="top" class="tabletext">4.2</td>
     <td align="right" valign="top" class="tabletext" nowrap="nowrap">$<span id="busMN"></span></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td class="tabletext" valign="top">Virginia Railway Express (VRE)</td>
     <td class="tabletext" valign="top"><cfselect name="daly_vre_day" id="daly_vre_day" onchange="javascript:submitFrm();">
       <option selected="selected" value="0">select # of days:</option>
       <option value="1">1</option>
       <option value="2">2</option>
       <option value="3">3</option>
       <option value="4">4</option>
       <option value="5">5</option>
     </cfselect></td>
     <td class="tabletext" valign="top">$
       <cfinput name="daly_vre_cst" type="text" id="daly_vre_cst" size="10" onchange="javascript:submitFrm();" value="0"/></td>
     <td align="right" valign="top" class="tabletext" nowrap="nowrap">$<span id="vreWK"></span></td>
     <td align="center" valign="top" class="tabletext" nowrap="nowrap">4.2</td>
     <td align="right" valign="top" class="tabletext" nowrap="nowrap">$<span id="vreMN"></span></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td class="tabletext" valign="top">Maryland Area Regional Commuter (MARC) Train </td>
     <td class="tabletext" valign="top"><cfselect name="daly_marc_day" id="daly_marc_day" onchange="javascript:submitFrm();">
       <option selected="selected" value="0">select # of days:</option>
       <option value="1">1</option>
       <option value="2">2</option>
       <option value="3">3</option>
       <option value="4">4</option>
       <option value="5">5</option>
     </cfselect></td>
     <td class="tabletext" valign="top">$
       <cfinput name="daly_marc_cst" type="text" id="daly_marc_cst" size="10" onchange="javascript:submitFrm();" value="0"/></td>
     <td align="right" valign="top" class="tabletext" nowrap="nowrap">$<span id="marcWK"></span></td>
     <td align="center" valign="top" class="tabletext">4.2</td>
     <td align="right" valign="top" class="tabletext" nowrap="nowrap">$<span id="marcMN"></span></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td class="tabletext" valign="top">Maryland Transit Administration (MTA) Bus</td>
     <td class="tabletext" valign="top"><cfselect name="daly_mta_day" id="daly_mta_day" onchange="javascript:submitFrm();">
       <option selected="selected" value="0">select # of days:</option>
       <option value="1">1</option>
       <option value="2">2</option>
       <option value="3">3</option>
       <option value="4">4</option>
       <option value="5">5</option>
     </cfselect></td>
     <td class="tabletext" valign="top">$<cfinput name="daly_mta_cst" type="text" id="daly_mta_cst" size="10" onchange="javascript:submitFrm();" value="0"/></td>
     <td align="right" valign="top" class="tabletext" nowrap="nowrap">$<span id="mtaWK"></span></td>
     <td align="center" valign="top" class="tabletext" nowrap="nowrap">4.2</td>
     <td align="right" valign="top" class="tabletext" nowrap="nowrap">$<span id="mtaMN"></span></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td class="tabletext" valign="top">Other (specify):
       <cfinput name="daly_oth1_txt" type="text" id="daly_oth1_txt" /></td>
     <td class="tabletext" valign="bottom"><cfselect name="daly_oth1_day" id="daly_oth1_day" onchange="javascript:submitFrm();">
       <option selected="selected" value="0">select # of days:</option>
       <option value="1">1</option>
       <option value="2">2</option>
       <option value="3">3</option>
       <option value="4">4</option>
       <option value="5">5</option>
     </cfselect></td>
     <td class="tabletext" valign="bottom">$
       <cfinput name="daly_oth1_cst" type="text" id="daly_oth1_cst" size="10" onchange="javascript:submitFrm();" value="0"/></td>
     <td align="right" valign="bottom" class="tabletext" nowrap="nowrap">$<span id="oth1WK"></span></td>
     <td align="center" valign="bottom" class="tabletext" nowrap="nowrap">4.2</td>
     <td align="right" valign="bottom" class="tabletext" nowrap="nowrap">$<span id="oth1MN"></span></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td class="tabletext" valign="top">Other (specify):
       <cfinput name="daly_oth2_txt" type="text" id="daly_oth2_txt" /></td>
     <td class="tabletext" valign="bottom"><cfselect name="daly_oth2_day" id="daly_oth2_day" onchange="javascript:submitFrm();">
       <option selected="selected" value="0">select # of days:</option>
       <option value="1">1</option>
       <option value="2">2</option>
       <option value="3">3</option>
       <option value="4">4</option>
       <option value="5">5</option>
     </cfselect></td>
     <td class="tabletext" valign="bottom">$
       <cfinput name="daly_oth2_cst" type="text" id="daly_oth2_cst" size="10" onchange="javascript:submitFrm();" value="0"/></td>
     <td align="right" valign="bottom" class="tabletext" nowrap="nowrap">$<span id="oth2WK"></span></td>
     <td align="center" valign="bottom" class="tabletext" nowrap="nowrap">4.2</td>
     <td align="right" valign="bottom" class="tabletext" nowrap="nowrap">$<span id="oth2MN"></span></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td class="tabletext" valign="top">Other (specify):
       <cfinput name="daly_oth3_txt" type="text" id="daly_oth3_txt" /></td>
     <td class="tabletext" valign="bottom"><cfselect name="daly_oth3_day" id="daly_oth3_day" onchange="javascript:submitFrm();">
       <option selected="selected" value="0">select # of days:</option>
       <option value="1">1</option>
       <option value="2">2</option>
       <option value="3">3</option>
       <option value="4">4</option>
       <option value="5">5</option>
     </cfselect></td>
     <td class="tabletext" valign="bottom">$
       <cfinput name="daly_oth3_cst" type="text" id="daly_oth3_cst" size="10" value="0" onchange="javascript:submitFrm();"/></td>
     <td align="right" valign="bottom" class="tabletext" nowrap="nowrap">$<span id="oth3WK"></span></td>
     <td align="center" valign="bottom" class="tabletext" nowrap="nowrap">4.2</td>
     <td align="right" valign="bottom" class="tabletext" nowrap="nowrap">$<span id="oth3MN"></span></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td class="tabletext" valign="top">Other (specify):
       <cfinput name="daly_oth4_txt" type="text" id="daly_oth4_txt" /></td>
     <td class="tabletext" valign="bottom"><cfselect name="daly_oth4_day" id="daly_oth4_day" onchange="javascript:submitFrm();">
       <option selected="selected" value="0">select # of days:</option>
       <option value="1">1</option>
       <option value="2">2</option>
       <option value="3">3</option>
       <option value="4">4</option>
       <option value="5">5</option>
     </cfselect></td>
     <td class="tabletext" valign="bottom">$
       <cfinput name="daly_oth4_cst" type="text" id="daly_oth4_cst" size="10" value="0" onchange="javascript:submitFrm();"/></td>
     <td align="right" valign="bottom" class="tabletext" nowrap="nowrap">$<span id="oth4WK"></span></td>
     <td align="center" valign="bottom" class="tabletext" nowrap="nowrap">4.2</td>
     <td align="right" valign="bottom" class="tabletext" nowrap="nowrap">$<span id="oth4MN"></span></td>
   </tr>
   <tr>
     <td colspan="6" align="center" bgcolor="#f3f3f3"><img src="/images/hex-808080.gif" alt="" width="670" height="1" /></td>
   </tr>
   <tr>
     <td valign="top" class="tabletext"><strong>Total Daily Fares Per Month </strong></td>
     <td class="tabletext" valign="top"> </td>
     <td class="tabletext" valign="top"> </td>
     <td class="tabletext" valign="top"> </td>
     <td class="tabletext" valign="top"> </td>
     <td align="right" valign="top" class="tabletext"><strong>$<span id="dailytot"></span></strong></td>
   </tr>
          <tr>
<td valign="top" colspan="6"><p> </p>
            <p><strong>Total Monthly Costs <br />
          <br />
              </strong></p></td>
          </tr>



   <tr>
     <td colspan="5" valign="top" class="tabletext">Total Monthly Passes and Fees </td>
     <td class="tabletext" valign="top">$<span id="monthtot2"></span></td>
   </tr>
   <tr>
     <td colspan="5" valign="top" class="tabletext">Total Daily Fares Per Month </td>
     <td class="tabletext" valign="top">$<span id="dailytot2"></span></td>
   </tr>
   <tr>
     <td colspan="5" valign="top" class="tabletext"><strong>Total Monthly Costs <span id="warn" class="red"></span></strong></td>
     <td valign="top" class="tabletext_large"><strong>$<span id="combtot"></span></strong></td>
   </tr>
</table>
          <p><span class="subhead"><br />
    Certifications</span><br />
   <img src="/images/bluefade.jpg" width="457" height="1" vspace="5" /><br />
   Please read the following statements and certify your understanding and agreement below. Clicking the I Accept button will submit your application.          </p>
<table border="0" cellpadding="6" cellspacing="0" width="100%">
<tbody><tr>
<td valign="top" nowrap="nowrap"><span class="red">*</span>
<cfinput name="cert1" id="cert1" value="cert1" type="checkbox" required="Yes"></td>
<td>I work for the National Science Foundation and am eligible to participate in this program. I will use transit benefits for my specific work-related commuting between my 1) home and office and/or 2) home and other <strong>local</strong> training/meeting/work sites. I will not use any portion of transit benefits to pay for parking. (NSF offers a separate fringe benefit program for parking.) I may use transit benefits for my commuting costs to and from work only. I will not sell or transfer transit benefits to anyone else. I will not use transit benefits to pay for official travel expenses or for any expenses for which I am otherwise compensated.</td>

</tr>
<tr>
<td valign="top"><span class="red">*</span>
<cfinput name="cert2" id="cert2" value="cert2" type="checkbox" required="Yes"></td>
<td>The monthly benefits I receive may not exceed what I pay for eligible public transportation to commute to and from work. I usually spend <strong>$<span id="monthtot_cert"></strong> per month on public transportation to and from work, as calculated on the transit subsidy calculation form. My calculated expenses do not include any days on which I telework or otherwise routinely do not commute to and from work.</td>

</tr>
<tr>
<td valign="top"><span class="red">*</span>
<cfinput name="cert3" id="cert3" value="cert3" type="checkbox" required="Yes"></td><td>I am not a member of another Federal agency's government-funded commuter vanpool or carpool and do not receive transportation benefits or a parking subsidy from another Federal agency.</td>
</tr>
<tr>
<td valign="top"><span class="red">*</span>

<cfinput name="cert4" id="cert4" value="cert4" type="checkbox" required="Yes"></td><td>It is my responsibility to reduce what I accept in any month by the amount associated with any work days for which I know I will not be using covered public transportation to commute to and from work (e.g., for leave, travel, additional telework days, etc.)</td>
</tr>
<tr>
<td valign="top"><span class="red">*</span>
<cfinput name="cert5" id="cert5" value="cert5" type="checkbox" required="Yes"></td><td>If I get SmartBenefits vouchers, it is my responsibility to return unused ones to the NSF each month. If I get electronic fare, it is my responsibility to reduce the fare I take by the unused amount in the previous month. If I receive nonrefundable monthly benefits (vanpool, monthly rail, monthly commuter bus) this is not applicable.</td>
</tr>

<tr>
<td valign="top"><span class="red">*</span>
<cfinput name="cert6" id="cert6" value="cert6" type="checkbox" required="Yes"></td><td>I will submit a new application and costs calculation if my address/commuting expenses change. My benefits will be canceled when I leave the NSF, and I will not accept benefits after I depart.</td>
</tr>
<tr>
<td valign="top"><span class="red">*</span>

<cfinput name="cert7" id="cert7" value="cert7" type="checkbox" required="Yes"></td><td>I understand that an NSF transit benefits coordinator will review a random sample of participants' actual hours worked; benefits distributions; fare calculations; addresses; leave requests; and travel authorizations/vouchers, to ensure recipients are receiving appropriate benefits. Staff will comply with the Privacy Act and appropriately protect and secure all random sample review data. </td>
</tr>
<tr>
<td valign="top"><span class="red">*</span>
<cfinput name="cert8" id="cert8" value="cert8" type="checkbox" required="Yes"></td><td>I have read the statements above and I certify that I accept the conditions of the program as stated above.</td>
</tr>

</tbody></table>
<p>This certification concerns a matter within the jurisdiction of the National Science Foundation, an agency of the United States, and making false, fictitious, or fraudulent certification may render me ineligible for future participation in the transit subsidy program; and subject to criminal prosecution, fine (up to $10,000 per violation), imprisonment and disciplinary action up to and including removal from Federal service. </p>

<cfoutput>
<cfinput type="hidden" name="appl_subm_date" value="#DateFormat(Now(), "mm/dd/yyyy")#">
<cfinput type="hidden" name="last_updt_user" value="#session.lan_id#">
<cfinput type="hidden" name="lan_id" value="#session.lan_id#" />
<cfinput type="hidden" name="tot_mnth_cost" value="" id="tot_mnth_cost" />
<cfinput type="hidden" name="tot_dly_cost" value="" id="tot_dly_cost" />
<cfinput type="hidden" name="rqst_tot" value="" id="rqst_tot" />
<cfinput type="hidden" name="appl_stts" value="Submitted" id="appl_stts" />
<input type="hidden" name="myaction" value="submit" />
</cfoutput>
           <p><input id="submit" value="I Agree. Submit My Application." type="submit" onclick="javascript:ColdFusion.navigate('index.cfm',null,mycallBack,myError,'POST','tran_app');">
           </p>

<p>PRIVACY ACT STATEMENT: This information is solicited under authority of 5 U.S. C. Sections 301 and 7905. Furnishing the information on this form is voluntary, but failure to do so may result in disapproval of your request for a public transit fare benefit. The purpose of this information is to facilitate timely processing of your request, to ensure your eligibility, and to prevent misuse of the funds involved. This information may be matched with lists at other Federal agencies to ensure that you are not listed as a carpool or vanpool participant or a holder of any other form of vehicle work site parking permit with any Federal agency. </p>

</cfform>

========================================appl_form.cfm end

transit.cfc=======================================

</cffunction>

<cffunction name="getUserApps" access="remote"
            description="get all submitted apps for a lan_id" returntype="query">
    <cfargument name="UserId" type="String" required="Yes" default="">
    <cfquery name="GetUserApps" datasource="transit" dbtype="Sybase">
    select * from transit.rqst
    where lan_id = '#arguments.UserId#'
    </cfquery>

    <cfreturn GetUserApps>

</cffunction>

<cffunction name="getPendingApps" access="remote"
            description="get all pending approval" returntype="query">
    <cfquery name="getPendingApps" datasource="transit" dbtype="Sybase">
    select * from transit.rqst
    where appl_stts = 'Submitted'
    order by appl_subm_date ASC
    </cfquery>
    <cfreturn getPendingApps>
</cffunction>

<cffunction name="getVerifiedApps" access="remote"
            description="get all approved" returntype="query">
    <cfquery name="getVerifiedApps" datasource="transit" dbtype="Sybase">
    select * from transit.rqst
    where appl_stts = 'verified'
    and appl_exp_date is NULL
    order by appl_aprv_date DESC
    </cfquery>
    <cfreturn getVerifiedApps>
</cffunction>

<cffunction name="getPerson" access="remote"
            description="get staffdir data" returntype="query">
   <cfargument name="UserID" type="String" required="Yes" default="">
    <cfquery name="GetPerson" datasource="staffadmin">
    SELECT    pers_id, frst_name, mid_name, last_name, email
    FROM    nsfs.pers
    WHERE    lan_id = '#arguments.UserID#'
    </cfquery>

<cffunction name="getRole" access="remote"
            description="get user role" returntype="query">
   <cfargument name="UserID" type="String" required="Yes" default="">
    <cfquery name="GetRole" datasource="transit">
    SELECT    role_type
    FROM    transit.user_roles
    WHERE    lan_id = '#arguments.UserID#'
    AND role_exp_date is NULL
    </cfquery>

<cffunction name="getAppDetails" access="remote"
            description="get application data by rqst_id" returntype="query">
    <cfargument name="RID" type="String" required="Yes" default="">
    <cfquery name="getAppDetails" datasource="transit" dbtype="Sybase">
    select * from transit.rqst
    where rqst_id = #arguments.RID#
    </cfquery>

    <cfreturn getAppDetails>

</cffunction>

<cfprocessingdirective suppresswhitespace="No">
    <cfmail from="#transit_email#"
        subject="NSF Transit Benefits Application Received"
        to="#AppDetails.lan_id#@nsf.gov"
        cc="trinehar@nsf.gov"
        type="Html">
<style type="text/css">
    <!--
.tablehead {text-align:left; font-family:Verdana; font-size:x-small; font-weight:bold; background-color:##A5ABB2; color:##ffffff; padding-top:4px; padding-bottom:7px; padding-left:10px; padding-right:4px; border-right:1px white solid;}
.tablehead2 {text-align:left; font-family:Verdana; font-size:x-small; font-weight:bold; background-color:##A5ABB2; color:##ffffff; padding-top:4px; padding-bottom:7px; padding-left:10px; padding-right:4px; border-right:1px white solid; border-bottom:1px white solid;}
.tabletext {font-family:Verdana; font-size:x-small; background-color:##F3F1F1; color:##000000; padding:7px;}
.tabletext2 {font-family:Verdana; font-size:x-small; color:##000000; padding:7px;}

    p, li { font-family: Verdana; font-size : 10pt; padding-left:6pt; line-height:14pt;}

    -->
</style>

<p>Below is a copy of your Application for Transit Benefits. You will receive another email when your application has been verified by the DAS Transit Official. Please send any questions to DAS Transit.</p>

    <table border="0" cellspacing="0" cellpadding="6">
<tr>
    <td valign="top" class="tabletext2">Name</td>
    <td valign="top" class="tabletext2">#get_name.frst_name# #get_name.mid_name# #get_name.last_name# (<a href="mailto:#get_name.email#">#get_name.email#</a>)</td>
</tr>

<tr>
<td valign="top" class="tabletext2">Address</td>
<td valign="top" class="tabletext2">
#AppDetails.addr_strt_num# #AppDetails.addr_strt_name#<cfif #AppDetails.addr_apt_num# NEQ ""> Apt #AppDetails.addr_apt_num#</cfif>, #AppDetails.addr_city#, #AppDetails.addr_st# #AppDetails.addr_zip_code#</td>
</tr>

<tr>
<td valign="top" class="tabletext2">Smart Benefit No.</td>
<td valign="top" class="tabletext2">#AppDetails.smrt_bnft_srl#</td>
</tr>

<tr>
<td valign="top" class="tabletext2" >Amount Requested</td>
<td valign="top" class="tabletext2">$#NumberFormat(AppDetails.rqst_tot,'9999.99')#</td>
</tr>

<tr>
<td valign="top" class="tabletext2">Date Submitted</td>
<td valign="top" class="tabletext2">#DateFormat(AppDetails.appl_subm_date, "mm/dd/yyyy")#</td>
</tr>

<tr>
<td valign="top" class="tabletext2">Status</td>
<td valign="top" class="tabletext2">#AppDetails.appl_stts#</td>
</tr>

<tr>
      <td valign="top" class="tabletext2">Approval Date</td>
    <td valign="top" class="tabletext2">#DateFormat(AppDetails.appl_aprv_date, "mm/dd/yyyy")#</td>
</tr>
</table>

<p class="text"><span class="subhead">Detailed Commuting Costs</span><br />
                          <img src="/images/bluefade.jpg" width="457" height="1" vspace="5" /></p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
    <td valign="top" colspan="6"><p class="text"><strong>Monthly Passes and Fees<br />
      </strong><br />
    </p></td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tablehead" id="first_column_description" >Mode of Transportation </td>
    <td class="tablehead" id="third_column_description" valign="top">Cost Per Month </td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tabletext">Virginia Railway Express (VRE) </td>
    <td align="right" valign="top" nowrap="nowrap" class="tabletext">$#AppDetails.mnth_vre_cst#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tabletext">Maryland Area Regional Commuter (MARC) Train </td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.mnth_marc_cst#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tabletext">Maryland Transit Administration (MTA) Bus </td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.mnth_mta_cst#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tabletext">Vanpool </td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.mnth_van_cst#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tabletext">Other:
      #AppDetails.mnth_oth1_txt#</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.mnth_oth1_cst#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tabletext">Other:      #AppDetails.mnth_oth2_txt#</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.mnth_oth2_cst#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tabletext"><strong>Total Monthly Passes and Fees </strong></td>
    <td align="right" valign="top" class="tabletext"><strong>$#AppDetails.tot_mnth_cost#</strong></td>
</tr>
<tr>
    <td valign="top" colspan="6">
        <p class="text"><strong>Daily Fares</strong><br />
          <br />
      </p></td>
</tr>
<tr>
    <td class="tablehead" id="first_column_description" valign="top" >Mode of Transportation </td>
    <td class="tablehead" id="second_column_description" valign="top">Number of Days Per Week Mode of Transportation Is Used </td>
    <td class="tablehead" id="second_column_description" valign="top">Roundtrip Cost </td>
    <td class="tablehead" id="third_column_description" valign="top">Cost Per Week</td>
    <td class="tablehead" id="third_column_description" valign="top">Average Weeks Per Month </td>
    <td class="tablehead" id="third_column_description" valign="top">Cost Per Month </td>
</tr>
<tr>
    <td class="tabletext" valign="top">Metro Rail:
      #AppDetails.mtro_stn#    </td>
    <td align="center" valign="bottom" class="tabletext">#AppDetails.daly_mtro_rail_day#</td>
    <td align="right" valign="bottom" nowrap="nowrap" class="tabletext">$#AppDetails.mtro_fare * 2#</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.mtro_fare * 2 * AppDetails.daly_mtro_rail_day#</td>
    <td align="center" valign="bottom" class="tabletext">4.2</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.mtro_fare * 2 * AppDetails.daly_mtro_rail_day * 4.2#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td class="tabletext" valign="top">Metro Bus </td>
    <td align="center" valign="top" class="tabletext">#AppDetails.daly_mtro_bus_day#</td>
    <td align="right" valign="top" nowrap="nowrap" class="tabletext">$#AppDetails.daly_mtro_bus_cst#</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_mtro_bus_cst * AppDetails.daly_mtro_bus_day#</td>
    <td align="center" valign="top" class="tabletext">4.2</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_mtro_bus_cst * 2 * AppDetails.daly_mtro_bus_day * 4.2#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td class="tabletext" valign="top">Virginia Railway Express (VRE)</td>
    <td align="center" valign="top" class="tabletext">#AppDetails.daly_vre_day#</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_vre_cst#</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_vre_cst * AppDetails.daly_vre_day#</td>
    <td align="center" valign="top" class="tabletext">4.2</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_vre_cst * AppDetails.daly_vre_day * 4.2#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td class="tabletext" valign="top">Maryland Area Regional Commuter (MARC) Train </td>
    <td align="center" valign="top" class="tabletext">#AppDetails.daly_marc_day#</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_marc_cst#</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_marc_cst * AppDetails.daly_marc_day#</td>
    <td align="center" valign="top" class="tabletext">4.2</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_marc_cst * AppDetails.daly_marc_day * 4.2#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td class="tabletext" valign="top">Maryland Transit Administration (MTA) Bus</td>
    <td align="center" valign="top" class="tabletext">#AppDetails.daly_mta_day#</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_mta_cst#</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_mta_cst * AppDetails.daly_mta_day#</td>
    <td align="center" valign="top" class="tabletext">4.2</td>
    <td align="right" valign="top" class="tabletext">$#AppDetails.daly_mta_cst * AppDetails.daly_mta_day * 4.2#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td class="tabletext" valign="top">Other:      #AppDetails.daly_oth1_txt#</td>
    <td align="center" valign="bottom" class="tabletext">#AppDetails.daly_oth1_day#</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth1_cst#</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth1_cst * AppDetails.daly_oth1_day#</td>
    <td align="center" valign="bottom" class="tabletext">4.2</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth1_cst * AppDetails.daly_oth1_day * 4.2#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td class="tabletext" valign="top">Other:      #AppDetails.daly_oth2_txt#</td>
    <td align="center" valign="bottom" class="tabletext">#AppDetails.daly_oth2_day#</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth2_cst#</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth2_cst * AppDetails.daly_oth2_day#</td>
    <td align="center" valign="bottom" class="tabletext">4.2</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth2_cst * AppDetails.daly_oth2_day * 4.2#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td class="tabletext" valign="top">Other:      #AppDetails.daly_oth3_txt#</td>
    <td align="center" valign="bottom" class="tabletext">#AppDetails.daly_oth3_day#</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth3_cst#</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth3_cst * AppDetails.daly_oth3_day#</td>
    <td align="center" valign="bottom" class="tabletext">4.2</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth3_cst * AppDetails.daly_oth3_day * 4.2#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td class="tabletext" valign="top">Other:      #AppDetails.daly_oth4_txt#</td>
    <td align="center" valign="bottom" class="tabletext">#AppDetails.daly_oth4_day#</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth4_cst#</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth4_cst * AppDetails.daly_oth4_day#</td>
    <td align="center" valign="bottom" class="tabletext">4.2</td>
    <td align="right" valign="bottom" class="tabletext">$#AppDetails.daly_oth4_cst * AppDetails.daly_oth4_day * 4.2#</td>
</tr>
<tr>
    <td colspan="6" align="center" bgcolor="##f3f3f3"><img src="/images/hex-808080.gif" alt="" width="98%" height="1" /></td>
</tr>
<tr>
    <td valign="top" class="tabletext"><strong>Total Daily Fares Per Month </strong></td>
    <td class="tabletext" valign="top"> </td>
    <td class="tabletext" valign="top"> </td>
    <td class="tabletext" valign="top"> </td>
    <td class="tabletext" valign="top"> </td>
    <td align="right" valign="top" class="tabletext"><strong>$#AppDetails.tot_dly_cost#</strong></td>
</tr>
<tr>
    <td valign="top" colspan="6">
        <p class="text"><strong>Total Monthly Costs <br />
              <br />
      </strong></p></td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tabletext">Total Monthly Passes and Fees </td>
    <td class="tabletext" valign="top">$#NumberFormat(AppDetails.tot_mnth_cost,'9999.99')#</td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tabletext">Total Daily Fares Per Month </td>
    <td class="tabletext" valign="top">$#NumberFormat(AppDetails.tot_dly_cost,'9999.99')#</td>
</tr>
<tr>
    <td colspan="5" valign="top" class="tabletext"><strong>Total Monthly Costs </strong></td>
    <td valign="top" class="tabletext"><strong><span class="tabletext2">$#NumberFormat(AppDetails.rqst_tot,'9999.99')#</span></strong></td>
</tr>
</table>
<p>You have certified that you understand and agree with these statements:</p>
<ul>
<li>I work for the National Science Foundation and am eligible to participate in this program. I will use transit benefits for my specific work-related commuting between my 1) home and office and/or 2) home and other local training/meeting/work sites. I will not use any portion of transit benefits to pay for parking. (NSF offers a separate fringe benefit program for parking.) I may use transit benefits for my commuting costs to and from work only. I will not sell or transfer transit benefits to anyone else. I will not use transit benefits to pay for official travel expenses or for any expenses for which I am otherwise compensated.</li>
<li>The monthly benefits I receive may not exceed what I pay for eligible public transportation to commute to and from work. I usually spend #NumberFormat(AppDetails.rqst_tot,'9999.99')# per month on public transportation to and from work, as calculated on the transit subsidy calculation form. My calculated expenses do not include any days on which I telework or otherwise routinely do not commute to and from work.</li>
<li>I am not a member of another Federal agency's government-funded commuter vanpool or carpool and do not receive transportation benefits or a parking subsidy from another Federal agency.</li>
<li>It is my responsibility to reduce what I accept in any month by the amount associated with any work days for which I know I will not be using covered public transportation to commute to and from work (e.g., for leave, travel, additional telework days, etc.)</li>
<li>If I get SmartBenefits vouchers, it is my responsibility to return unused ones to the NSF each month. If I get electronic fare, it is my responsibility to reduce the fare I take by the unused amount in the previous month. If I receive nonrefundable monthly benefits (vanpool, monthly rail, monthly commuter bus) this is not applicable.</li>
<li>I will submit a new application and costs calculation if my address/commuting expenses change. My benefits will be canceled when I leave the NSF, and I will not accept benefits after I depart.</li>
<li>I understand that an NSF transit benefits coordinator will review a random sample of participants' actual hours worked; benefits distributions; fare calculations; addresses; leave requests; and travel authorizations/vouchers, to ensure recipients are receiving appropriate benefits. Staff will comply with the Privacy Act and appropriately protect and secure all random sample review data.</li>
<li>I have read the statements above and I certify that I accept the conditions of the program as stated above.</li>
</ul>
</cfmail>

<cfmail to="#transit_email#"
        subject="NSF Transit Benefits Application Submitted by #get_name.frst_name# #get_name.mid_name# #get_name.last_name#"
        from="#transit_email#"
        type="html">
<style type="text/css">
    
</style>
<p>An Application for Transit Benefits has been submitted by #get_name.frst_name# #get_name.mid_name# #get_name.last_name#. You can review and verify this application at .... </p>
</cfmail>
</cfprocessingdirective>

</cffunction>

<cfset AppDetails = getAppDetails(arguments.RID)>
    <cfset get_name = getPerson(#AppDetails.lan_id#)>


    <cfprocessingdirective suppresswhitespace="No">
    <cfmail from="#transit_email#"
        subject="NSF Transit Benefits Application Verified"
        to="#AppDetails.lan_id#@nsf.gov"
        cc="trinehar@nsf.gov"
        type="Html">
<style type="text/css">
    
</style>
    <p>Your Application for Transit Benefits has been verified.</p>

</cfmail>
</cfprocessingdirective>
</cffunction>

<cfprocessingdirective suppresswhitespace="No">
    <cfmail from="#transit_email#"
        subject="NSF Transit Benefits Application Cancelled"
        to="#AppDetails.lan_id#@nsf.gov"
        cc="trinehar@nsf.gov"
        type="Html">
<style type="text/css">
    
</style>
<p>    Your Application for Transit Benefits was cancelled on #AppDetails.last_updt_tmsp# by #AppDetails.last_updt_user#.</p>

</cfmail>
</cfprocessingdirective>
</cffunction>

</cfcomponent>

trineharAuthor

Participant

I forgot, also tried removing the onclick and leaving only the onsubmit, with the navigate tag. This inserts the dat, but then throws a CF error as if the data was being submitted a second time with blank fields.

Hello World!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded