I had a whole response typed up but my browser crashed... (repeatable crash for me, ctrl+z in firefox on ubuntu 8.10 causes crash for me)
I changed my SP to just return the first result set, and it retrieved nothing:
Code:
procString: call sp_graphAvgLowest
Call successful...
No result set returned!
graphType:
graphTitle:
xCol:
yCol:
bCentAvg:
bOverallAvg:
The call completed successfully, but no result was returned.
Here is the updated SP with only the first result set:
Code:
DELIMITER $$
DROP PROCEDURE IF EXISTS `flightmon`.`sp_graphAvgLowest`$$
CREATE DEFINER=`<name goes here>` PROCEDURE `sp_graphAvgLowest`()
BEGIN
select 'textlin' as 'graphType',
'Average of lowest prices found each day from\n%s to %s' as 'graphTitle',
'depart_date' as 'xCol',
'price' as 'yCol',
'TRUE' as 'bCentAvg',
'TRUE' as 'bOverallAvg';
/*select depart_date,
avg(price) as price,
query_date
from ( select depart_date,
min(price) as price,
query_date
from flightInfo
group by depart_date,
query_date
order by depart_date) as selection
group by depart_date order by depart_date asc;*/
END$$
DELIMITER ;