--- index.cgi	2009/04/14 19:54:56	10
+++ index.cgi	2009/04/18 12:08:07	17
@@ -11,10 +11,11 @@
 
 our $dsn    = 'DBI:Pg:dbname=syslog';
 our $user   = 'dpavlin';
+our $table  = 'log';
 
 require 'config.pl' if -e 'config.pl';
 
-my $table = param('table') || 'log';
+$table  = param('table') || $table;
 my @columns = param('columns');
 @columns = ('*') unless @columns;
 my $limit = param('limit') || 1000;
@@ -37,7 +38,7 @@
 	while ( my @row = $sth->fetchrow_array ) {
 		my ( $n, $c ) = @row;
 		$n = 'NULL' unless defined $n;
-		print qq|<tr><td>$c</td><td>$n</td></tr>|;
+		print qq|<tr><td>$c</td><td><a href="#">$n</a></td></tr>|;
 	}
 	print qq|</table>|;
 	exit;
@@ -52,13 +53,6 @@
 <!-- http://jqueryjs.googlecode.com/files/jquery-1.3.2.min.js -->
 <script type="text/javascript" src="jquery-1.3.2.min.js"></script>
 
-<!-- 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>
-
 <script type="text/javascript" src="sql-editor.js"></script>
 
 </head>
@@ -113,6 +107,13 @@
 
 print $sth->rows, qq| rows in $t s</code>|;
 
+#my @types = map { scalar $dbh->type_info($_)->{TYPE_NAME} } @{ $sth->{TYPE} };
+my $types = dump( $sth->{TYPE} );
+print qq{
+<script type="text/javascript">
+var column_type = $types ;
+</script>
+};
 
 @columns = @{ $sth->{NAME} } if $#columns == 0 && $columns[0] eq '*';
 
@@ -140,7 +141,7 @@
 	qq|</table>|
 	, start_form( -id => 'sql' )
 
-	, 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>|
 
 	, qq|<label for=columns>select</label>|
 	, checkbox_group( -name => 'columns', -values => [ @columns ], -defaults => [ @columns ] )
@@ -157,7 +158,7 @@
 		<span>
 		<input type=button name=add_group_by>
 		<input type=button name=close_group_by value="[x]" disabled=1>
-		<div id="lookup">...loading...</div>
+		<div id="lookup"></div>
 		<span>
 	|