How can i do this and retrieve alot of rows
On Wednesday, February 29, 2012 2:12:40 AM UTC+2, Mohammad Asif Jamaluddin
wrote:
>
> I am trying to pass a query to a spreadsheet. I have a value say "John
> cena". How do I pass it in the following line. I am getting an error while
> doing so.
>
> ListQuery query = new ListQuery(listFeedUrl);
> query.setSpreadsheetQuery("name = 'John cena' and age > 25");
> ListFeed feed = service.query(query, ListFeed.class);
>
> Error is
>
> com.google.gdata.util.InvalidEntryException: Bad Request
> Parse error: Invalid token encountered
>
> at
> com.google.gdata.client.http.HttpGDataRequest.handleErrorResponse(HttpGDataRequest.java:594)
> at
> com.google.gdata.client.http.GoogleGDataRequest.handleErrorResponse(GoogleGDataRequest.java:563)
> at
> com.google.gdata.client.http.HttpGDataRequest.checkResponse(HttpGDataRequest.java:552)
> at
> com.google.gdata.client.http.HttpGDataRequest.execute(HttpGDataRequest.java:530)
> at
> com.google.gdata.client.http.GoogleGDataRequest.execute(GoogleGDataRequest.java:535)
> at com.google.gdata.client.Service.getFeed(Service.java:1135)
> at com.google.gdata.client.Service.getFeed(Service.java:1077)
> at com.google.gdata.client.GoogleService.getFeed(GoogleService.java:662)
> at com.google.gdata.client.Service.query(Service.java:1237)
> at com.google.gdata.client.Service.query(Service.java:1178)
>
> pls help
>
>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
