Hi, I tried to change code of DeletedDocuments to display my own data from
external mysql db. When I write my own code table does not show data. JSON
results are valid, I tested them on http://www.jsonlint.com/. Number of
total rows are displayed correctly, but there are no data. I tried many
options but still nothing. Could you help me what should be done next?
Code:
{{velocity}}
#if(!$request.list)
#set($collist = ["mistnost", "osoba"])
#set($colprops = {
"mistnost" : { "type" : "text" , "size" : 10 },
"osoba" : { "type" : "text" , "size" : 10 }
})
#set($options = {
"url":"http://localhost:8080/xwiki/bin/Sandbox/Test1?list=1&xpage=plain&outputSyntax=plain"})
#livetable('mistnosti' $collist $colprops $options)
#else ## request.list
#includeMacros("Sprava.Macros")
#connectDbTEP($dbc)
#if("$!{request.get('xpage')}" == 'plain')
## json starts
{
"totalrows": 13,
"returnedrows": 10,
"offset": 0,
"rows": [
#foreach($row in $dbc.executeQuery("select id_room, mistnost, prijmeni,
jmeno from room, osoby where room.id_os = osoby.id_os"))
#set($mistnost = $row.getString("mistnost"))
#set($prijmeni = $row.getString("prijmeni"))
#set($jmeno = $row.getString("jmeno"))
#if($velocityCount > 1) , #end
{
"mistnost" : "$mistnost",
"osoba" : "$prijmeni $jmeno"
}
#end
]}
#end## xpage=plain
#end## request.list
{{/velocity}}
Thank you
--
View this message in context:
http://xwiki.475771.n2.nabble.com/Pagination-macro-with-sortable-table-tp5787879p5932246.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
