All ColdFusion expressions and functions will throw an undefined error, if you reference a variable that is, you know, undefined even expressions and functions used inside of the "null" property of the <cfqueryparam...> tag.
If you expect that the variable is going to be undefined, as some form variables may very well be, you need to account for this in your logic. You can either use the <cfparam...> tag to make sure they are never undefiend, or you can use the structKeyExists() or the less prefered isDefined() functions to test if they exist. For the latter options you may need to write a more complex expression for the null property that makes uses of some type of AND|OR operators. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:333284 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
