--- sql-editor.js 2009/04/15 15:35:15 14 +++ sql-editor.js 2009/04/15 18:42:41 15 @@ -74,15 +74,38 @@ $('input[name=add_group_by]').bind('click', function(e) { var l = $('div#lookup'); - l.html('...loading...').css('display','block'); var column = $('form#sql input[name=add_group_by]').attr('value'); - console.debug( this, e, column, l ); + var col_nr = $('form#sql select[name=where_column]').attr('options').selectedIndex; + + l.html('...loading '+column+'...').css('display','block'); + + console.debug( this, e, column, col_nr, l ); $('input[name=add_group_by]') .removeClass('changed') .attr('disabled', 1); - l.load('?add_group_by='+column).addClass('changed'); + $.get('', { add_group_by: column }, function(data,textStatus) { + console.debug( data, textStatus ); + l.addClass('changed'); + l.html( data ); + + $('div#lookup a') + .bind('click', function(e) { + console.debug( e ); + $('form#sql input[name=where_value]') + .addClass('changed') + .attr('value', e.target.text ) + ; + $('form#sql select[name=where_column]') + .addClass('changed') + .attr('options').selectedIndex = col_nr + ; + return false; + }); + }); + + $('input[name=close_group_by]') .addClass('changed') .attr('disabled', 0)