[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