Changes between Version 21 and Version 22 of ServerSidePagination

Timestamp:

01/20/10 04:35:02 (15 years ago)

Author:

Fran Boon

Comment:

--

ServerSidePagination

@@ -38 +38 @@
 sSearch
 }}}
+response should be sent in tbhis format:
+{{{
+aaData": [
+    [row1.field1.value, row1.field2.value, row1.field3.value],
+    [row2.field1.value, row2.field2.value, row2.field3.value]
+]
+}}}
+e.g. using a function like:
+{{{
+def callback():
+    print request.vars
+    from gluon.serializers import json
+    query = ....
+    rows = db(query).select() #<<<
+    r=dict(rEcho=1,
+           iTotalRecords=len(rows),
+           iTotalDisplayRecords=len(rows),
+           aaData=[[row.field1,row.field2] for row in rows])
+    return json(r)
+}}}
+If you print request.vars you can easy figure out what paramers are being passed and change the <<< line accordingly.
 === JSON Back-end implementation ===
  * Support already present in {{{modules\s3xrc.py}}}