Thanks for all the input. I've worked solo for 5 years and this is the only way for me to brainstorm! It's great to see how other developers approach even some of the more simple tasks. There is always something to learn.
T >It also sounds like some negative testing might help in this case - there's >data being tested as dates that can contain ambiguous values. "09-262" may >not seem like a regular date to us but it could be - CF doesn't have any >prejudices: if there's any way to consider the value a date, then it does. > >So in this case it might be as simple (if that's a regular format) to create >a "isCubicleNumber()" function and run that as well: > ><cfif NOT isCubicleNumber(myVar) AND isDate(myVar)> > >You can create as many negative tests as your data requires to winnow away >the ambiguous values before sending them to isDate(). > >But you're always going to have problems applying type-detection to >essentially random data - there will almost always be chances for false >positives. > >Jim Davis ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

