> Cfqueryparam allows to to specify that NULL values are > allowed anyway, so you don't need to do that check.
Can you explain what you mean? ColdFusion has no concept of null. The NULL attribute, if set to 'YES' means that CFQUERYPARAM ignores the value in the VALUE attribute and passed the database a null. I've got loads of situations where I need that functionality that I could not achieve without the NULL attribute. The example given is that if a form field has no value, a null requires to be inserted, not an empty string. These are not the same thing. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
