[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