Re: Mysql 4.1 and the LIMIT sql statement

2005-03-09 Thread Dennis Fogg
On Nov 17, 2004, Matt Babineau Dan Nelson discussed: Has anyone run into problems with this sql syntax? LIMIT -1 I've used this extensively in my code to get back all records rather then specifing a limit. I've done this programmatically with PHP, so all my queries have a limit

Mysql 4.1 and the LIMIT sql statement

2004-11-17 Thread Matt Babineau
Hi all- Has anyone run into problems with this sql syntax? LIMIT -1 I've used this extensively in my code to get back all records rather then specifing a limit. I've done this programmatically with PHP, so all my queries have a limit even if I don't need one, I just have it specify LIMIT -1,

Re: Mysql 4.1 and the LIMIT sql statement

2004-11-17 Thread Dan Nelson
In the last episode (Nov 17), Matt Babineau said: Has anyone run into problems with this sql syntax? LIMIT -1 I've used this extensively in my code to get back all records rather then specifing a limit. I've done this programmatically with PHP, so all my queries have a limit even if I

Re: Mysql 4.1 and the LIMIT sql statement

2004-11-17 Thread Mark Papadakis
I suppose they fixed it. Relying on 'undocumented features' is a bad habbit. Update your code to exclude the LIMIT clause if you do not wish to use it. Its the best thing ou can do. Mark Papadakis On Wed, 17 Nov 2004 12:21:31 -0800, Matt Babineau [EMAIL PROTECTED] wrote: Hi all- Has