--- trunk/share/web/templates/list	2006/12/03 19:55:52	22
+++ trunk/share/web/templates/list	2006/12/07 23:22:41	31
@@ -1,6 +1,7 @@
 <%init>
 my $queries = SQLSession::Model::QueryCollection->new();
-$queries->unlimit();
+$queries->limit( column => 'visible', value => 1 );
+$queries->order_by( column => 'name', order => 'asc' );
 
 </%init>
 
@@ -12,10 +13,11 @@
 		label => $q->name,
 	) %></dt>
 	<dd>
-	on <% $q->on_database->name %> <tt>[<% $q->on_database->dsn %>]</tt>
-	<pre>
-	<% $q->sql_query %>
-	</pre>
+% if ($q->note) {
+	<div class="sql-note"><% $q->note %></div>
+% }
+	<pre class="sql"><% $q->sql_query %></pre>
+	<div class="database-name">on <% $q->on_database->name %> <tt>[<% $q->on_database->dsn %>]</tt></div>
 	</dd>
 % }
 </dl>