I generally do, simply because there have been so many times I've had to expand the flag field to be more that on/off. Paid/unpaid/bounced kinds of things. (Yes, I realize I could have just added a second flag field, but that isn't always the case.) I'm not sure if it has any effect on efficiency.
--Ben Doom [EMAIL PROTECTED] wrote: > Another CF developer mentioned to me the other day that it's better to > store 1,0 values in a smallint compared to using bit value for on of off > functionality within an app in CF7 or greater. > > Thoughts? > > Thanks > > D > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291403 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
