[Typo3-dev] quoting SQL-identifiers
Martin Kutschker
martin.kutschker at no5pam.blackbox.net
Mon May 9 09:38:35 CEST 2005
"Karsten Dambekalns" <karsten at typo3.org> schrieb im Newsbeitrag
news:mailman.1.1115571040.14186.typo3-dev at lists.netfielders.de...
> 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).
Cool. Looking forward to alias support :-)
I quite like this SQL-feature.
Masi
More information about the TYPO3-dev
mailing list