On Fri, Jan 21, 2011 at 6:46 AM, Mark A. Kruger <mkru...@cfwebtools.com> wrote: > http://www.coldfusionmuse.com/index.cfm/2007/9/28/Branch.Target.Offset
Putting each query in a separate function and then calling the functions inside the <cfcase> tags would also probably have solved it and would have made the original function easier to read since it would just contain the overall logic - with the SQL implementation 'hidden away' in other private functions. -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ "If you're not annoying somebody, you're not really alive." -- Margaret Atwood ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341110 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm