Well I always set my tables to have a default value when none is supplied, so varchar fields will automatically default to NULL if NULL is allowed. If NULL is not allowed then it will never get passed anyway due to form validation.
Russ -----Original Message----- From: COLLIE David [mailto:[EMAIL PROTECTED] Sent: 27 September 2006 17:22 To: CF-Talk Subject: RE: Insert best practice > 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:254419 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
