On Tue, May 4, 2010 at 12:40 PM, Judah McAuley <ju...@wiredotter.com> wrote: > You can nest ternary operators, I believe, but it is going to start > getting pretty unreadable quickly. If you have more logic to run, I'd > suggest pulling it up out of the sql statement, figuring out the final > result, then using that result in the conditional in your cfparam.
I agree. Embedding that much logic in the middle of your <cfqueryparam> tags is going to create a maintenance nightmare. Consider preprocessing your form scope to clean up the fields so that the ?: condition can be nice and simple. -- 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-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm