Or
CreateTimeSpan(0,1,0,0) EQ "001A" ...had some strange validation issues with a form recently. This was exactly the problem. User was entering "000A" into a numeric field, which should have caused a validation error to appear. CF parsed it as numeric and but when it got to the DB --> exception. ________________________________ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Phil Haeusler Sent: Tuesday, 15 April 2008 10:20 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Just in case anyone's feeling bored... An oldie, but a goodie. You're left scatching your head until you work out the following <cfoutput> #isDate("000A")# #isDate("012A")# #isDate("000P")# #isDate("012P")# </cfoutput> CF's wonderful automatic date conversions phil <cfoutput> #round(000 EQ "000A")# #round(000 EQ "000A")# #round("000A" EQ "012A")# #round("000P" EQ "012P")# </cfoutput> ...Very interesting results. Joel Cass Developer Gruden - Design | Development | Implementation t +61 2 9299 9462 f +61 2 9299 9463 m 0414 688 774 www.gruden.com <http://www.gruden.com/> --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---