ajaxcall.cfc

<cfcomponent>
    <cffunction name="GetMtDetails" access="remote" returnformat="plain">
        <cfset sdate = "#dateformat(sdt,'yyyy/mm/dd')# 00:00:00" />
        <cfset eDate = "#dateformat(edt,'yyyy/mm/dd')# 23:59:59" />
      
        <cfquery name="TotalMessages" datasource="Test">
            SELECT COUNT(*) as CountMessages FROM sms_Delivery
            WHERE
                DateSent_dt BETWEEN '#sdate#' AND '#eDate#'
        </cfquery>
        <cfquery name="TotalOptOuts" datasource="Test">
            SELECT COUNT(*) as CountMessages FROM stop_Sms
            WHERE
                RequestDate_dt BETWEEN '#sdate#' AND '#eDate#'
        </cfquery>
        <cfquery name="TotalMOResponse" datasource="Test">
            SELECT COUNT(*) as CountMOResponse FROM sms_MOResponse
            WHERE
                DateCreated_dt BETWEEN '#sdate#' AND '#eDate#'
        </cfquery>
        <cfset MtDetails =  QueryNew("TotalSMS,TotalOptOuts,TotalMO")>    
        <cfset QueryAddRow(MtDetails) />
                    <cfset QuerySetCell(MtDetails, "TotalSMS", "#TotalMessages.CountMessages#") />
                    <cfset QuerySetCell(MtDetails, "TotalOptOuts", "#TotalOptOuts.CountMessages#") />
                    <cfset QuerySetCell(MtDetails, "TotalMO", "#TotalMOResponse.CountMOResponse#") />               
                   
        <cfreturn MtDetails>           
    </cffunction>
  
</cfcomponent>           

postdata.cfm

<script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script>
<cfparam name="startDate" default="#dateformat(dateadd('d',-600,now()),'yyyy/mm/dd')# 00:00:00"/>
<cfparam name="endDate" default="#dateformat(dateadd('d',1,now()),'yyyy/mm/dd')# 00:00:00"/>
<script>
function mtdetails()
{
    var sdt = $('#dateS').val(); 
    var edt = $('#dateStop').val();   
    $.getJSON("cfc/ajaxcall.cfc?method=GetMtDetails&sdt="+sdt+"&edt="+edt+"&returnformat=json&queryformat=column", {}, function(res,code)
    {
        $("#TotalSMS").html(parseInt(res.DATA.TotalSMS)); 
        $("#TotalOptOuts").html(parseInt(res.DATA.TotalOptOuts));
        $("#TotalMT").html(parseInt(res.DATA.TotalSMS));
        $("#TotalMO").html(parseInt(res.DATA.TotalMO));
    });
    return false;
}
</script>
<cfform name="filterDialerDetails" id="filterDialerDetails" onsubmit="return mtdetails()">
<cfoutput>
    <label>Start Date Time</label><br />
    <input type="text" name="dateS" id="dateS" value="#dateformat(startDate,'mm-dd-yyyy')#" style="width:120px" onClick="this.blur()"> &nbsp;
    <Br>
    <label>End Date Time</label><br />
    <input type="text" name="dateStop" id="dateStop" value="#dateformat(endDate,'mm-dd-yyyy')#" style="width:120px" onClick="this.blur()"> &nbsp;
    <input type="submit" name="getMap" id="getMap" value="Show Result" />
</cfoutput>   
</cfform>
           
           
           
<table cellpadding="5" cellspacing="5" class="summary">
<tr>
    <td colspan="2" style="font-size:14px; color:##666"><b>Overall Summary</b></td>
</tr>
<tr>
    <td align="right" valign="middle">Total SMS</td>
    <td id="LIVESUMMARY" valign="middle" class="tdVal"><div id="TotalSMS"></div></td>
</tr>
<tr>
    <td align="right" valign="middle">SMS Opt-Outs</td>
    <td id="MACHINESUMMARY" valign="middle" class="tdVal"><div id="TotalOptOuts"></div></td>
</tr>
<tr>
    <td align="right" valign="middle">MT</td>
    <td id="BUSYSUMMARY" valign="middle" class="tdVal"><div id="TotalMT"></div></td>
</tr>

<tr>
    <td align="right" valign="middle">MO</td>
    <td id="NOANSWERSUMMARY" valign="middle" class="tdVal"><div id="TotalMO"></div></td>
</tr>
</table>