On Tue, March 28, 2006 15:05, Paul Yasi wrote: > I bet it's trying to join them with their services and billing, and > when they don't have any services or billing the query doesn't work. > yes, and if they do have billing and services it still does not work sometimes. Part of the WHERE clause user_services.removed <> 'y' seems to be part of the problem I see on my site.
-- Regards, Doug ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Citrusdb-users mailing list Citrusdb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/citrusdb-users