Re: Re: Bug in MDB ???
| From: | Lorenzo Alberton | Date: | Fri, 12 Mar 2004 14:32:42 +0000 |
| Subject: | Re: Re: Bug in MDB ??? | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-11262@lists.php.net to get a copy of this message | ||
On Fri, 12 Mar 2004 14:01:47 +0100, Lukas Smith wrote:
> Anja Winkel wrote:
>> There is another thing I noticed working with MDB in cooperation
>> with Postgresql:
>>
>> Using the QueryTool I had difficulties to update my Postgres
>> database. It doesn´t like the updatequery which was created by
>> Query.php using the
>> tablename as prefix,
>> I changed the line
>> $values[] = "{$this->table}.$key=" . $this->_quote($aData); into
>> $values[] = "$key=" . $this->_quote($aData);
>>
>> So it worked fine for me and postgres.
I fixed that line. I don't have postgres installed, so I can't check
it myself. The "tablename.fieldname" syntax is SQL compliant,
so I wonder why it shouldn't work... anyway, it should be
unnecessary on updates, so I removed the tablename prefix.
Can you confirm that the latest CVS version works fine?
Thanks for your feedback.
Best regards,
Lorenzo