Les Mizzell wrote:
>
> Just got off the phone with them - if they don't associate a specific
> day with the date, then for legal reasons there *can't* be specific day
> with it - it can't even default to the 1st. They may even want to enter
> "sometime in 1979"!
>
> That pretty much changes everything. Looking like I'll have to change
> all the SQL Date fields to accept text and just let them enter whatever
> the heck they want, since that's what they're asking ("1/23/2006" or
> "2/1998" or "sometime in 1987"!).
My preferred solution for that problem is to store both a start date and
an interval, i.e. store '1/1/1987' and '1 year'. That way you can still
do range searches on the date.
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268057
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
