At 16:55 -0500 2/14/03, Peter Grigor wrote:
Yep, you're right. Never noticed that before :) I think that would probably be considered a bug. But possibly for efficiency's sake the check was made ultra simple.
It can be argued either way. You could just as well consider it a bug that you try to shove garbage into your database. :-) Client-side validation has the disadvantage that you must do it in each client, of course. On the other hand, for things like web apps, you may as well validate the data in the client anyway: Suppose MySQL validated the date and returned an error for a bad data. You'd just have to tell the user that anyway, plus you wasted time sending a bad query to the server. If you check the date in your app, you can tell the user immediately and skip the bad query.
Peter <^_^> --------------------------------------------- Peter Grigor Hoobly Free Classifieds http://www.hoobly.com
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <suppressed> To unsubscribe, e-mail <suppressed> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.