Weston, Craig (OFT) wrote:
There were 2 changes -
First was IF(`status` = 'WIP',SUM(time_to_sec(RIGHT(`CLOCK_TIME`),8)),0)
AS 'WIP' ( I addded the "RIGHT" limit on the string)
And second was grouping by KEY,STATUS
Further experimentation makes it appear that I am getting the right
number of seconds for the entire string, so I am playing without the
RIGHT() modifier right now. Maybe making a table with the status's on
separate rows and then querying against that to make the single line??
Changes to what? Did i miss the post where you included the entire
SELECT statement?
(please don't top-post)
brian
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]