Re: Wrong query result

2004-09-12 Thread Heikki Tuuri
://www.innodb.com/order.php Order MySQL technical support from https://order.mysql.com/ - Original Message - From: "Mauricio Pellegrini" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Saturday, September 11, 2004 6:05 PM Subject: Wrong query result > S

Wrong query result

2004-09-11 Thread Mauricio Pellegrini
Sorry to insist with this, but still can't find the reason. Any ideas? -Forwarded Message- Hi, I'm using MySql 4.1.4 Gamma and the following query returns values containing N and Ñ instead of only those containing Ñ. The query is as follows Select Lastname from table1 where loc

Wrong query result

2004-09-08 Thread Mauricio Pellegrini
Hi, I'm using MySql 4.1.4 Gamma and the following query returns values containing N and Ñ instead of only those containing Ñ. The query is as follows Select Lastname from table1 where locate("Ñ",Lastname)>0 The result set includes values like this HERNANDEZ NUÑES

Re: Sequence of SQL actions gives wrong query result for 10 seconds!

2002-11-13 Thread Heikki Tuuri
uot;Mike W-M"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, November 13, 2002 11:07 AM Subject: Sequence of SQL actions gives wrong query result for 10 seconds! > All, > > I've been having problems with a pretty simple series of SQL sta

Sequence of SQL actions gives wrong query result for 10 seconds!

2002-11-13 Thread Mike W-M
All, I've been having problems with a pretty simple series of SQL statements run against some InnoDB tables returning the wrong results - temporarily! Basically, I have one "middle" table that maps a "role" to an "operation" (many-to-many), and I have separate role and operation tables that conta