Coldfusion insert null

Labels: cfqueryparam , ColdFusion , insert null. Newer Posts Home. Subscribe to: Posts Atom. I believe the Admin API example needs changed? The topic is Null support in CF You must be logged in to post a comment. Show All Notifications.

Join Community. Sign In. Post here. Adobe Certification. Getting Started. Admin API. Language Enhancements. Application Datasource. Application Monitoring. Application Performance. Performance Monitoring Toolset. Good post upendra. Your approach is very sound, a tricky solution to populate field with null value.

But i think we can make DB itself to populate field with null value, in that case we will use if else statement in coldfusion. If you need your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees even if they're dating somebody else now you have to watch this video right away It is always a good practice to use cfqueryparamparam while passing parameter for any data base operation in ColdFusion.

BDavis BDavis 2 2 bronze badges. Jack - Keep in mind a null is different than an empty string "". Using cfqueryparam you could simply insert the empty string instead of a null. At least for the varchar columns. It all depends on your goal, and whether the columns allow nulls. For the timestamp field, I'd change the null attribute to use isDate on the date variable instead of len. You probably want a null attribute on the date variable as well.

Marius Marius 2, 1 1 gold badge 13 13 silver badges 24 24 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.