pass coldfusion data to jQuery DatePicker using jQuery.get()

i use following jquery code pass json data coldfusion  using jquery.get() datepicker.

i tested server side , returns data without error.

i got 'i here' , 'data loaded:" message alert.

the click evnet triggered, not go in success callback function.

any information , great appreciated,

 

regards,

 

iccsi,

 

her client side coe:

 

jquery("#btntest").click( function() {
   alert(' here');
     jquery.get({

        url: 'myserver.cfc?method=mymethod&vmynumber=5',
        datatype: 'json',
        success: function(data)
       {
       alert(" inside");
       jquery("#mydate").datepicker('setdate', data.mydate);
       console.log( data );
                             }
      });
    alert("data loaded: ");
    });

 

here coldfusion server  side code:

 

<cffunction name="mymethod" access="remote" returnformat="json">
 
  <cfargument name="vmynumber" required="yes" default="0" hint="my number">
  <cfargument name="page" required="no" default="1" hint="page user on">
  <cfargument name="rows" required="no" default="10" hint="number of rows display per page">
  <cfargument name="sidx" required="no" default="" hint="sort column">
  <cfargument name="sord" required="no" default="asc" hint="sort order">

<cfset var mydata = arraynew(1)>

<cfset start = ((arguments.page-1)*arguments.rows)+1>
<cfset end = (start-1) + arguments.rows>
<cfset = 1>

<cfstoredproc procedure="mysp">
<cfprocparam value = "#vmynumber#" cfsqltype = "cf_sql_integer">
<cfprocresult name="myprop" resultset="1">
</cfstoredproc>

<cfloop query="myproc" startrow="#start#" endrow="#end#">

       <cfset mydata[i] = [#mynumber#,#mydate#]>

            <cfset = + 1>           
  </cfloop>

     <cfset totalpages = ceiling(myprop.recordcount/arguments.rows)>
     <cfset stcreturn =     {total=#totalpages#,page=#arguments.page#,records=#myprop.recordcount#,rows=#mydata#}>
       

 

<cfreturn stcreturn>

</cffunction>

 

 

here data returned coldfusion server.

 

{"rows":[[6,"may, 03 2002 00:00:00"]],"page":1,"records":1,"total":1.0}

first off all, when declare local variable in function, use "var" scope. prevent problem in future when app gets bigger , somewhere use same variable names.

 

now, let's talk jquery.

1. why use .get() method? critical know doing since problem similar 1 had before.

2. .datepicker('setdate', data.mydate); -- .mydate refer to?

3. wise make sure document ready before allowing user clicking something.

More discussions in ColdFusion

adobe