> >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 _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.