[ic] SQL sum function in query tag?

Joshua Lavin interchange-users@icdevgroup.org
Tue Jan 28 11:53:00 2003


I'm wondering if it is possible to do SQL functions within the query 
tag. My database is MySQL.

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. I would guess there's a problem with what I 
should ask for (sql-param ???). Is this even possible?

Thanks,
Josh