[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