--- trunk/share/web/templates/list 2007/01/18 17:02:24 38 +++ trunk/share/web/templates/list 2007/01/18 17:53:58 39 @@ -1,3 +1,6 @@ +<%args> +$database_id => undef + <%init> my $queries = SQLSession::Model::QueryCollection->new(); @@ -7,8 +10,11 @@ } else { $queries->limit( column => 'visible', value => 1 ); } +$queries->limit( column => 'on_database', value => $database_id ) if ( $database_id ); $queries->order_by( column => 'name', order => 'asc' ); +warn $queries->build_select_query; + <&| /_elements/wrapper, title => "Available queries" &> @@ -21,7 +27,7 @@ on <% $q->on_database->name %> % if ( $edit ) { - [<% $q->on_database->dsn %>] + [<% $q->on_database->id . ': ' . $q->on_database->dsn %>] % }