function queryGSheet(){
var memid=document.forms[0].MemberID.value.trim();
var fname=document.forms[0].FirstName.value.trim();
var lname=document.forms[0].LastName.value.trim();

if ( ( memid == null || memid == "" ) && ( fname == null || fname == "" ) && ( lname == null || lname == "") ) {
   alert("At least one of the fields need to be entered to query data");
   return false;
}

var query = new google.visualization.Query('http://spreadsheets.google.com/tq?key='+gsheetkey+'&headers=1');

query.setQuery('SELECT A, B, C, D where upper(A) like upper("%'+memid+'%") AND upper(C) like upper("%'+fname+'%") AND upper(D) like upper("%'+lname+'%")');
query.send(handleQueryResponse);
return;

function handleQueryResponse(response) {
if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
    return;
}
    var data = response.getDataTable();
    var options = {'showRowNumber': false, 'allowHtml': true};
    table = new google.visualization.Table(document.getElementById('table'));
    table.draw(data,  {showRowNumber: false, allowHtml: true});