SQLException error code is different

2002-02-26 Thread Becky McElroy
Hello, I'm running the same code in 2 different environments, but both environments access the same MySQL database (3.23.47 Max, running on Solaris 2.8) and both use mm.mysql-2.0.7. Environment 1: IBM VisualAge for Java, which has JDK 1.2.2, running on a Windows machine Environment 2: JDK 1.3.1 r

SQLException error code is different

2002-02-25 Thread Becky McElroy
Hello, I'm running the same code in 2 different environments, but both access the same MySQL database (3.23.47 Max, running on Solaris) and both use mm.mysql-2.0.7. Environment 1: IBM VisualAge for Java, which has JDK 1.2.2, running on a Windows machine Environment 2: JDK 1.3.1 running on Red Hat

Re: How to connect in non-interactive mode

2002-02-13 Thread Becky McElroy
or > that particular client, allow the client to check for connectivity, without > having to make ever client connect forever!!. I'm sure the JDBC driver will > allow for this. > > Regards, > Dan > > > -Original Message- > > From: beckymcelroy [mailto:becky

How to connect in non-interactive mode

2002-02-12 Thread Becky McElroy
ons much appreciated - Becky McElroy - 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 PROTECTE

How to connect in non-interactive mode

2002-02-11 Thread Becky McElroy
ons much appreciated - Becky McElroy - 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 PROTECTE

Re: Multi-table delete/update

2002-01-14 Thread Becky McElroy
or the second table, I get > >> > >> ERROR 1032: can't find record in 'tblname' > >> > >> If I do it again, then I get the query output just fine for the second > >> table from that point on. > >> (I'm using MySQL-Max-4.0.1-2 o

When will 4.0 be beta?

2002-01-14 Thread Becky McElroy
For production product planning purposes, can someone tell me when MySQL 4.0 will be labelled beta? Thanks. -- Becky McElroy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Multi-table delete/update

2002-01-10 Thread Becky McElroy
453 | 500 | 3 |10 | 0 | ++---++-++-++-+-+---++ 1 row in set (0.00 sec) mysql> delete from cnam1; Query OK, 2 rows affected (0.01 sec) mysql> delete from cnam2; Query OK, 1 row affected (0.02 sec) -- Becky McElroy --

Multi-table delete/update

2002-01-09 Thread Becky McElroy
hat point on. (I'm using MySQL-Max-4.0.1-2 on Red Hat linux 6.1) It's looking like a bug. Has anyone else encountered this? 2) Does anyone know when multi-table update will be available? Thanks. -- Becky McElroy

Re: apostrophe's in PHP

2002-01-09 Thread Becky McElroy
I've found that using PreparedStatement.setString() takes care of any apostrophe's within a given sql string field. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/