RE: Disorder result with ORDER BY with ENUM, INT

2003-11-26 Thread TheMechE
I'm using mySQL 4.0.14 Linux and the mySql CC 0.8.9 Beta. I ran your script and I'm clear. So its version specific. -Original Message- From: Kriengkrai J. [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 2:05 AM To: [EMAIL PROTECTED] Subject: Disorder result with ORDER BY wi

RE: Searching for a realtime progress bar that uses mySQL and Flash?

2003-11-25 Thread TheMechE
Ok here is the soluction. Feel me, yall, this is the winner of the prize. You see, it is an uncommon operation, but you CAN have a JavaApplet call a method on your window object. By having the java applet gain access to its window object, you can drill down into the if(window.methodName==true){

RE: Error 1045: Acess denied for user: 'ODBC@localhost' (Using password: YES)

2003-11-24 Thread TheMechE
ike, Well, there are quite a few wierdnessess that I have experienced. One, for instance, is if you are working in the GUI editor interface, and are mucking around with the User priveleges I have actually had the GUI wipe the passwords to null for all rows. I'm sure its just because I'm not

Rats fleeing a sinking stinker....

2003-10-13 Thread TheMechE
As an interesting note... I recently moved one of my legacy databases from SQLSVER7 onto my production mySQL server. It took 10min. Well, ok, maybe a bit longer... but my buddy, wonderful godlike java geneous that he is wrote an applet that will move all the data over from SS7 to mySQL without h

RE: SHOW slave STATUS returning no rows. SOLVED

2003-09-29 Thread TheMechE
Solved issue. Sorry. Connection was connecting to Master not slave... Hence... Master possessed no Slave Status information. _A "Deduction, dear Watson..." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE

SHOW slave STATUS returning no rows.

2003-09-29 Thread TheMechE
>From a Java connection object, Show Slave Status returns no rows Running mysql on linux. Also testing the SQL through mysql control center 0.8.9 Thanks, Andy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PR

What about auto number primary key - wrapping?

2003-07-15 Thread TheMechE
Has anyone had a table that has lived long enough to wrap the auto incrementing number...? i.e. the complete byte span and back to 0x32. I'm just wondering if mySql will fill in the deleted ID's that don't exist, or if it just halts... -- MySQL General Mailing List For list archives: http://l

Can someone interpert this log....

2003-06-20 Thread TheMechE
Here's the log. Retrying... Moving info for table LogOutputStats Setting fields and metadata. Using original table. Tracking field is ResRefID Starting transfer. As the Pharoh says... Ye who can interpert my dreams will become second greatest in the LAAANNND All the rest of you will get

RE: linux and mysql socket

2003-06-20 Thread TheMechE
Hmmm I was having that issue when I shut my server down... i.e. the mysql daemon... did you turn off your machine, and not have mysql automatically boot up? -Original Message- From: azamka [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 4:07 PM To: [EMAIL PROTECTED] Subject

RE: SQL query question

2003-06-20 Thread TheMechE
Rolf, You need to separate your functions. You are adding complexity to your world by storing irrelvant infromation in your database. Critical Data Handling (in a proper world) is ALWAYS handled separately from display. So in your example, You are storing all the html display formatting in your

Large Table Woes

2003-06-18 Thread TheMechE
Hey gang... sorry, I duped the subject of someone elses message... so I'm going to send this again In my dbMove application I have the following. Ask SQL how many records I am moving-> OK Display that amount -> OK Delete all from corresponding MySQL tab

Loss of connection???

2003-06-18 Thread TheMechE
Hey gang... In my dbMove application I have the following. Ask SQL how many records I am moving-> OK Display that amount -> OK Delete all from corresponding MySQL table -> OK Long pause, get a coffee, take a nap java.sql.SQLException: Communication l

Every Increasing Memory.....

2003-05-30 Thread TheMechE
ake the code and make my own? That would be my first foray into open-source manipulation of code. is this that sort of instance? And perhaps if there are better drivers out there for my application? -TheMechE