RE: Select with join query question
This gives the count per job which is always 1. I'm using the 'having' clause which requires the 'status' field in the select list. This makes it difficult to get a total. I'll play with the 'where' clause example to see if that works. Thanks again! -Original Message- From: Bruce Feist [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 7:42 PM To: Richard Bolen Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Select with join query question Richard Bolen wrote: This works! I was then wondering how to get the total number of all jobs that this condition is true for? Just include count(distinct j.jobid) in the SELECT list. Bruce select j.* FROM Jobs j LEFT JOIN Submissions s ON j.jobid = s.jobid GROUP BY /* all selected columns */ HAVING min(abs(s.status - 1)) 0 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Select with join query question
I'm trying to write a select query that involves 2 tables. One table (Submissions) has a one to many relationship with the other table (Jobs). I'm trying to find all the records in Jobs that do NOT have a corresponding record in Submissions with a status of 1. The problem I'm having is that when there is more than one record in Submissions that match a record in Jobs and one Submissions record has a status of 1 and one record doesn't, my query matches the one with status != 1 and returns the record for Jobs (even though it has a record in Submissions with a status of 1 also). I've tried a variety of queries including left outer joins and more simple join relationships. I'm using MySQL 3.23.47 on Windows. Here's an example query: select j.job_id from jobs j left outer join submissions s on (j.job_id = s.job_id) where s.status_id != 1 group by j.job_id Any help is greatly appreciated. Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Select with join query question
I think this gets me all the Jobs that have no submissions but I'm really looking for any job that doesn't have a submission with a status of 1. That means I need Jobs that don't have submissions plus jobs with submissions with exclusively non-1 statuses. The problem is when a job has more than one submission associated with it (and at least one submission has a non-1 status). Something like this should work. You want to do a left join on Jobs so you don't filter out those without submission matches. The resulting left join will have a value of NULL for any fields joined from Submissions that don't have a match in Jobs. Just include at least on field from Submissions and test for null on that field. SELECT *,s.status AS ActiveJob FROM Jobs AS j LEFT JOIN Submissions AS s ON j.job_id=s.job_id WHERE s.status IS NULL On Monday, July 28, 2003, at 02:37 PM, Richard Bolen wrote: I'm trying to write a select query that involves 2 tables. One table (Submissions) has a one to many relationship with the other table (Jobs). I'm trying to find all the records in Jobs that do NOT have a corresponding record in Submissions with a status of 1. The problem I'm having is that when there is more than one record in Submissions that match a record in Jobs and one Submissions record has a status of 1 and one record doesn't, my query matches the one with status != 1 and returns the record for Jobs (even though it has a record in Submissions with a status of 1 also). I've tried a variety of queries including left outer joins and more simple join relationships. I'm using MySQL 3.23.47 on Windows. Here's an example query: select j.job_id from jobs j left outer join submissions s on (j.job_id = s.job_id) where s.status_id != 1 group by j.job_id Any help is greatly appreciated. Rich -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re: Select with join query question
This works! I was then wondering how to get the total number of all jobs that this condition is true for? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 5:26 PM To: Bruce Feist Cc: Richard Bolen; [EMAIL PROTECTED] Subject: Re: Re: Select with join query question [snip] Rich's solution, which I edited out, was a good one. But, if you really want to do it with a single JOIN, try this: select j.* FROM Jobs j LEFT JOIN Submissions s ON j.jobid = s.jobid GROUP BY /* all selected columns */ HAVING min(abs(s.status - 1)) 0 I leave it as an exercise to the reader to figure out why this works (if it does -- I haven't tested it!). If status = 1 is the lowest possible value for status, you can simplify this a bit. A quick test seems to show it works. Though it doesn't pick up the case where status IS NULL, which occurs when there's a job but no matching submission. One disadvantage to your method: it requires computing a formula for each tuple, which slows things down (in principle; not sure it really matters in practice). Bruce Feist -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Complex SQL query problem...
FYI - this query seemed to work. select * from nodes left join nodes as n2 on n2.parent_id = nodes.node_id left join jobs on jobs.parent_id = nodes.node_id left join colors on colors.parent_id = nodes.node_id where nodes.node_id = ? and ((n2.parent_id is not NULL) or (jobs.parent_id is not NULL) or (colors.parent_id is not NULL)) I need to do some more testing to be sure. Rich -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 08:46 To: Richard Bolen Subject: RE: Complex SQL query problem... After I sent this it hit me that it may not work if the first table (jobs) contained no rows...I believe this would only work if the tables left joined were empty not the jobs table. sorry... I apologize did not respond Friday but I left work at 4. Eddie -Original Message- From: Richard Bolen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 4:19 PM To: Edward Peloke Subject: RE: Complex SQL query problem... Does this handle the case where the ID is in the submissions table but not the jobs table? How would this look if there was a third table also? Thanks again for you help! Rich -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 15:59 To: MySQL Mailing List (E-mail) Subject: RE: Complex SQL query problem... try a left join select count(*) from jobs left join submissions on jobs.standard_id=submissions.color_id where jobs.standard_id=ID_VALUE and submissions.color_id is null Eddie -Original Message- From: Richard Bolen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:37 PM To: MySQL Mailing List (E-mail) Subject: Complex SQL query problem... I'm trying to use a sql query to determine if an ID exists in any of 3 different tables in the database. I need to do this in one SQL query (ideally only using the ID once in the query). I'm using mysql 3.23.47. Here's an example of a query I came up with: select count(*) from jobs, submissions where ID_VALUE in (jobs.standard_id, submissions.color_id) I'm just trying to determine if the ID exists. This query works *IF AND ONLY IF* there is at least one record in each of the tables. If any of the table are empty, this query always returns a count of 0 (even if there is a match in one of the non-empty tables). Does anyone know why this is happening or could someone suggest a alternate query? Thanks, Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421 http://www.gretagmacbeth.com/ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Complex SQL query problem...
I'm trying to use a sql query to determine if an ID exists in any of 3 different tables in the database. I need to do this in one SQL query (ideally only using the ID once in the query). I'm using mysql 3.23.47. Here's an example of a query I came up with: select count(*) from jobs, submissions where ID_VALUE in (jobs.standard_id, submissions.color_id) I'm just trying to determine if the ID exists. This query works *IF AND ONLY IF* there is at least one record in each of the tables. If any of the table are empty, this query always returns a count of 0 (even if there is a match in one of the non-empty tables). Does anyone know why this is happening or could someone suggest a alternate query? Thanks, Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421 http://www.gretagmacbeth.com/ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Complex SQL query problem...
Sorry about emailing you directly Eddie. I meant to reply to the list with my last email. Anyway - your suggestion worked wonderfully. Many many thanks. -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 15:59 To: MySQL Mailing List (E-mail) Subject: RE: Complex SQL query problem... try a left join select count(*) from jobs left join submissions on jobs.standard_id=submissions.color_id where jobs.standard_id=ID_VALUE and submissions.color_id is null Eddie -Original Message- From: Richard Bolen [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 2:37 PM To: MySQL Mailing List (E-mail) Subject: Complex SQL query problem... I'm trying to use a sql query to determine if an ID exists in any of 3 different tables in the database. I need to do this in one SQL query (ideally only using the ID once in the query). I'm using mysql 3.23.47. Here's an example of a query I came up with: select count(*) from jobs, submissions where ID_VALUE in (jobs.standard_id, submissions.color_id) I'm just trying to determine if the ID exists. This query works *IF AND ONLY IF* there is at least one record in each of the tables. If any of the table are empty, this query always returns a count of 0 (even if there is a match in one of the non-empty tables). Does anyone know why this is happening or could someone suggest a alternate query? Thanks, Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421 http://www.gretagmacbeth.com/ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Forcing case sensitivity via a query?
If I understand correctly, you have to define a char field as binary if you want the database to treat it as a 'case sensitive' field. Is there any way via a SQL query to force case sensitivity to be used for a non-binary char field? i.e.: for comparing strings in a case sensitive way. Or is there some way to force the database to use case sensitive string comparisons all the time (even for non-binary char fields)? I'm using the mm.mysql jdbc driver to access the database and it returns the data differently if a field is defined as binary. This is causing my string data to be garbled in my application for binary char fields. Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421 http://www.gretagmacbeth.com/ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL subtracting an hour from DATETIME types I insert?
I have a java application accessing MySQL via the mm.mysql type 4 jdbc driver. It appears that when I insert a record with a DATETIME type in it, it's subtracting an hour from the time. Does anyone know why this might be happening? Is it a timezone or daylight savings time issue? My server daemon has 'eastern daylight time' as the timezone, which I believe is the correct timezone. I have the same application running on top of an Oracle DB and the times are stored correctly. Thanks, Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421 http://www.gretagmacbeth.com/ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOAD DATA INFILE and how to ignore garbage lines at end of load file?
I'm exporting data from Oracle and importing it into MySQL. The problem is Oracle puts garbage lines at the end of it's output files. Lines like 300 rows selected and input truncated to 9 chars as well as empty lines. When MySQL loads these files, I'm getting rows inserted for the empty lines at the end of these files. Can I get MySQL to ignore empty lines at the end of these files? or if anyone has Oracle experience can I get it to suppress the output of these line? Thanks, Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421 http://www.gretagmacbeth.com/ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LOAD DATA INFILE and how to ignore garbage lines at end ofload file?
I added the line set feedback off at the beginning of my Oracle report script and that suppressed the output of the garbage lines. -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 11:33 AM To: Richard Bolen; MySQL Mailing List (E-mail) Subject: Re: LOAD DATA INFILE and how to ignore garbage lines at end ofload file? At 10:58 -0500 3/4/02, Richard Bolen wrote: I'm exporting data from Oracle and importing it into MySQL. The problem is Oracle puts garbage lines at the end of it's output files. As you've noted, the problem is Oracle. If you're using Unix, you could use tail to see how many of these lines there are and wc to count the total number of lines in the file. With that information, you can construct the proper value of n and use head -n to get only the initial part of the file that contains the non-garbage lines. Or you could reverse the order of the lines in the file (expensive?) and then use IGNORE n LINES in your LOAD DATA statement to ignore the first n lines. Better if you can get Oracle just to suppress these lines in the first place. Perhaps someone else will have a suggestion how to do that. Lines like 300 rows selected and input truncated to 9 chars as well as empty lines. When MySQL loads these files, I'm getting rows inserted for the empty lines at the end of these files. Can I get MySQL to ignore empty lines at the end of these files? or if anyone has Oracle experience can I get it to suppress the output of these line? Thanks, Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421 http://www.gretagmacbeth.com/ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Emulating a sequence in MySQL?
I need to have unique id's for every data element in my system no matter which table it's in. In Oracle I can create a sequence and with one SQL query I can increment the value and retrieve it for use in my next insert. Can I do this in MySQL? I know about AUTO INCREMENT but that appears to only work on a per table basis. Another key requirement is being able to increment the value and retrieve it with one SQL call. I'm thinking that I can create a table with one column to represent my sequence. The question I have is can I increment the value and retrieve it with one SQL statement? This may sound like a strange set of requirements but we're trying to get our app (a Java JDBC thing) to work across Oracle and MySQL without code changes. Thanks, Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421 http://www.gretagmacbeth.com/ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: AUTO_INCREMENT columns randomly restart counting from 1
I think AUTO_INCREMENT is on a per-connection basis. So if you're doing this across different database connections, it will reset to 0. Rich Hi there We have some table used as sequences. They only have 2 columns (ID, PID), with the AUTO_INCREMENT flag set for one of them (ID). By default the tables are empty! The increment process is done by inserting a new record with a random value for the non-auto_increment column. After that the new sequence value is fetched by selecting the random value. In the next step the one and only new row will we deleted using a 'delete from seq_xx WHERE PID = random_value' statement, as described in the manual. randomly the incrementation of any of the tables fails and the counter resets to 1, which breaks the whole application. this appears long before any overflow might happen. has anyone else ever noticed this? any idea what might be wrong ? the version of the server is 3.23.42 . best regards Andreas Schoelver - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL JDBC setup in weblogic.
This config worked for me: weblogic.jdbc.connectionPool.PoolName=\ url=jdbc:mysql://localhost:3306/test,\ driver=org.gjt.mm.mysql.Driver,\ initialCapacity=1,\ maxCapacity=10,\ capacityIncrement=1,\ props=user=DBUser;password=DBPassword weblogic.jdbc.TXDataSource.weblogic.jdbc.jts.PoolName=PoolName weblogic.allow.reserve.weblogic.jdbc.connectionPool.PoolName=everyone cheers - Rich -Original Message- From: Reinstein, Lenny [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 1:47 PM To: [EMAIL PROTECTED] Subject: MySQL JDBC setup in weblogic. Does anyone know how to set up a connection pool to the MySQL database in weblogic.properties? I tried to set it up as follows: weblogic.jdbc.connectionPool.mysqlConnPool=\ url=jdbc:mysql:localhost:3306,\ driver=org.gjt.mm.mysql.Driver,\ loginDelaySecs=1,\ initialCapacity=5,\ maxCapacity=10,\ capacityIncrement=1,\ allowShrinking=true,\ shrinkPeriodMins=15,\ testTable=weblogic,\ refreshTestMinutes=45,\ props=user=user_db;password=pass;server=none The placed the JDBC driver's JAR on the weblogic classpath. When I start weblogic, I get the following exception (below). Many thanks. -Lenny Reinstein, New York. - Mon Jan 28 07:43:14 EST 2002:I JDBC Pool Sleeping in createResource() Mon Jan 28 07:43:15 EST 2002:E JDBC Pool Failed to create connection pool mysqlConnPool weblogic.common.ResourceException: java.lang.NullPointerException at weblogic.jdbc.common.internal.ConnectionMOWrapper.init(ConnectionMOWrapper .java:42) at weblogic.jdbc.common.internal.ConnectionEnv.setConnection(ConnectionEnv.java :142) at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(Connection EnvFactory.ja va:108) at weblogic.common.internal.ResourceAllocator.makeResources(ResourceAllocator.j ava:771) at weblogic.common.internal.ResourceAllocator.init(ResourceAllocator.java:416 ) at weblogic.jdbc.common.internal.ConnectionPool.startup(ConnectionPool.java:330 ) at weblogic.jdbc.common.internal.JdbcInfo.initPools(JdbcInfo.java:117) at weblogic.jdbc.common.internal.JdbcInfo.startup(JdbcInfo.java:200) at weblogic.jdbc.common.internal.JdbcStartup.main(JdbcStartup.java:11) at java.lang.reflect.Method.invoke(Native Method) at weblogic.t3.srvr.StartupThread.runMain(StartupThread.java:219) at weblogic.t3.srvr.StartupThread.doWork(StartupThread.java:109) at weblogic.t3.srvr.PropertyExecuteThread.run(PropertyExecuteThread.java:62) - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Equivalent of an Oracle SEQUENCE in mysql?
Is there the equivalent of a sequence in mysql? Does anyone have an example of emulating sequences? Thanks Rich Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421 http://www.gretagmacbeth.com/ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php