digitalwise
asked on
JQuery and CFC
I have a jquery/CFC solution that does a lookup but I am getting
I get "Unsupported Operation. Check application log for more details. " when I try to include the result. If I don't include the result, I get the else showing every time which makes sense since 1 doesn't work. I am using the jquery date picker too with that field.
CFC:
Jquery:
Form
I get "Unsupported Operation. Check application log for more details. " when I try to include the result. If I don't include the result, I get the else showing every time which makes sense since 1 doesn't work. I am using the jquery date picker too with that field.
CFC:
<cfcomponent output="false">
<cffunction name="getCoupon" access="remote" returnType="string">
<cfargument name="classdate" type="string" required="true">
<!--- Define variables --->
<cfset var data="">
<cfset var result="">
<!--- Get data --->
<CFQUERY NAME="getCoupon" datasource="ds">
select couponcode from coupons where testdate1 = '#arguments.classdate#' or testdate2 = '#arguments.classdate#' or testdate3 = '#arguments.classdate#'
</CFQUERY>
<!--- Got it? --->
<cfif getCoupon.RecordCount eq 1>
<cfset result=1>
<CFELSEIF getCoupon.recordcount eq 0 and len(#arguments.classdate#)>
<cfset result=2>
<CFELSE>
<CFSET result=0>
</cfif>
<!--- And return it --->
<cfreturn result>
</cffunction>
</cfcomponent>
Jquery:
$(document).ready(function() {
//result texts
var checking_html = 'Checking...';
//when button is clicked
$('##datepicker').change(function(){
$('##proctor_availability_result').html(checking_html);
check_availability();
});
});
//function to check availability
function check_availability(){
//get the username
var testdate = $('##datepicker').val();
//use ajax to run the check
$.post("testdate.cfc", { testdate: testdate },
function(result){
//if the result is 1
if(result == 1){
//show that the username is available
$('##proctor_availability_result').html(result + 'You do not need to provide proctor information because you are sitting for your test at a scheduled location.');
}else{
//show that the username is NOT available
$('##proctor_availability_result').html(result + 'You must complete proctor information prior to sitting for your exam but you do not need to complete this information to submit your registration.');
}
});
}
Form
<TR><TD valign="top"><strong>Test Date</strong><img src="RedStar.gif" width="10" height="16" alt="Required" border="0">:</TD><TD><input type="text" id="datepicker" readonly name="classdate" value="#dateformat(getreg.startdate, "mm/dd/yyyy")#"></TD></TR>
<TR><TD colspan="2"><div id='proctor_availability_result'></div></TD></TR>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You are welcome - thanks for the points and the grade. Have a great day.
ASKER