--- trunk/share/web/templates/sql	2006/12/07 19:51:05	27
+++ trunk/share/web/templates/sql	2006/12/07 22:13:56	29
@@ -18,24 +18,34 @@
 my $result = Jifty->web->response->result('execute_sql');
 $sth = $result->content('sth') if $result and !defined $sth;
 
+my $edit = Jifty->config->app('edit');
+warn $edit ? 'edit mode for SQL' : 'student mode';
+
 </%init>
 
 <&| /_elements/wrapper, title => "Try out SQL query" &>
 <% Jifty->web->form->start() %>
 <% $execute_sql->form_field('sql_query',
 	default_value => $sql_query,
-#	cols => 80,
-#	rows => 5,
-) %>
-<% $execute_sql->form_field('database',
-	default_value => $database,
+	cols => 80,
+	rows => 5,
 ) %>
+% if ( $edit ) {
+<% $execute_sql->form_field('database', default_value => $database ) %>
+% } else {
+
+<!-- hidden database -->
+<% $execute_sql->hidden('database', $database ) %>
+
+% }
 <div class="submit_button">
 <% $execute_sql->button( label => 'Try it!' ) %>
 
 
 % if ( defined($sth) ) {
 
+% if ( $edit ) {
+
 % warn "save SQL: ", $execute_sql->argument_value('sql_query');
 
 <% Jifty->web->link(
@@ -53,14 +63,19 @@
 	as_button => 1,
 ) %>
 
-</div>
-<% Jifty->web->form->end() %>
+</div><!-- submit_button edit -->
 
 <% Jifty->web->region(
 	name => 'save_query',
 ) %>
 
-</div>
+% } else {
+
+</div><!-- submit_button no edit -->
+
+% }
+
+<% Jifty->web->form->end() %>
 
 <table cellpadding="3" cellspacing="0" border="1">
 
@@ -91,7 +106,7 @@
 
 % } else {
 
-</div><!-- submit_button -->
+</div><!-- submit_button no query -->
 <% Jifty->web->form->end() %>
 
 % }