Click here to get back home

with rollup

 HomeNewsGroups | Search | About
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
with rollup Ike 09-15-2006
Get Chitika Premium
Posted by Ike on September 15, 2006, 8:56 am
Please log in for more thread options
When I use "With rollup," I am getting totals on columns which are numeric,
however, non-numeric columns are copying down to the rollup column (i.e. the
last column's non-numeric columns are being duplicated on the rollup
column).

For example. if I order by date with rollup and, I am also outputting
emplyee, and some numeric value , at the rollup row, the totals appear, that
date, of course, properly appears, but the employee name from the previous
row is also duplicated on this row.

How can I avoid that? Thanks, Ike




Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap