Hey sorry for not providing specification. The code was mine at server side. I problem was not related to visualization ... it was problem with xml specification in servlet ..... netbeans 6.9 seemed to have decreased the reflection mechanism by including too many features
On Tue, Jul 6, 2010 at 5:51 PM, ChartMan <[email protected]> wrote: > "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]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > -- regards, Akshay -- 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.
