You added one extra row of data with this:
b.id_respuesta <= 11
as your previous max used to be 10. The case statement was written to deal
with 8, 9, 10 as options, thus the 11 threw the error. When you removed
the "default" case, it treats the 11's like 10's (which is why your data
has "roadside advertisement" in two rows). You either need to change back
to 10 or add a new case to the switch statement. Either way, you should
put the default case back in as a safety measure.
On Monday, December 10, 2012 12:18:45 AM UTC-5, Chrystopher Medina wrote:
>
> hi again my friend u know i had to remove this line :
>
> default:
> die('{"error":"Error in SQL query: unknown \'id_respuesta\'"}');
>
>
> and now the result is this :
>
> {"cols":[{"label":"Type","type":"string"},{"label":"Count","type":"number"}],"rows":[{"c":[{"v":"word
>
> of mouth recomendation"},{"v":2}]},{"c":[{"v":"magazine
> advertisement"},{"v":1}]},{"c":[{"v":"roadside
> advertisement"},{"v":1}]},{"c":[{"v":"roadside advertisement"},{"v":2}]}]}
>
> i think that is what i need to continue whit the pie chart... or what do
> u think
>
--
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/-/oqaJfBjgh1oJ.
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.
