Link to home
Start Free TrialLog in
Avatar of digitalwise
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:
<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>

Open in new window


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.');
				}
		});

}
 

Open in new window


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>

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Julian Hansen
Julian Hansen
Flag of South Africa image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of digitalwise
digitalwise

ASKER

You didn't actually provide me with the solution but you pushed me in another direction - I forgot to call the CFC Function in the jquery.   Thanks!
You are welcome - thanks for the points and the grade. Have a great day.