[TYPO3-UG Denmark] Brug af WHERE i TCA

[Jeppe Donslund]

Her er koden fra min TCA, hvis det hjælper ;-)


		"crossreferences" => Array (		
			"exclude" => 1,		
			"label" => "LLL:EXT:wm_pf_videos/locallang_db.xml:tx_wmpfvideos_videos.crossreferences",		
			"config" => Array (
				"type" => "select",	
				'foreign_table' => 'tx_wmpfvideos_videos v1 INNER JOIN tx_wmpfvideos_persons p1 ON v1.person = p1.uid INNER JOIN tx_wmpfvideos_persons p2 ON p1.uid LIKE p2.related_to INNER JOIN tx_wmpfvideos_videos v2 ON p2.uid = v2.person',
				'foreign_table_where' => 'v1.uid = ###THIS_UID###',
				"size" => 10,	
				"minitems" => 0,
				"maxitems" => 100,
			)
		),
	),

 


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: 30. august 2007 10:02
Til: TYPO3 Usergroup Denmark
Emne: Re: [TYPO3-UG Denmark] Brug af WHERE i TCA

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