[TYPO3] Database relation to a costum table

[Manuel Rego Casasnovas]

Hello,

On Sun, 2008-06-29 at 11:35 +0200, Jeppe Donslund wrote:
> I am trying to make a database relation to a costum table, 
> static_countries i an extension.
> 
> The TCA is like this:
> 
> "country" => Array (		
> 			"exclude" => 1,		
> 			"label" => 
> "LLL:EXT:jd_drinks/locallang_db.xml:tx_jddrinks_drinks.country",		
> 			"config" => Array (
> 				"type" => "select",	
> 				"foreign_table" => "static_countries ",	
                                                                      ^
> 				"foreign_table_where" => "ORDER BY static_countries.uid",	
> 				"size" => 1,	
> 				"minitems" => 0,
> 				"maxitems" => 1,
> 			)
> 		),
> 

This white space after "static_countries" is causing that error. You should use a line like:
                        "foreign_table" => "static_countries",

I hope this helps ;-)

Best regards,
   Rego

-- 
Manuel Rego Casasnovas
Computer Science Engineer
mailto:mrego at igalia.com
Tel: +34 986 10 76 10
Fax: +34 981 91 39 49
Igalia - http://www.igalia.com