[TYPO3-UG Denmark] Brug af WHERE i TCA

[Dycon - Lars Dyhr]

Hej Jeppe

Start med AND (og undlad WHERE).
Se ca. s. 90 i TYPO3 Core Api.

Med venlig hilsen
Lars Dyhr


Jeppe Donslund wrote:
> 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/> 
> 
>  
>  
>  
> _______________________________________________
> TYPO3-UG-denmark mailing list
> TYPO3-UG-denmark at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-ug-denmark
>