Hi John, My post was trimmed by google last night here is how I would do it:
Cfc: http://pastebin.com/m531124e5 cfm: http://pastebin.com/m17bd448f Its fine to put querys in a cfc and for you it will be less code and less code means less maintenance. Paul. -----Original Message----- From: John Barrett [mailto:[email protected]] Sent: Friday, August 21, 2009 4:07 AM To: cf-newbie Subject: Re: cfc query thanks so much`-` In general I think that this is a better practice than having all the cfqueries on your pages right? John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-newbie/message.cfm/messageid:4742 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
