"Failed to execute SQL query. mySQL error" can you point me to the server code that outputs this error, is it your code?
ChartMan On Tue, Jul 6, 2010 at 5:52 PM, Student <[email protected]> wrote: > 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]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- 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.
