52 |
<!-- http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js --> |
<!-- http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js --> |
53 |
<script type="text/javascript" src="jquery-1.3.2.min.js"></script> |
<script type="text/javascript" src="jquery-1.3.2.min.js"></script> |
54 |
|
|
|
<!-- insert firebug lite because we use console.* all over --> |
|
|
<!-- http://getfirebug.com/releases/lite/1.2/firebug-lite-compressed.js --> |
|
|
<script type="text/javascript" src="firebug-lite-compressed.js"></script> |
|
|
<script type="text/javascript"> |
|
|
firebug.env.height = 100; |
|
|
</script> |
|
|
|
|
55 |
<script type="text/javascript" src="sql-editor.js"></script> |
<script type="text/javascript" src="sql-editor.js"></script> |
56 |
|
|
57 |
</head> |
</head> |
106 |
|
|
107 |
print $sth->rows, qq| rows in $t s</code>|; |
print $sth->rows, qq| rows in $t s</code>|; |
108 |
|
|
109 |
|
#my @types = map { scalar $dbh->type_info($_)->{TYPE_NAME} } @{ $sth->{TYPE} }; |
110 |
|
my $types = dump( $sth->{TYPE} ); |
111 |
|
print qq{ |
112 |
|
<script type="text/javascript"> |
113 |
|
var column_type = $types ; |
114 |
|
</script> |
115 |
|
}; |
116 |
|
|
117 |
@columns = @{ $sth->{NAME} } if $#columns == 0 && $columns[0] eq '*'; |
@columns = @{ $sth->{NAME} } if $#columns == 0 && $columns[0] eq '*'; |
118 |
|
|
140 |
qq|</table>| |
qq|</table>| |
141 |
, start_form( -id => 'sql' ) |
, start_form( -id => 'sql' ) |
142 |
|
|
143 |
, qq|<a href="#" onclick="\$('form#sql').toggleClass('visible'); return false;" class=close>close</a>| |
, qq|<a href="#" onclick="\$('form#sql').toggleClass('visible'); return false;" class=close title="hide sql editor">[x]</a>| |
144 |
|
|
145 |
, qq|<label for=columns>select</label>| |
, qq|<label for=columns>select</label>| |
146 |
, checkbox_group( -name => 'columns', -values => [ @columns ], -defaults => [ @columns ] ) |
, checkbox_group( -name => 'columns', -values => [ @columns ], -defaults => [ @columns ] ) |
157 |
<span> |
<span> |
158 |
<input type=button name=add_group_by> |
<input type=button name=add_group_by> |
159 |
<input type=button name=close_group_by value="[x]" disabled=1> |
<input type=button name=close_group_by value="[x]" disabled=1> |
160 |
<div id="lookup">...loading...</div> |
<div id="lookup"></div> |
161 |
<span> |
<span> |
162 |
| |
| |
163 |
|
|