Thanks again everyone for your feedback. Sean - Not to get off this subject, but I noticed your signature and realized my boss and myself were on your site (getrailo.com) reviewing it because we have been looking into trying to get some kind of internal wiki for mainly having search-able documentation to share/keep track of for our IT dept, developers, administration, etc. Just thought it was pretty ironic I had to laugh. It looks like something we'll want to try out and use.
Matt... >> 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:333338 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

