<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><br>Randy:<br><br>It seems you want a sortable HTML table that talks to a back end<br>query engine. I don't see why this needs to be specific to SQLAlchemy.<br><br>Here is a WHIFF middleware which does some of what you are talking<br>about (the demo formatting is basic/ugly for simplicity purposes).<br><br>Demo<br><br> http://whiffdoc.appspot.com/tests/misc/testSortTable<br><br>Demo source<br><br> http://whiffdoc.appspot.com/tests/showText?path=./misc/testSortTable<br><br>The documentation <br><br> http://whiffdoc.appspot.com/docs/W1200_1400.stdMiddleware#Header83<br><br>is not extensive, but here is the source for the<br>core middleware widget.<br><br> http://aaron.oirt.rutgers.edu/cgi-bin/whiffRepo.cgi/file/8c031c68a5a0/whiff/middleware/sortTable.py<br><br>As written it requires the whole table as a list of dictionaries and
then does<br>paging from the full list. It certainly needs generalization but maybe it's<br>a start. Let me know if you have questions or comments.<br><br> -- Aaron Watters<br><br>--- On <b>Wed, 4/7/10, Randy Syring <i><rsyring@inteli-com.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Randy Syring <rsyring@inteli-com.com><br>Subject: Re: [Web-SIG] SQLAlchemy Queries & HTML Data Grid<br>To: "Aaron Watters" <arw1961@yahoo.com><br>Cc: web-sig@python.org<br>Date: Wednesday, April 7, 2010, 1:37 PM<br><br><div id="yiv1314051328">
Aaron,<br>
<br>
Sorry, I must not really have explained clearly. This isn't an
abstraction layer, but more like a UI component or widgit that
facilities basic reporting. Look at these pages:<br>
<br>
<a rel="nofollow" class="moz-txt-link-freetext" target="_blank" href="http://www.redmine.org/issues">http://www.redmine.org/issues</a><br>
<a rel="nofollow" class="moz-txt-link-freetext" target="_blank" href="http://trac.edgewall.org/query">http://trac.edgewall.org/query</a>]<blockquote type="cite"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font: inherit;" valign="top">....<br></td>
</tr>
</tbody>
</table>
</blockquote>
</div></blockquote></td></tr></table>