Re: finding next and prev record in mysql

2007-05-11 Thread Brent Baisley
You actually do want to use the limit clause, but use 2 parameters. The first number is which record you want to start at, the second is how many records you want. So limit 2,1 will give you the second record. It's the same query every time, you're just incrementing the first number of the limit

Re: Mysterious 'Lost connection' errors

2007-05-11 Thread Jon Ribbens
On Thu, May 10, 2007 at 05:17:12PM +0100, Jon Ribbens wrote: I suspect some sort of bug in the MySQLd authentication code. I've managed to discover using --debug that it's due to MySQLd failing to handle EINTR from read() in the authentication stage. I've filed a bug report:

Re: finding next and prev record in mysql

2007-05-11 Thread Mogens Melander
On Fri, May 11, 2007 07:15, Richard Kurth wrote: How would I find the next id and the prev id in sql statement like the one below. The id number is not going to be in order so I can't do a or limit 1 on the search SELECT id FROM contacts WHERE category = '5' AND subcategory = '1' AND

Re: finding next and prev record in mysql

2007-05-11 Thread Baron Schwartz
Hi, Richard Kurth wrote: How would I find the next id and the prev id in sql statement like the one below. The id number is not going to be in order so I can't do a or limit 1 on the search SELECT id FROM contacts WHERE category = '5' AND subcategory = '1' AND members_id= '8' ORDER BY

MySQL Enterprise 5.0 x64 Intel C++

2007-05-11 Thread Dyego Souza Dantas Leal
I'm a customer of MySQL Enterprise 5.0 The binary for Red Hat Enterprise 5 x64 compiled with Intel C++ does't exists anymore ? Tnks ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General

Re: finding next and prev record in mysql

2007-05-11 Thread Baron Schwartz
Mogens Melander wrote: On Fri, May 11, 2007 07:15, Richard Kurth wrote: How would I find the next id and the prev id in sql statement like the one below. The id number is not going to be in order so I can't do a or limit 1 on the search SELECT id FROM contacts WHERE category = '5' AND

mysqlmanager: The instance ... is being stopped forcibly. Normallyit should not happen. ...

2007-05-11 Thread Uwe Galle
Hi, I installed the noinstall package of mysql 5.0.41 on Windows Server 2003 R2 SP2. I manage an instance with mysqlmanager of this package. The my.ini is the following: [manager] pid-file=mysqld37.pid [mysqld37] mysqld-path=D:/Programme/MySQL/mysql-5.0.41-win32/bin/mysqld-nt.exe

RE: finding next and prev record in mysql

2007-05-11 Thread Richard Kurth
-Original Message- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Sent: Friday, May 11, 2007 9:25 AM To: Mogens Melander Cc: mysql@lists.mysql.com Subject: Re: finding next and prev record in mysql Mogens Melander wrote: On Fri, May 11, 2007 07:15, Richard Kurth wrote: How would I

Path information to a database

2007-05-11 Thread Brian E Boothe
i have a question: i have a Projects folder on my D: drive under this folder is folder by the name of the Customer then Subfolders that Corespond to the Project Ex, d:\projects .. Jobs LSRW -- Rsview --RSLogix

Re: Path information to a database

2007-05-11 Thread Mike Lockhart
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brian, There are several ways you could store this information, either complete paths, or relative paths, something along these lines: Tables: - --- Projcts: ++ | PROJ_ID | PATH

Path information into database

2007-05-11 Thread Brian E Boothe
so how would i get the Actual file path to the folder into the database, i know ill have to use a file selector in asp / php but i wanna select the folder not the Files, it would be really great if u could help me with these issues, i'm not asking u to Code anything for me , just links of

RE: finding next and prev record in mysql

2007-05-11 Thread Richard Kurth
This good for giving me the next recorded but it will not give me the prev recorded that is the one I am having problems with You actually do want to use the limit clause, but use 2 parameters. The first number is which record you want to start at, the second is how many records you want. So

Re: Path information into database

2007-05-11 Thread JamesDR
Brian E Boothe wrote: so how would i get the Actual file path to the folder into the database, i know ill have to use a file selector in asp / php but i wanna select the folder not the Files, it would be really great if u could help me with these issues, i'm not asking u to Code anything for

Query Cache Behavior

2007-05-11 Thread Paul J. Boyes
Hello, I am hoping to get pointed in the right direction/save some time... I have a db in which some web services are constantly inserting/updating data. However, when I run selects from the command line mysql app, I do not see the changes that these services have made unless I do a flush

Re: Query Cache Behavior

2007-05-11 Thread Baron Schwartz
Hi, Paul J. Boyes wrote: Hello, I am hoping to get pointed in the right direction/save some time... I have a db in which some web services are constantly inserting/updating data. However, when I run selects from the command line mysql app, I do not see the changes that these services have

Re: finding next and prev record in mysql

2007-05-11 Thread Baron Schwartz
Hi, Richard Kurth wrote: -Original Message- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Sent: Friday, May 11, 2007 9:25 AM To: Mogens Melander Cc: mysql@lists.mysql.com Subject: Re: finding next and prev record in mysql Mogens Melander wrote: On Fri, May 11, 2007 07:15, Richard

Re: Query Cache Behavior

2007-05-11 Thread Paul J. Boyes
This is our problem: http://bugs.mysql.com/bug.php?id=27210 Thanks, Paul Baron Schwartz wrote: Hi, Paul J. Boyes wrote: Hello, I am hoping to get pointed in the right direction/save some time... I have a db in which some web services are constantly inserting/updating data. However,