Re: DB_DataObject and backticks
| From: | Joseph Szobody | Date: | Wed, 08 Dec 2004 13:22:50 +0000 |
| Subject: | Re: DB_DataObject and backticks | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-16113@lists.php.net to get a copy of this message | ||
Thanks much Justin, exactly what I needed.
Joseph
"Justin Patrin" <papercrane@gmail.com> wrote in message
news:432beae04120800165a6b3dbb@mail.gmail.com...
> On Tue, 7 Dec 2004 22:53:22 -0600, Joseph Szobody
> <php-newsgroup@signaturetechstudio.com> wrote:
>> Folks,
>>
>> I have a table named 'group' which is of course a reserved keyword. I was
>> really hoping that DB_DataObject would use backticks so that it wouldn't
>> be
>> a problem, but evidently this is not the case.
>>
>> Any reason why not?
>>
>
> First of all, because not all DBMS use backticks. Second because some
> mysql versions don't even support the backticks. That said, DB
> supports these through quoteIdentifier() and DB_DataObject supports it
> as well (I should know, I prepared the patches for both). Just put
> quote_identifiers=1 in your DataObject.ini.
>
> --
> Justin Patrin