I think the clearest method is probably selects with options: value - display NULL - not set (or similar) 1 - true/yes/on 0 - false/no/off
On Thu, Oct 20, 2011 at 12:06 PM, Carl Von Stetten <[email protected]>wrote: > > I'm rewriting a CF application that stores its data in SQL Server (2005, > moving to 2008R2 soon). I have a number of bit datatype columns in my > tables, which correspond to true/false or yes/no values in the application. > For some of these values, I need to track if they have not yet been set to > either true or false. On the database side, I can allow the columns to > contain nulls (and apply a default constraint set to null), so the value in > the column could be null, 0 or 1. > > On the application UI side, bit values are typically represented by > checkboxes. It seems to me that checkboxes can only clearly communicate two > states. I could use a set of radio buttons, and have neither radio button > on by default (which would represent null values in the database). Is this > the best way, or are there alternatives? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348279 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
