try:
chartQuery.setQuery("select * where `id` = '77'");
(back ticks)
HTH,
BugChart
On Sat, Mar 13, 2010 at 18:12, chalu <chal...@gmail.com> wrote:
> thanks HTH, I tried it but it still did not work, here is what I
> tried :
> without the query "filter" (i.e give me id 77) it works and this is
> what I get from firebug, showing that the node with an id of 77 is
> actually there :
> chartQuery = Query.create("http://localhost:8080/sungold/
> chartservice");
> // firebug response
> {
> version:'0.6',
> reqId:'1',
> status:'ok',
> sig:'928384254',
> table:{
> cols:[{
> id:'id',
> label:'',
> type:'string',
> pattern:''
> },{
> id:'upline',
> label:'',
> type:'string',
> pattern:''
> },{
> id:'tip',
> label:'',
> type:'string',
> pattern:''
> }],
> rows:[
> {c:[
> {v:'77',f:'Mrs. Blessing Anyi'},{v:''},
> {v:'Mrs. Blessing Anyi \u003cbr /\u003e UG-PL-722131395-slot-1
> \u003cbr /\u003e PL-Part1 Level 3'}
> ]},
> {c:[
> {v:'78',f:'Mrs. Blessing Anyi'},{v:'77'},
> {v:'Mrs. Blessing Anyi \u003cbr /\u003e UG-PL-722131395-slot-2
> \u003cbr /\u003e PL-Part1 Level 3'}
> ]},
> {c:[
> {v:'79',f:'Mrs. Blessing Anyi'},{v:'77'},
> {v:'Mrs. Blessing Anyi \u003cbr /\u003e UG-PL-722131395-slot-3
> \u003cbr /\u003e PL-Part1 Level 3'}
> ]},
> {c:[
> {v:'80',f:'Mrs. Blessing Anyi'},{v:'77'},
> {v:'Mrs. Blessing Anyi \u003cbr /\u003e UG-PL-722131395-slot-4
> \u003cbr /\u003e PL-Part1 Level 3'}
> ]}
> ]
> }
> }
>
> but adding the query "filter" I get empty rows, and the chart is not
> drawn
> chartQuery = Query.create("http://localhost:8080/sungold/
> chartservice");
> chartQuery.setQuery("select * where 'id' = '77'");
>
> On Mar 11, 5:16 pm, Bug Chart <bugch...@google.com> wrote:
> > Hi,
> >
> > try to quote (") your data:
> > select * where `Col1` > "0"
> >
> > HTH,
> >
> > BugChart.
>
> --
> You received this message because you are subscribed to the Google Groups
> "Google Visualization API" group.
> To post to this group, send email to
> google-visualization-...@googlegroups.com.
> To unsubscribe from this group, send email to
> google-visualization-api+unsubscr...@googlegroups.com<google-visualization-api%2bunsubscr...@googlegroups.com>
> .
> For more options, visit this group at
> http://groups.google.com/group/google-visualization-api?hl=en.
>
>
--
Nimrod Talmon
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to google-visualization-...@googlegroups.com.
To unsubscribe from this group, send email to
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.
