Re: aggregate query problems

Ta - just tried that and no records for all language groups.

BUT that did make me realise one of my (many) errors - the database is actually quite complicated so I created a table (tbl_demographics) which I re-populate every time I run this query - and that does not collect towns with zero language groups and I can't see how I could.

I think I'll leave this for a while - it's driving me nuts and wasting far too much time.
thanks very much for your help

Seamus

>Hmmm ... do you get a record for every language group if you CFDUMP that
>query or if you run it directly on the DB server?



>Hmmm ... do you get a record for every language group if you CFDUMP that
>query or if you run it directly on the DB server?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324298
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.4