RE: [fw-db] Statement containing both parentheses and AS clause

Thank you Bill for your timely response… And for your great work in ZF – I am sure we all here appreciate it J

 

My question is: Your last sentence, saying “it is looking for AS before checking if it looks like an expression” – Can we expect that to be fixed in the next release of ZF? Thanks again…

 

Shehi

 

From: Bill Karwin [mailto:bill@karwin.com]
Sent: Friday, May 28, 2010 7:35 PM
To: fw-db@lists.zend.com
Subject: Re: [fw-db] Statement containing both parentheses and AS clause

 

I wrote this code pre-ZF 1.0, to try to accommodate people who wanted to write "column AS alias" instead of array("alias"=>"column").  

 

My recollection is that it was to preserve backward compatibility with earlier preview releases of ZF.

 

My apologies that I didn't anticipate expressions containing an "AS" keyword other than to introduce an alias.  The mission of ZF as I was told was to make development very simple and easy in the 80% case, while allowing for the other 20% but perhaps not as conveniently.

 

Regards,

Bill Karwin

 

On May 28, 2010, at 9:15 AM, Hector Virgen wrote:

 

However, you are right about the auto-detection of expressions. I'm looking at ZF 1.8 source (sorry, don't have a more recent ZF on me at the moment) and Zend_Db_Select#_tableCols() is looking for "AS" before checking if it looks like an expression: