Re: Native Error 1064 with PEAR DB and mysql

On Fri, 20 Sep 2002 12:39:38 +0200 (MET DST)
Henrik Karlsson <z95kahe@xxxxxxxxxxxxxxxx> 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

-- 
PEAR General Mailing List (http://pear.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php