> Thanks for the clarification. Makes perfect sense. > The only reason I put the distinct in there in the first place (not > realizing the consequences) was that the data being given to us was so > flaky.
I can relate... I remember at my last "permanent" job there was a web-form for submitting resumes in a textarea. They'd have put a 20pt blinking red notice ( with lots of exclamation points ) saying, no more than x number of characters and people would still copy and paste in roughly 10-20x the maximum number of characters. Is the word-count feature so hard to find? S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm

