[ic] SQL sum function in query tag?

[Stefan Hornburg]

On Tue, 28 Jan 2003 10:50:37 -0600
Joshua Lavin <joshua@kingdomdesign.com> wrote:

> 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?

Have you tried [sql-code] or [sql-param 0] ?

Ciao
       Racke