I just tried it myself and I get an empty set as expected. What do you get when you do a 'select * from test'?
> -----Original Message----- > From: Valdir Stiebe Junior [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 22 January 2003 5:48 am > To: [EMAIL PROTECTED] > Subject: Re: Hi and why > > > I don't know why it returns the first two rows, but (assuming you didn't > > really end your query with two question marks) what error are you > expecting > > to occur? > > I didn't end my query with the two question marks. :) > And if i put 0 instead of (2 or any different of zero) after the equal > sign > the sql return nothing. (better than returning garbage) > I was expecting something like 'Column NAME isn't of type integer'. > > > > --------------------------------------------------------------------- > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail <mysql-unsubscribe- > [EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php