Trying to display rows using the datatables.net DataTable() function by
converting query results to JSON, but getting error "Uncaught SyntaxError:
Unexpected token &". Though the raw data displays correctly in the view
below, when I look at the results in the web console debugger I see that
the generated program seems to show the JSON converted back to XML:
<!-- Debugger shows this: -->
$(document).ready(function(){
$("#person-table").DataTable({
"aaData": [{"first_name": "Super",
"last_name": "Man", "id": 1},
{"first_name": "Massimo", "last_name":
"Di Pierro", "id": 2}])
})
});
in model db.py:
db.define_table('person',Field('last_name'), Field('first_name'))
db.person.update_or_insert(last_name='Man',first_name='Super')
db.person.update_or_insert(last_name='Di Pierro',first_name='Massimo')
in controller default.py:
def index():
import json
people = json.dumps(db(db.person).select().as_list())
return dict(results=people)
In view index.html:
<table id="person-table" class="display" cellspacing="0" width="100%">
<thead>
<tr>
<th>ID</th>
<th>First name</th>
<th>Last name</th>
</tr>
</thead>
</table>
...
<h1>Raw data</h1>
<code>
results: {{=results}}
</code>
<script type="text/javascript">
$(document).ready(function(){
$("#person-table").DataTable({
"aaData": $.parseJSON({{=results}})
})
});
</script>
The view prints out an empty Datatable, followed by correctly formed JSON
in the "Raw Data" portion:
ID First name Last name
Raw data
results: [{"first_name": "Super", "last_name": "Man", "id": 1},
{"first_name": "Massimo", "last_name": "Di Pierro", "id": 2}]
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
