Hi!
I have a spreadsheet on Google Document
I want to do some query with this spreadsheet
With a form, I ask to a user the name of a person
var name = form.name.value;
For the search, I have the following query
var query = new google.visualization.Query('http://
spreadsheets.google.com/ccc?key=...');
query.setQuery('select B,C,N,Q,R,J,K,L where C = "' + name + '"');
The problem is that my query is case-sensitive.
If the user keys "toto" and in the spreadsheet there are "Toto" or
"TOTO",
the query return nothing
I would like that my query doesn't respect the case.
I mustn't change the spreadsheet
I have tried with "lower" but it doesn't work.
var name = form.name.value.toLowerCase();
query.setQuery('select B,C,N,Q,R,J,K,L where lower(C) = "' + name +
'"');
Thanks by advance,
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en
-~----------~----~----~----~------~----~------~--~---
