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. :-)
On Fri, Sep 12, 2008 at 1:30 PM, Les Mizzell wrote: > OK, if I set my column "link_sort" with a default value of "99", and put > this in my query... > > link_sort = > <cfqueryparam > value="#Form["sortORD_#myIDX#"]#" > cfsqltype="CF_SQL_VARCHAR" > null="#not len(Form["sortORD_#myIDX#"])#"> > > ....and submit a blank form field - it inserts a NULL instead of the "99" > default value. > > What's wrong? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:312462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
