rzajac
rzajac

Reputation: 1601

Zend Gdata StructuredQuery for empty cells

How do I do structured query for empty cell.

I tried like this:

$query = new Zend_Gdata_Spreadsheets_ListQuery();
$query->setSpreadsheetKey($spreadsheetKey);
$query->setWorksheetId($worksheetId);
$query->setSpreadsheetQuery('name="" and lastname=John');
$listFeed = $spreadsheetService->getListFeed($query);

But every time i do this i get: Parse error: Invalid token encountered

I have tried with single quotes, double quotes... nothing seems to work.

Upvotes: 0

Views: 76

Answers (1)

rzajac
rzajac

Reputation: 1601

The problem was in Zend_Uri_Http class in method getQueryArray

public function getQueryAsArray()
{
    $query = $this->getQuery();

    $queryArray = array();
    if ($query !== false) {
        parse_str($query, $queryArray);
    }

    return $queryArray;
}

PHP was set with magic_quotes_gpc = On which caused structured query to be escaped in a wrog way.

Upvotes: 0

Related Questions