jqGrid Server side

-

i use jqgrid project using following server side code coldfusion in cfc file.

the jqgrid works few pages.

i can scroll couple of page using jqgrid pager.

it seems page , records information not send jqgrid correctly.

do need particular pass row, pages , records information client make server response correct pages?

 

your , information great appreciated,

 

regards,

 

iccsi,

 

 

<cffunction name="ccdclaimslookup" access="remote" returnformat="json">
  
    <cfargument name ="startdate" required="no" default="">
    <cfargument name ="enddate" required="no" default="">
    <cfargument name="page" required="no" default="1">
    <cfargument name="rows" required="no" default="10">
    <cfargument name="sidx" required="no" default="">
    <cfargument name="sord" required="no" default="asc">
   
    <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 = "#startdate#" cfsqltype = "cf_sql_date">
      <cfprocparam value = "#enddate#" cfsqltype = "cf_sql_date">
    
      <cfprocresult name="spname" resultset="1">
  </cfstoredproc>
 
     <cfloop query="spname" startrow="#start#" endrow="#end#">

       <cfset mydata[i] = [#myid#,#myname#,#mydate#,#mynote#]>

            <cfset = + 1>           
  </cfloop>

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

 

<cfreturn #serializejson(stcreturn, true)#>
    
</cffunction>

@isccsi,

 

i can't comment on data passing jqgrid, haven't used jquery plugin myself.  did notice 1 thing problem.  using serializejson() function on data, specifying returnformat on function json.  specifying returnformat causes value being returned automatically serialized json; thus, serializing data twice (once calling serializejson function, coldfusion again automatically when returns data).  may cause json become malformed. 

 

since not returning query directly function (you looping through , building array of arrays), shouldn't need serializejson call @ all.  should able return stcreturn variable.

 

hth,

carl v.



More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

Adobe Acrobat Pro , Terminal Server Use

-
hello,   a fellow employee requires adobe acrobat pro installed use, , management me have sorted out. employee uses thin client connect terminal server of administration work.   i require single license adobe acrobat pro used single user.   will there license issues installing adobe acrobat pro on terminal server?   can install adobe acrobat pro on terminal server?   thanks, david hi david,   yes, can install acrobat terminal servers... !   the licensing terminal server considered normal licensing process, means need buy many number of licenses acrobat number of users accessing terminal server (like citrix) access software. eg if 10 users accessing citrix server @ particular time use acrobat software need 10 licenses same. More discussions in Installing, Updating, & Subscribing to Acrobat adobe
Read more

Thread: transmission-daemon isn't playing nice: "409: Conflict"

-
409: conflict request had invalid session-id header. fix this, follow these steps: when reading response, x-transmission-session-id header , remember it add updated header outgoing requests when 409 error message, resend request updated header requirement has been added prevent csrf attacks. error occurs when apache not running. i've tried zillion different proposed solutions involving rewriterules , proxypasses golly i'm clueless. me? following apache thing, y'know, in case. code: <virtualhost *:80> rewriteengine on documentroot /var/www <directory /> options followsymlinks allowoverride none </directory> <directory /var/www/> options indexes followsymlinks multiviews allowoverride none order allow,deny allow </directory> scriptalias /cgi-bin/ /usr/lib/cgi-bin/ <directory "/usr/lib/cgi-bin"> allowov...
Read more

Thread: gpg: Conflicting Commands

-
Image
hi, relatively new linux (have used many live disks) , have had install of ubuntu 12.04 few days now. part have found easy use , have been comfortable it. have first question can't resolve myself: adding googles repository list. when first ran command supplied google found did not have wget installed. used apt-get install it. worked fine (as far can tell) re-ran googles code : wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -o- | sudo apt-key add -deb http://dl.google.com/linux/deb/ stable non-free , message 'gpg: conflicting commands' tell me going wrong , how fix please new script : wget -q https://dl-ssl.google.com/linux/linux_signing_key.pub -o- | sudo apt-key add linux_signing_key.pub need edit /etc/apt/sources.list , add line @ end deb http://dl.google.com/linux/deb/ stable non-free end hope find usefull edit: need root or use sudo make changes /etc/apt/sour...
Read more