RE: bad table in fields list; mysql fails to update

ok, disregard this, i worked out what i did wrongly. > -Original Message- > From: > Sent: Sunday, March 10, 2002 2:38 AM > To: [EMAIL PROTECTED] > Subject: bad table in fields list; mysql fails to update > > > >Description: > When selecting from multiple recently added tables, mys

RE: xml

; To: [EMAIL PROTECTED] > Cc: James Cox; Javier Gonzalo Gloria Medina > Subject: Re: xml > > > On Sat, 2002-03-09 at 11:52, Jeremy Zawodny wrote: > > On Sat, Mar 09, 2002 at 05:37:28PM -, James Cox wrote: > > > Anyhow, > > > > > > Mysql can return data i

RE: xml

Well, I assume the server can do it too - - i haven't checked the C api lately on that. James > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 09, 2002 5:52 PM > To: James Cox > Cc: [EMAIL PROTECTED]; Javier Gonzalo Glo

RE: xml

Anyhow, Mysql can return data in XML. > -Original Message- > From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] > Sent: Saturday, March 09, 2002 5:29 PM > To: Javier Gonzalo Gloria Medina > Cc: [EMAIL PROTECTED] > Subject: Re: xml > > > On Sat, Mar 09, 2002 at 09:21:35AM -0800, Javier G

RE: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

10.06. > > Plus, PHP/4.1.3 is not a production version so are you sure you > are looking > at the correct box? > > > > > > Lee. > > > - Original Message - > From: "James Cox" <[EMAIL PROTECTED]> > To: "Mysql" <[E

FW: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

PHP/4.1.3-dev Connection closed by foreign host. Interesting, a server powered by the product it's competing against... -- James Cox :: [EMAIL PROTECTED] :: Landonize It! http://landonize.it/ Was I helpful? http://www.amazon.co.uk/exec/obidos/wish

Problem with MySQL version 4.0.1

james -- James Cox :: [EMAIL PROTECTED] :: Landonize It! http://landonize.it/ Was I helpful? http://www.amazon.co.uk/exec/obidos/wishlist/23IVGHQ61RJGO/ - Before posting, please check: http://www.mysql.com/manual.php (the m

Problem with MySQL version 4.0.1

james -- James Cox :: [EMAIL PROTECTED] :: Landonize It! http://landonize.it/ Was I helpful? http://www.amazon.co.uk/exec/obidos/wishlist/23IVGHQ61RJGO/ - Before posting, please check: http://www.mysql.com/manual.php (the m

Bug (?) in mysqld start?

pened in the past, except to note that there were mysql binaries and data scattered all over the file system. Any help would be appreciated in discerning what the problem is! Regards, and thanks, James Cox database,sql,query,table -- James Cox :: [EMAIL PROTECTED] Please CC me when replying t

RE: As plain as the nose on your face

sometimes things can be a little missleading, more so when you > are used to something meaning 1 thing and you find out it means > another with > mysql. > > Please bare with me if I am slow on the uptake as I have tried to > explain I > am struggling to get my head around the basics.

RE: As plain as the nose on your face

try ./mysqladmin -u root -p create bathjobs and FYI, ./mysqladmin --help Thank you. > -Original Message- > From: Matthew Darcy [mailto:[EMAIL PROTECTED]] > Sent: 20 December 2001 03:38 PM > To: [EMAIL PROTECTED] > Subject: As plain as the nose on your face > > > I have set the root p

RE: [PHP] Re: Returning html code-PROB SOLVED

Dumb question, but why is that? I have stripslashes on everything that goes into the database, (i also addslashes on everything, so people can't break the database, too), why is it unecessary? and what might it break? Thanks, Jame

Strange error message

his? Thanks, James Cox . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . James Cox :: Senior Support Engineer Wherewithal, Inc. e: [EMAIL PROTECTED] Wherewithal.

How Long is TEXT?

Hi, after reading the excellent docs, I was just a little confused as to the actual length of the TEXT datatypes. Are they really as long as you like? And does anyone have any tips for indexing (searching) them? Thanks, James Cox

Running mySQL on a drive other than root

reinstall it... but try as I might, I can't seem to get the thing to run. any suggestions? Thanks, James Cox

Re: GROUP BY behaviour.. help needed..

Hi Rick, I actually fixed that problem - it was due to the fact that the GROUP BY and ORDER By statement were mixed up :( still don't understand groups well, though :( Thanks, James Cox - Original Message - From: "Rick Emery" <[EMAIL PROTECTED]> To: "

Help with SQL Statement

'%varRef%' GROUP BY icaref, disb, receipt-payment ORDER BY date MYSQL tells me that there is invalid use of the groups function. I am trying to get the sum of balance-reciept , with icaref as being the common identifier to group them by. Help ap

GROUP BY behaviour.. help needed..

ORDER BY date GROUP BY disb, receipt-payment why does it not work? and can someone help me understand groups better ? Thanks, James Cox - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Foxes Me ???

are you sure the password is set properly in the mysql.user table? did you flush privileges after setting it? HTH, James - Original Message - From: "Donald Korth" <[EMAIL PROTECTED]> To: "mysql@lists. mysql. com" <[EMAIL PROTECTED]> Sent: Friday, February 23, 2001 7:40 PM Subject: Foxe