[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)
Regards,
--
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