--- trunk/share/web/templates/fragments/queries	2007/02/16 22:20:41	99
+++ trunk/share/web/templates/fragments/queries	2007/02/16 22:21:07	100
@@ -1,7 +1,8 @@
 <%args>
 $on_database => undef
-$created_on => undef;
+$created_on => undef
 $order
+$reformat => 0
 </%args>
 <%init>
 my $queries = SQLSession::Model::QueryCollection->new();
@@ -93,6 +94,12 @@
 	$dates++;	# why is this different from $date_coll->count ?
 }
 
+my $u;
+if ($reformat) {
+	use SQLSession::Utils qw(reformat_sql);
+	$u = Jifty->app_class('Utils');
+}
+
 </%init>
 
 <div class="sort">
@@ -132,7 +139,9 @@
 % if ($q->note) {
 	<div class="sql-note"><% $q->note %></div>
 % }
-	<pre class="sql"><% $q->sql_query %></pre>
+% my $sql = $q->sql_query;
+% $sql = $u->reformat_sql( $sql ) if ($reformat);
+	<pre class="sql"><% $sql %></pre>
 	</dd>
 % }
 </dl>