[TYPO3-dev] t3lib_TCEmain: quotes around column names

Martin Kutschker masi-no at spam-typo3.org
Wed Jun 10 14:04:33 CEST 2009


Christian Kartnig schrieb:
> Hello!
> 
> I came across an issue with copying records in t3lib_TCEmain: An
> extension uses the reserved keyword 'sql' as a column name, which throws
> an sql error when copying records in the list module (with mySQL5).
> 
> Maybe it would be a good idea to quote all column names with backticks
> to avoid such problems. What do you think?

Yes. Though I'd use ANSI SQL quotes (that is sinqle quotes).

Masi




More information about the TYPO3-dev mailing list