Gretings! I see this as well. It's because this query: SELECT COUNT(*) AS `mapCount` FROM `base2_dynamic`.`D320RawParents` `rawmap` WHERE `rawmap`.`cube` = 3 GROUP BY `rawmap`.`column`, `rawmap`.`position` ORDER BY COUNT(*) DESC should say: SELECT COUNT(*) AS `mapCount` FROM `base2_dynamic`.`D320RawParents` `rawmap` WHERE `rawmap`.`cube` = 3 GROUP BY `rawmap`.`column`, `rawmap`.`position` ORDER BY mapCount DESC
Hm. For mysql4, anyway. Any ideas on how this can be repaired for people who are bound to mysql4? Chad Matsalla ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to [EMAIL PROTECTED]