Post data with getJson in coldfusion

Use of getJson using coldfusion component and QueryNew.

	<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>

view raw ajaxcall.cfc hosted with ❤ by GitHub

	<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>

view raw postdata.cfm hosted with ❤ by GitHub

OutPut :-

After Submit :-