I am not allowing the user to manually input the date. I am using the CFINPUT Type=DateField which creates a flash calendar, the user clicks on the date and voila! Date is entered. Problem is that if any of the others are not filled out, my database fields are getting populated with 1/1/1900 automatically rather than a null.
Bruce On 1/24/07, Teddy Payne <[EMAIL PROTECTED]> wrote: > > Bruce, > I would break down the date. Allowing the user to enter 11/11/2007 is > asking for a lot of validation. > > You probably should have a month, day and year input field for each date > range. This makes it easier to validate. > > 1/1/1900 is a behavior of SQL Server smalldate field when you send it an > empty string. If the field is NOT NULL, it will create a rudimentary > date. > > In your update, you can have conditional logic using <cfif> to only update > the field if you have a valid date when you try to create a date based > upon > the three input fields. > > Teddy > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267498 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
