-- 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 _______________________________________________ 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.