To expand a little more on my previous comment, your default value on the column will only come into play if you do not explicitly insert a value (any value). So if your query does not contain the 'link_sort' column, then and only then will the default value be inserted.
On Fri, Sep 12, 2008 at 2:11 PM, Matt Quackenbush wrote: > Are you saying that you have '99' set as the default value on the > 'link_sort' column in your database table? If so, then the reason it is > inserting a NULL is because you are telling it to. NULL is essentially a > value, so therefore the default value of '99' never comes into play. > Nothing is wrong there, that's the way you have coded your application. :-) > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
