[TYPO3-english] wfqbe: how to select select all uid's from csv-field

Mauro Lorenzutti mauro.lorenzutti at webformat.com
Mon Aug 16 10:25:06 CEST 2010

Hi Caspar,

I think that the problem is in the following statement:

t_news_cat.uid = tx_farmersupport_pref.newscat

The SQL is not able to make a join wich csv values. Could you rewrite 
the query with an IN statement? Something like:

t_news_cat.uid IN (tx_farmersupport_pref.newscat)


Mauro Lorenzutti

CTO / Software Architect
mauro.lorenzutti at webformat.com
Tel.   +39-0427-926.389

WEBFORMAT srl -- www.webformat.com
Via S. Francesco d'Assisi, 6 -- 20122 MILANO
Corte Europa, 12 - 33097 Spilimbergo (PORDENONE)

TYPO3 Certified Integrator

More information about the TYPO3-english mailing list