?
Solved

JQuery and CFC

Posted on 2014-10-08
3
Medium Priority
?
271 Views
Last Modified: 2014-10-09
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

0
Comment
Question by:digitalwise
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 58

Accepted Solution

by:
Julian Hansen earned 2000 total points
ID: 40370350
Not that experienced with CF but in your code you seem to be using an argument called classdate but from jQuery you are passing an argument as testdate - is that a CF thing or should they be the same?
0
 

Author Closing Comment

by:digitalwise
ID: 40372032
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!
0
 
LVL 58

Expert Comment

by:Julian Hansen
ID: 40372318
You are welcome - thanks for the points and the grade. Have a great day.
0

Featured Post

Command Line Tips and Tricks

The command line is a powerful tool at the disposal of every Linux user. Although Linux distros come with beautiful user interfaces, it's worthwhile to learn the command line because it allows you to do a number of things that you otherwise cannot do from the GUI.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are a couple ways to attach a JavaScript function to dynamically created elements. You can make a new script for each element as it’s created or you can use delegation. Delegation allows a single script that is added at page creation to mat…
Recently while working on a project I got a very annoying cfdocument has no body error message. I had never seen this error before. So I checked the code. The code was pretty simple; it was Just showing me the cfdocumnt tag and inside that tag a …
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question