[ic] SQL sum function in query tag?

[Jay Sun]

--

On Tue, 28 Jan 2003 10:50:37  
 Joshua Lavin wrote:
>On the flypage, I'm passing this code (adds times >for track rows to get 
>the total disc time for a CD):
>
>[query sql="select time_format(sum(length), '%T') from music where sku = 
>[item-code]" table=music type=list]
>[list]<p>[sql-param length]</p>[/list]
>[/query]
>
>This gives me nothing. 

Try [query sql="select time_format(sum(length), '%T') as length from music where sku  ....


Jay
http://suniant.com


_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus