> 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? > You might check you sql query in MySQL. I am pretty sure that sku is a string field, so your query should have quotes around the item code, sku='[item-code]' Matt _______________________________________________ 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.