CLIENT?

[bonfils]

Hi

I'm running MySQL on IIS on a Win2000 Server (probably a bad idea, but
that's the stuff I have to work with).
Yesterday, a script that ran without problems for months suddenly stopped
working on my server.
I identified the problem: Suddenly, MySQL has decided that CLIENT is a
reserved word.
The same script is still working fine on my local machine (also IIS on a Wín
2000 Server).
Anyone have any idea what could be wrong - and how to fix it?
Thanks in advance.

--
Kim B.
http://kim.bonfils.com

[Aggro]

bonfils wrote:

Hi

I'm running MySQL on IIS on a Win2000 Server (probably a bad idea, but
that's the stuff I have to work with).
Yesterday, a script that ran without problems for months suddenly stopped
working on my server.
I identified the problem: Suddenly, MySQL has decided that CLIENT is a
reserved word.
The same script is still working fine on my local machine (also IIS on a Wín
2000 Server).
Anyone have any idea what could be wrong - and how to fix it?
Thanks in advance.

Where are you using client? In a table name or similar? If I remember
correctly you need to put it inside ' characters when you do queries.

select * from 'client';

[Aggro]

bonfils wrote:

Hi

I'm running MySQL on IIS on a Win2000 Server (probably a bad idea, but
that's the stuff I have to work with).
Yesterday, a script that ran without problems for months suddenly stopped
working on my server.
I identified the problem: Suddenly, MySQL has decided that CLIENT is a
reserved word.
The same script is still working fine on my local machine (also IIS on a Wín
2000 Server).
Anyone have any idea what could be wrong - and how to fix it?
Thanks in advance.

Where are you using client? In a table name or similar? If I remember
correctly you need to put it inside ' characters when you do queries.

select * from 'client';

[Aggro]

bonfils wrote:

Hi

I'm running MySQL on IIS on a Win2000 Server (probably a bad idea, but
that's the stuff I have to work with).
Yesterday, a script that ran without problems for months suddenly stopped
working on my server.
I identified the problem: Suddenly, MySQL has decided that CLIENT is a
reserved word.
The same script is still working fine on my local machine (also IIS on a Wín
2000 Server).
Anyone have any idea what could be wrong - and how to fix it?
Thanks in advance.

Where are you using client? In a table name or similar? If I remember
correctly you need to put it inside ' characters when you do queries.

select * from 'client';