I have 3 columns of data being returned from a mysql data source via setQuery.
The first column is what I use as the label for the datatable and columnchart. Example of a first column returned is home_town. I want to format home_town my chart labels to be "Home town" First I use the setQuery to replace the underscore like SELECT REPLACE (attribute_value,"_"," ") which brings me back "home town". But then I want my label to be "Home town" where the first word is capitalized. Where do I do this formatting/transformation? Format via the set query doesn't seem to have a uppercase function. I don't think patternformatter is what I want either. Any suggestions? Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
