RE: MYSQL 4.0

Jeremy, Would you mind sharing how many machines 'half your servers' might be, what type of work are they doing and how long have they been up for / how stable would you consider them to be? Thanks, Greg -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent:

RE: stupid error, please kick me (and send me a solution)

It would also appear you are missing a closing ) at the end of the '$query=...' line. You have two opening backets and only one closing. Greg -Original Message- From: Bruce Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 4 June 2002 7:50 To: [EMAIL PROTECTED]; mysql; php-general

RE: Stupid - I just can't get it (NOT IN or NOT EXISTS)

I think you need to read the page you have refered to again. It specifically says that sub-selects are still scheduled for implementation and the examples given are ways of rewriting subselects to achieve the same result using alternative methods i.e. using joins. The second example on their

RE: ASP and MySQL

Loretta, Your syntax appears to be correct. Below is an example of what we do (with some bits cut out) and it works. strSQL = INSERT INTO tblTempConsolidation SET _ customerId = intCustomerId ,

RE: Is The MySQL Mailing List On Crack?

I'm getting it and several others have as well !!! -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 13 February 2002 11:45 To: [EMAIL PROTECTED] Subject: Is The MySQL Mailing List On Crack? I'm getting duplicate messages separated by several

RE: running MySQL on WinXP

Haven't tried it myself, but can't see why it shouldn't. How about you try telling us the process you have been through so far and any messages / errors that you may be getting. -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Monday, 10 December 2001 5:16 To:

RE: Viewing table data in a webpage using ASP

Nick, If you are able to add records, then your connection string is correct, at least for viewing the table. Need to see the code where you actually loop through and display each record. Greg -Original Message- From: Nick Boldt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 4

RE: MySql on redhat 6.x and above

Howdy, I'm running MySQL 3.23.43 on Redhat 7.1 and an older version of MySQL 3.22.something on Redhat 6.2. Download and install from the RPM's and it works like a charm. I have never had a problem. One day when it is working a little harder, I shall look at recompiling to optimise, but so far,

SELECT COUNT(*) question ...

Howdy all, I have two tables as described further down below ... I use the following query to get the data I need ... sql = SELECT tblTempConsolidation.*, tblCustomer.customerLibrary FROM tblCustomer, tblTempConsolidation WHERE tblCustomer.customerId = tblTempConsolidation.customerId AND

RE: Locked out of mySQL.

In the manual First off, have you tried the following ... 6.15 Causes of Access denied Errors If you encounter Access denied errors when you try to connect to the MySQL server, the list below indicates some courses of action you can take to correct the problem: After installing

RE: rank newbie looking for SQL forum

I haven't participated, but the site at www.sqlteam.com looks useful and does have a number of forums there. HTH, G. -Original Message- From: Jason Witherspoon [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 January 2001 8:14 To: [EMAIL PROTECTED] Subject: rank newbie looking for

RE: ORDER BY command

Hmmm, you seem to have things a little backwards as ASCENDING should be the default order. However, as per the manual, the following will do it SELECT * FROM tbl_name ORDER BY col_name ASC To sort in the opposite order SELECT * FROM tbl_name ORDER BY col_name DESC Regards, Greg