DwZone Forum DwZone Forum
Welcome to the DwZone-it Forum
 
  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups  
    RegisterRegister -->   LoginLogin  
Dynamic Chart  
DwZone Forum Index -> Dynamic Chart

Moderators: AdministratorsModerators 
Hint: For improved responsiveness, use Internet Explorer 4 (or above) with Javascript enabled, choose 'Dynamic' from the View dropdown and hit 'Set Options' to save your changes.
New Topic Search for
 View     Per page     Messages Since 
Messages 1 to 10 of 74 (Total: 31) First |  Prev |  Next |  Last  
 Subject Author Date  
   Cannot get the image file from Temp folder  
View this persons public profile  Alfredo Guerra   15:14 19 Oct 2012  
   Re: Cannot get the image file from Temp folder  
View this persons public profile  Gianluigi   15:24 19 Oct 2012  
   Re: Cannot get the image file from Temp folder  
View this persons public profile  Alfredo Guerra   15:27 19 Oct 2012  
   Re: Cannot get the image file from Temp folder  
View this persons public profile  Gianluigi   0:48 20 Oct 2012  
    Dynamic chart and Count function  
View this persons public profile  RichardBellamy   2:55 27 Aug 2012  
 
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
database.table
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:

Warning!!
DwZone.it Dynamic Chart error:
The recordset contains a non numeric value
Field: indep
Value: 3
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?
 
Reply to this current thread  View this persons public profile  Send Private Message
   Re: Dynamic chart and Count function  
View this persons public profile  Gianluigi   8:30 27 Aug 2012  
   New Version  
View this persons public profile  Alfredo   20:46 19 Jun 2011  
   Re: New Version  
View this persons public profile  Gianluigi   10:37 20 Jun 2011  
   Re: New Version  
View this persons public profile  Alfredo   8:03 23 Jun 2011  
   Re: New Version  
View this persons public profile  Gianluigi   9:37 23 Jun 2011  
Last Visit: Thursday 16 Sep, 2021 0:20 pm First |  Prev |  Next |  Last  
 Login
Username:  Password:    
Read Message Read Message   Unread message Unread message
Read message [popular] Read message [popular]   Unread message [popular] Unread message [popular]
Read message [locked] Read message [locked]   Unread message [locked] Unread message [locked]
All times are GMT-2

Jump to: