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=89.70.4
