[Typo3-dev] quoting SQL-identifiers

Karsten Dambekalns karsten at typo3.org
Sun May 8 18:50:46 CEST 2005


Hi.

Martin Kutschker wrote:
> Can it handle it this? :-)
> 
> SELECT
>  a.col1,b.col2 as x,func1(a.col3),vcol1,(SELECT vcol3 FROM t2 WHERE
> id=b.col2)
> FROM
>  a, y as b, (SELECT vcol1,vcol2 FROM TABLE t1 WHERE id=a.col4) as c
> WHERE
>  b.col5=func2(vcol2) AND
>  a.col6 IN SELECT vcol4 FROM t3

At least for the current DBAL extension: Almost, I'm pretty sure. Just drop
the AS for the table aliases for the time being (that's still not working).

Karsten
-- 
Karsten Dambekalns
TYPO3 Association - Active Member
http://association.typo3.org/




More information about the TYPO3-dev mailing list