Re: Native Error 1064 with PEAR DB and mysql
| From: | Pierre-Alain Joye | Date: | Fri, 20 Sep 2002 10:43:08 +0000 |
| Subject: | Re: Native Error 1064 with PEAR DB and mysql | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-2357@lists.php.net to get a copy of this message | ||
On Fri, 20 Sep 2002 12:39:38 +0200 (MET DST)
Henrik Karlsson <z95kahe@mtek.chalmers.se> wrote:
> On Fri, 20 Sep 2002, Stanislav Okhvat wrote:
>
> > Do you really have to quote table "person" in the SQL statement. I
> > don't think this is necessary and phpMyAdmin could handle the issue
> > while PEAR doesn't. Try it without the quotes.
>
> I've tried that but it doesnät help. The error is still there:
Maybe not the source of this error, but, that s cleaner to use personID or personId (see your db for
right case) than mixes the both.
As far I remember, mysql is not case sensitive under win32 (in fact, do not remember it s valid for
db/tables or fields :) )
hth
pa