|Can you help with a difficulty when using Count in Mysql.
I have a simple recordset which returns a count of individuals who have completed some training. If they are not trained the field 'Indep' is set to Probationer, if they are trained, it is set to Independent.
My query (mysql) generating the chart data is :
Select Indep, count(Indep) from
Group by Indep
When tested this produces the correct data - a label and a count of the people meeting that criteria.
However, when I run the chart I get the following error:
DwZone.it Dynamic Chart error:
The recordset contains a non numeric value
Verify the data in your recordset, all the value fields must be numeric
I have tried setting an alias for the count value - the same error is produced
I have tried casting the resulting alias as a signed integer - the same error is produced
Can you help?