Get Action Paged Query
"/OpenForum/JarManager/JDBC/PagedQuery","Select="+select+"&From="+from+"&PageSize="+pageSize+"&db="+db
Server Side Javascript for GET method
select = transaction.getParameter("Select");
from = transaction.getParameter("From");
pageSize = transaction.getParameter("PageSize");
pageNumber = transaction.getParameter("PageNumber");
if(select==null)
{
transaction.setResult(transaction.SHOW_PAGE);
}
else
{
dbName = transaction.getParameter("db");
db = js.getApi("/OpenForum/JarManager/JDBC");
if(pageNumber==null)
{
pageNumber = 0;
}
try{
result = db.doPagedQuery(dbName,select,from,pageSize,pageNumber);
}
catch(e)
{
transaction.sendPage(e);
}
data = "";
columns = Number(result.getAttributeValueByName("columns"));
xColumns = result.getElementByName("columns");
for(column=0;column0)
{
page += "<<";
}
if(pageNumber>>";
}
transaction.sendPage(page);
}