Thanks for the reply. reading my question back it did not make much sense, so you did well to work out what I was on about lol! >I'd go with a query unless you have a particular reason not to.
no reason, that would be the way I would normally do it, however if I wanted to try and keep this strict OO like I was wondering how this would play out. I can still access the service layer first(not server layer above lol) and the query directly but it seems to brake the rules of OO some what and I wondered how others do it. thanks for the link the site is down but will look at it when its back up. Glyn ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4