i have the following json string generated
google.visualization.Query.setResponse({version:'0.6',status:'ok',sig:'1234115729',table:
{cols:[{id:'Dno',label:'Dno',type:'datetime',pattern:''},
{id:'st_series',label:'st_series',type:'number',pattern:''},
{id:'st_seriestitle',label:'st_seriestitle',type:'string',pattern:''},
{id:'st_seriestext',label:'st_seriestext',type:'string',pattern:''},
{id:'st_unit',label:'st_unit',type:'number',pattern:''},
{id:'st_unittitle',label:'st_unittitle',type:'string',pattern:''},
{id:'st_unittext',label:'st_unittext',type:'string',pattern:''},
{id:'socket',label:'socket',type:'number',pattern:''},
{id:'sockettitle',label:'sockettitle',type:'string',pattern:''},
{id:'sockettext',label:'sockettext',type:'string',pattern:''}],rows:
[{c:[{v:new Date(2010,5,2,4,0,6)},{v:4.0},,,{v:1.0},,,{v:1.0},,
{v:null}]},{c:[{v:new Date(2010,5,2,4,0,5)},{v:4.0},,,{v:1.0},,,{v:
2.0},,{v:null}]},{c:[{v:new Date(2010,5,2,5,6,31)},{v:4.0},,,{v:1.0},,,
{v:1.0},,{v:null}]},...................
I f we see we have a column name Dno
but when i add following string to the above servlet
myservlet?tq=select Dno
i get the following error
google.visualization.Query.setResponse({version:'0.6',status:'error',errors:
[{reason:'internal_error',message:'Internal
error',detailed_message:'Failed to execute SQL query. mySQL error
message: Unknown column \u0027Dno\u0027 in \u0027field list\u0027'}]})
I can even draw the chart based on the datasource but when I try to
query on top of the data source i get error.....
Any idea why is this happening?
--
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.
