[ic] SQL sum function in query tag?

[Jonathan Clark]

> >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
>
> If that is valid SQL for your table, try [sql-pos 0].  If that
> works, then
> isn't passing 'length' back as the column header.

Yep.

To return the sum under the column name 'length' use 'AS', also, sku is a
string so needs to be quoted:

SELECT time_format(sum(length), '%T') AS length FROM music WHERE sku =
'[item-code]'


Jonathan
www.Webmaint.net