You're welcome. On Wednesday, December 12, 2012 4:51:13 PM UTC-5, Ian Haylock wrote: > > it worked !!!!!!! cant say thank you enough..... i wish there were more > people like you. > > On Wednesday, December 12, 2012 3:39:22 PM UTC-6, asgallant wrote: >> >> You have a couple of unnecessary lines in your javascript: >> >> alert(typeof(jsonData)); >> console.log(jsonData); >> >> The first is what pops up that message. The second is dumping the >> contents of the json to the developers console - this will cause the script >> to bomb in older versions of IE, as they don't have a console object. >> Delete or comment these two lines and you should be fine. >> >> On Wednesday, December 12, 2012 4:24:30 PM UTC-5, Ian Haylock wrote: >>> >>> >>> <https://lh4.googleusercontent.com/-sbGpcUatdqI/UMj1-PVHiqI/AAAAAAAAALM/1muCotW-3_0/s1600/string.png> >>> json generated: >>> >>> {"cols":[{"label":"planta","type":"string"},{"label":"capacidad en >>> MW","type":"number"}],"rows":[{"c":[{"v":"Francisco >>> Morazan"},{"v":300}]},{"c":[{"v":"Lufussa >>> III"},{"v":267.4}]},{"c":[{"v":"Enersa"},{"v":259}]},{"c":[{"v":"EEHSA - >>> Mesoamerica"},{"v":102}]},{"c":[{"v":"Elcosa"},{"v":80}]},{"c":[{"v":"Lufussa >>> >>> II"},{"v":80}]},{"c":[{"v":"Rio Lindo"},{"v":80}]},{"c":[{"v":"Emce >>> Choloma"},{"v":55}]},{"c":[{"v":"Lufussa I"},{"v":40}]},{"c":[{"v":"Enersa >>> (excedente de 30 >>> MW)"},{"v":30}]},{"c":[{"v":"Nacaome"},{"v":30}]},{"c":[{"v":"Ca\u00f1averal"},{"v":29}]},{"c":[{"v":"La >>> >>> Ceiba"},{"v":26}]},{"c":[{"v":"La Grecia - >>> Celsur"},{"v":25.5}]},{"c":[{"v":"Cahsa - Azucarera >>> Hondure\u00f1a"},{"v":25}]},{"c":[{"v":"El >>> Nispero"},{"v":22.5}]},{"c":[{"v":"Envasa"},{"v":21}]},{"c":[{"v":"Elcatex"},{"v":21}]},{"c":[{"v":"Chumbagua"},{"v":20}]},{"c":[{"v":"Nacional >>> >>> de Ingenieros"},{"v":20}]},{"c":[{"v":"La Puerta MEX - >>> Hitachi"},{"v":18}]},{"c":[{"v":"Celsur"},{"v":18}]},{"c":[{"v":"La Puerta >>> ENEE- General Electric"},{"v":15}]},{"c":[{"v":"CISA - La >>> Esperanza"},{"v":12.7}]},{"c":[{"v":"Cuyamapa"},{"v":12.2}]},{"c":[{"v":"Ampac >>> >>> (American Pacific)"},{"v":10.1}]},{"c":[{"v":"Azunosa ( IHSA >>> )"},{"v":10}]},{"c":[{"v":"Geen Valley - Park >>> Dale"},{"v":10}]},{"c":[{"v":"AYSA"},{"v":8}]},{"c":[{"v":"Cuyamel"},{"v":8}]},{"c":[{"v":"Tres >>> >>> Valles"},{"v":7.8}]},{"c":[{"v":"El >>> Cisne"},{"v":7}]},{"c":[{"v":"Cortecito"},{"v":6}]},{"c":[{"v":"La >>> Gloria"},{"v":5.3}]},{"c":[{"v":"Santa Fe"},{"v":5}]},{"c":[{"v":"Rio >>> Blanco"},{"v":5}]},{"c":[{"v":"Coronado"},{"v":4.5}]},{"c":[{"v":"Babilonia"},{"v":4.3}]},{"c":[{"v":"San >>> >>> Carlos"},{"v":4}]},{"c":[{"v":"Cececapa"},{"v":3.5}]},{"c":[{"v":"El >>> Coyolar"},{"v":1.7}]},{"c":[{"v":"Mangungo >>> I"},{"v":1.5}]},{"c":[{"v":"Santa Maria del >>> Real"},{"v":1.2}]},{"c":[{"v":"Eda"},{"v":1.2}]},{"c":[{"v":"Aceydesa"},{"v":1.1}]},{"c":[{"v":"Yodeco"},{"v":1}]},{"c":[{"v":"Zacapa"},{"v":0.8}]},{"c":[{"v":"Yojoa"},{"v":0.6}]},{"c":[{"v":"Aguan"},{"v":0.5}]},{"c":[{"v":"Lean"},{"v":0.5}]},{"c":[{"v":"La >>> >>> Nieve"},{"v":0.5}]}]} >>> >>> javascript: >>> >>> <html> >>> <head> >>> <meta charset="utf-8"> >>> <script type="text/javascript" src="https://www.google.com/jsapi >>> "></script> >>> <script type="text/javascript" src=" >>> http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js";></script> >>> <script type="text/javascript"> >>> google.load("visualization", "1", {packages:["corechart"]}); >>> google.setOnLoadCallback(drawChart); >>> >>> function drawChart() { >>> var jsonData =$.ajax({ >>> url: "plantas_capacidad_chart_info.php", >>> dataType:"json", >>> async: false >>> }).responseText; >>> >>> alert(typeof(jsonData)); >>> console.log(jsonData); >>> >>> var data = new >>> google.visualization.DataTable(JSON.parse(jsonData)); >>> var options = {'title':'Capacidad Instalada de Plantas', >>> 'width':800, >>> 'height':600, >>> 'hAxis.showTextEvery':2, >>> 'backgroundColor': '', >>> 'bar.groupWidth' : '90%' >>> }; >>> >>> var chart = new >>> google.visualization.ColumnChart(document.getElementById('chart_div')); >>> chart.draw(data,options); >>> } >>> </script> >>> </head> >>> <body> >>> <div id="chart_div" ></div> >>> </body> >>> </html> >>> >>> >>> >>> >>> image ----string: >>> >>> On Wednesday, December 12, 2012 2:30:17 PM UTC-6, asgallant wrote: >>>> >>>> I've never seen any " (string) " message. Can you post a screenshot, >>>> your javascript code, and a sample of the json returned by your query? >>>> >>>> On Wednesday, December 12, 2012 12:55:49 PM UTC-5, Ian Haylock wrote: >>>>> >>>>> query solved !!!!!!!! thank you. >>>>> now my only problem is that before the browsers shows the graphs i >>>>> keep getting the " (string) " message and have to click on it to see the >>>>> graph ... any ideas ??? i have changed the types, added options, etc and >>>>> still nothing >>>>> >>>>> On Wednesday, December 12, 2012 11:38:06 AM UTC-6, asgallant wrote: >>>>>> >>>>>> This isn't causing your problem, but since your "capacidadMW" is a >>>>>> decimal type, and not an integer, you should probably change (int) >>>>>> $r['capacidadMW']); to (float) $r['capacidadMW']); >>>>>> >>>>>> That aside, I don't see anything in your code that would truncate the >>>>>> results. Try running this and see what number is displayed: >>>>>> >>>>>> <?php >>>>>> >>>>>> include('connect-db.php'); >>>>>> >>>>>> $sth = mysql_query("SELECT planta, capacidadMW FROM planta"); >>>>>> echo mysql_num_rows($sth); >>>>>> ?> >>>>>> >>>>>> If that shows 55 records, then there is a problem in the PHP; if it >>>>>> shows less than 55, then there is a problem with your connection to the >>>>>> database. >>>>>> >>>>>> On Wednesday, December 12, 2012 12:17:24 PM UTC-5, Ian Haylock wrote: >>>>>>> >>>>>>> just to let u know, the "planta" record in my table is type >>>>>>> Varchar(45) and the "capacidadMW" is type decimal (9,2) >>>>>>> >>>>>>> On Wednesday, December 12, 2012 11:03:40 AM UTC-6, Ian Haylock wrote: >>>>>>>> >>>>>>>> thanks for the reply .. >>>>>>>> >>>>>>>> the query im using in phpmyadmin showing 55 records: SELECT planta, >>>>>>>> capacidadMW FROM planta; >>>>>>>> >>>>>>>> the code using to encode using JSon (result is only 14 records): >>>>>>>> >>>>>>>> <?php >>>>>>>> >>>>>>>> include('connect-db.php'); >>>>>>>> >>>>>>>> $sth = mysql_query("SELECT planta, capacidadMW FROM planta"); >>>>>>>> $rows = array(); >>>>>>>> $flag = true; >>>>>>>> >>>>>>>> $table = array(); >>>>>>>> $table['cols'] = array( >>>>>>>> >>>>>>>> array('label' => 'planta', 'type' => 'string'), >>>>>>>> array('label' => 'capacidad en MW', 'type' => 'number') >>>>>>>> ); >>>>>>>> >>>>>>>> $rows = array(); >>>>>>>> while($r = mysql_fetch_assoc($sth)) { >>>>>>>> $temp = array(); >>>>>>>> $temp[] = array('v' => (string)$r['planta']); >>>>>>>> $temp[] = array('v' => (int) $r['capacidadMW']); >>>>>>>> $rows[] = array('c' => $temp); >>>>>>>> } >>>>>>>> >>>>>>>> $table['rows'] = $rows; >>>>>>>> >>>>>>>> $jsonTable = json_encode($table); >>>>>>>> >>>>>>>> echo $jsonTable; >>>>>>>> ?> >>>>>>>> >>>>>>>> >>>>>>>> On Wednesday, December 12, 2012 10:55:45 AM UTC-6, asgallant wrote: >>>>>>>>> >>>>>>>>> At a guess, I would say you have an error in the SQL in PHP. If >>>>>>>>> you post your PHP code, I'll take a look at it. >>>>>>>>> >>>>>>>>> On Wednesday, December 12, 2012 11:41:25 AM UTC-5, Ian Haylock >>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>> Hi asgallant, thank you very much for th taking the time to help >>>>>>>>>> others. i have a question if you dont mind, i followed Diana´s >>>>>>>>>> sample and >>>>>>>>>> got it to work, well sort of, i used my onw db and managed to show >>>>>>>>>> the >>>>>>>>>> graph and everithing, the only thing is that my mysql query running >>>>>>>>>> in >>>>>>>>>> phpmyadmin shows 55 records and my json result shows only 14 >>>>>>>>>> records, how >>>>>>>>>> is that possible ??? >>>>>>>>>> >>>>>>>>>> On Wednesday, December 12, 2012 12:54:06 AM UTC-6, Chrystopher >>>>>>>>>> Medina wrote: >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> ok im gonna start with the php information. and u know i have >>>>>>>>>>> another problem how i cant charge two pie charts in the same place >>>>>>>>>>> but each >>>>>>>>>>> with different results.... u know i have two questions and i want >>>>>>>>>>> to charge >>>>>>>>>>> the results from them. in two pie charts..... because i read that >>>>>>>>>>> just one >>>>>>>>>>> pie chart can be charged in the same place.... i could be mistaken >>>>>>>>>> >>>>>>>>>>
-- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To view this discussion on the web visit https://groups.google.com/d/msg/google-visualization-api/-/7RKr8_m0kzoJ. 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.
