[TYPO3-UG Denmark] Brug af WHERE i TCA

[Jeppe Donslund]

Hvordan bruges Where i TCA?
 
Hvis jeg skriver således:
 
"foreign_table_where" => "WHERE LOCATE(',###THIS_UID###,',CONCAT(',',tx_wmpfvideos_videos.crossreferences,',')) > 0 ORDER BY tx_wmpfvideos_videos.uid"
 
får jeg følgende fejl:
 
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/www.patienterfaringer.dk/www/t3lib/class.t3lib_db.php on line 801
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOCATE(',188,',CONCAT(',',tx_wmpfvideos_videos.crossreferences,',')) > 0 ORDE' at line 5 This may indicate a table defined in tables.php is not existing in the database!
 
 
Med venlig hilsen

Jeppe Donslund
Programmør

Tlf. dir. 7633 8824

Webmasters
Agtrupvej 51
6000 Kolding

Tlf. 7550 8877
jd at webmasters.dk <mailto:jd at webmasters.dk> 
www.webmasters.dk <http://www.webmasters.dk/>