Is this piece literally how it appears in Chrome?
data.setValue(0, 5, ' ');
If so, your output from "eta" is broken somehow. Try doing a debug dump of
$row['eta'] to see what is actually contained there.
On Monday, December 3, 2012 4:55:37 PM UTC-5, Tony Kehlhofer wrote:
>
> I have a page that displays 5 columns of data. When I add a 6th column an
> error. I have tried several fixed based on the thought that my data was bad
> (addslashes, etc)
>
> Here is the code that works:
>
> var data = new google.visualization.DataTable();
> data.addRows(<?php echo $howmany;?>);
> data.addColumn('string', 'Group', 'Group');
> data.addColumn('string', 'SKU', 'SKU');
> data.addColumn('string', 'Description', 'Description');
> data.addColumn('string', 'UOM', 'UOM');
> data.addColumn('number', 'Quantity', 'Quantity');
>
> <?php
> if ($howmany > 0)
> {
> $counter = 0;
> while($row = mysql_fetch_array($resultDlr))
> {
> echo 'data.setValue(' . $counter . ', 0, \'' .
> $row['prodgroup'] . '\');';
> echo 'data.setValue(' . $counter . ', 1, \'' .
> $row['sku'] . '\');';
> echo 'data.setValue(' . $counter . ', 2, \'' .
> addslashes($row['description']) . '\');';
> echo 'data.setValue(' . $counter . ', 3, \'' .
> $row['uom'] . '\');';
> echo 'data.setValue(' . $counter . ', 4, ' .
> $row['qty'] . ');';
> $counter = $counter + 1;
> }
> }
> ?>
>
> var table2 = new
> google.visualization.Table(document.getElementById('chart_divT'));
>
> var formatter = new google.visualization.NumberFormat(
> {});
> formatter.format(data, 4);
>
> table2.draw(data, {showRowNumber: false, width: '800px',
> page: 'enable', pageSize: 20, 'allowHtml': true, 'cssClassNames':
> cssClassNames});
>
>
> when I add one column, the code is this, and it breaks:
>
> var data = new google.visualization.DataTable();
> data.addRows(<?php echo $howmany;?>);
> data.addColumn('string', 'Group', 'Group');
> data.addColumn('string', 'SKU', 'SKU');
> data.addColumn('string', 'Description', 'Description');
> data.addColumn('string', 'UOM', 'UOM');
> data.addColumn('number', 'Quantity', 'Quantity');
> *data.addColumn('string', 'ETA', 'ETA');*
>
> <?php
> if ($howmany > 0)
> {
> $counter = 0;
> while($row = mysql_fetch_array($resultDlr))
> {
> echo 'data.setValue(' . $counter . ', 0, \'' .
> $row['prodgroup'] . '\');';
> echo 'data.setValue(' . $counter . ', 1, \'' .
> $row['sku'] . '\');';
> echo 'data.setValue(' . $counter . ', 2, \'' .
> addslashes($row['description']) . '\');';
> echo 'data.setValue(' . $counter . ', 3, \'' .
> $row['uom'] . '\');';
> echo 'data.setValue(' . $counter . ', 4, ' .
> $row['qty'] . ');';
> * echo 'data.setValue(' . $counter . ', 5, \'' .
> $row['eta'] . '\');';*
> $counter = $counter + 1;
> }
> }
> ?>
>
> var table2 = new
> google.visualization.Table(document.getElementById('chart_divT'));
>
> var formatter = new google.visualization.NumberFormat(
> {});
> formatter.format(data, 4);
>
> table2.draw(data, {showRowNumber: false, width: '800px',
> page: 'enable', pageSize: 20, 'allowHtml': true, 'cssClassNames':
> cssClassNames});
>
>
> The only possible values from the db for field ETA are stored as strings:
>
> NA
> Jan 12, 2013
> Dec 18, 2012
> Dec 13, 2012
> Dec 22, 2012
> Dec 01, 2012
> Dec 12, 2012
>
> The error I get is: Uncaught SyntaxError: Unexpected token ILLEGAL
>
> and in Chrome, the source looks like this, showing that the first single
> quote around the first ETA is black and not red, which seems to be messing
> up the syntax of what I am writing out.
>
>
> data.setValue(0, 0, 'CTOP');data.setValue(0, 1, 'PFBC-3096');data.setValue
> (0, 2, 'Prefinished Butcher Block');data.setValue(0, 3, 'PIECE');data.
> setValue(0, 4, 17.00);data.setValue(0, 5, ' ');
>
> Please help !!
>
> Tony
>
--
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/-/_3v1lw888-AJ.
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.
