[TYPO3-UG Denmark] Brug af WHERE i TCA

[Dycon - Lars Dyhr]

Hej Jeppe

Jeg mener godt at du kan putte dine joins ind i foreign_table værdien:
'foreign_table' => 'Videoer v1 INNER JOIN Personer p1 ON v1.person = 
p1.uid INNER JOIN Personer p2 ON p1.uid = p2.related_to INNER JOIN 
Videoer v2 ON p2.uid = v2.person',
'foreign_table_where' => 'v1.uid = 1',

Jeg er dog ikke helt sikker, men det er vel et forsøg værd.

Med venlig hilsen
Lars Dyhr


Jeppe Donslund wrote:
> Hej Lars
> 
> Er der overhovedet ingen mulighed for at komme før AND?
> 
> Jeg er nok på vej ud i noget ala dette:
> 
> SELECT v2.uid, v2.title, v2.person
> FROM Videoer v1
> INNER JOIN Personer p1 ON v1.person = p1.uid
> INNER JOIN Personer p2 ON p1.uid = p2.related_to
> INNER JOIN Videoer v2 ON p2.uid = v2.person
> WHERE v1.uid = 1 
> 
> 
> Med venlig hilsen
> 
> Jeppe Donslund
> Programmør
> 
> Tlf. dir. 7633 8824
> 
> Webmasters
> Agtrupvej 51
> 6000 Kolding
> 
> Tlf. 7550 8877
> jd at webmasters.dk
> www.webmasters.dk
> 
>  
>  
> 
> -----Oprindelig meddelelse-----
> Fra: typo3-ug-denmark-bounces at lists.netfielders.de [mailto:typo3-ug-denmark-bounces at lists.netfielders.de] På vegne af Dycon - Lars Dyhr
> Sendt: 23. august 2007 14:57
> Til: TYPO3 Usergroup Denmark
> Emne: Re: [TYPO3-UG Denmark] Brug af WHERE i TCA
> 
> 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
>>
> _______________________________________________
> TYPO3-UG-denmark mailing list
> TYPO3-UG-denmark at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-ug-denmark
> _______________________________________________
> TYPO3-UG-denmark mailing list
> TYPO3-UG-denmark at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-ug-denmark
>