[Typo3-dev] quoting SQL-identifiers

Rainer Kuhn kuhn at punkt.de
Mon Apr 25 13:21:39 CEST 2005


Martin Kutschker wrote:
> 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

That's exactly what I did in my example project. But this doesn't help for 
tablenames (of a given database) using reserved words, does it?

Rainer




More information about the TYPO3-dev mailing list