EasyCFM.COM ColdFusion Forums / Other / Inserting NULL values

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Inserting NULL values

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

Enervate2004
09-12-2007 @ 3:59 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 18
Joined: Mar 2004

Hi, im trying to insert a blank / null value into a database that doesnt allow a null value. I cant change the database structure, so i need to insert it as a blank. I can submit text as a blank by just using '. That way it submits a blank space which isnt a problem. The problem lies in numeric fields. You cant use ' in a numeric field or it throws a data mismatch error. So how do you submit a null numeric value? Thanks in advance.


Website Designed and Developed by Pablo Varando.