SQL Query OK, but get empty output.

TOPIC: SQL Query OK, but get empty output.

SQL Query OK, but get empty output. 12 years, 11 months ago #40918

fsebbah
OFFLINE
Posts: 6

Hi,
My configuration
Joomla 2.5.14
Fusion Chart 1.1.9
I have a query :
SELECT
'- 25 ans',
left(cb_sexe,1),count(left(cb_sexe,1))
FROM jos_comprofiler jcm
where left(cb_sexe,1)<>""
and (YEAR(CURRENT_DATE)-YEAR(cb_datedenaissance)) - (RIGHT(CURRENT_DATE,5)<RIGHT(cb_datedenaissance,5))<=25
group by left(cb_sexe,1)
When I launch in Fusionchart, I have this message : "SQL Query OK, but get empty output."
If i launch since phpmyadmin, the results are correct
If you need an account on my server, it's possible.
Thanks for your help.
Franck

The topic has been locked.

Re: SQL Query OK, but get empty output. 12 years, 11 months ago #40929

jitr OFFLINE ARTIO Support Posts: 1430	Hello, could you get us dump of this table? We will test it.
	ARTIO Support Team The topic has been locked.

Re: SQL Query OK, but get empty output. 12 years, 11 months ago #40930

fsebbah OFFLINE Posts: 6	I send you the dump of this table. Thanks, Franck File Attachment: File Name: dump_artio.zip File Size: 2 KB
	Last Edit: 12 years, 11 months ago by fsebbah. Reason: It's not possible to add sql file. The topic has been locked.

Re: SQL Query OK, but get empty output. 12 years, 10 months ago #41353

fsebbah OFFLINE Posts: 6	Hi, I never received a response ? Have you more information for me ?
	The topic has been locked.

Re: SQL Query OK, but get empty output. 12 years, 6 months ago #42758

jitr OFFLINE ARTIO Support Posts: 1430	Hello We need dump of jos_comprofiler table to try it. You got us jos_artiofusioncharts only. Joomla database connector is different from PHPMyAdmin. I think that it is not problem of Fusioncharts but Joomla database connector.
	ARTIO Support Team The topic has been locked.

Page:
1

ARTIO Forums

Support

TOPIC: SQL Query OK, but get empty output.