/[SQLSession]/trunk/share/web/templates/sql
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/share/web/templates/sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

trunk/share/web/templates/sql.html revision 14 by dpavlin, Sun Dec 3 13:45:00 2006 UTC trunk/share/web/templates/sql revision 78 by dpavlin, Mon Jan 29 20:11:20 2007 UTC
# Line 1  Line 1 
1  <%args>  <%args>
 $page => 1  
2  $sth => undef  $sth => undef
3    $q => undef
4    $max_rows => 100
5  </%args>  </%args>
 <%init>  
   
 my $action = Jifty->web->new_action(  
         class => 'DoSQL',  
         moniker => 'execute_sql',  
 );  
   
 my $result = Jifty->web->response->result('execute_sql');  
 $sth = $result->content('sth') if $result and !defined $sth;  
   
 </%init>  
6    
7  <&| /_elements/wrapper, title => "Try out SQL query" &>  <&| /_elements/wrapper, title => "Try out SQL query" &>
 <% Jifty->web->form->start() %>  
 <% $action->form_field('sql_query') %>  
 <% $action->form_field('database') %>  
 <% Jifty->web->form->submit( label => 'Try it!' ) %>  
   
 % if ( defined($sth) ) {  
   
 <hr/>  
   
 <table cellpadding="3" cellspacing="0" border="1">  
   
 <tr>  
 % foreach my $col ( @{ $sth->{'NAME'} } ) {  
 <th><% $col %></th>  
 % }  
 </tr>  
   
 % while ( my @row = $sth->fetchrow_array() ) {  
 <tr>  
 %       foreach my $v ( @row ) {  
 <td><% defined($v) ? $v : 'NULL' %></td>  
 %       }  
 </tr>  
 % }  
   
 </table>  
   
 <hr/>  
   
 <%perl>  
 my $save = Jifty->web->new_action(  
         class => 'CreatePage',  
         arguments => {  
                 sql_query => $action->form_field('sql_query'),  
                 on_database => $action->form_field('database'),  
         }  
 );  
   
 </%perl>  
8    
9  <% $save->form_field('name') %>  <% Jifty->web->region(
10  <% $save->button( label => 'Save' ) %>          name => 'query',
11            path => '/fragments/enter_query',
12    ) %>
13    
14    <% Jifty->web->region(
15            name => 'results',
16            path => '/fragments/results',
17    ) %>
18    
19  % }  <% Jifty->web->return( label => "Go back" ) %>
20    
 <% Jifty->web->form->end() %>  
21  </&>  </&>
22    
Legend:
Removed from v.14  
changed lines
  Added in v.78
  ViewVC Help
Powered by ViewVC 1.1.26