Zum Inhalt springen

tt_address - Adressen einer bestimmten Gruppe auslesen

Erstellt am 23. Mai 2012 · 1 Antwort · letzte Antwort am 23. Mai 2012

Tags: tt_address, Datenbank, Frage

jochla ·

ich muss mit TypoScript die Tabelle tt_address_group_mm ansprechen, um so Adressen auszulesen, die einer bestimmten Adressgruppe zugeordnet sind. Dabei bekomme ich diesen Fehler:
---
There is no entry in the $TCA array for the table "tt_address_group_mm".
This means that the function enableFields() is called with an invalid table name as argument.
---

So sieht mein SELECT aus:

table = tt_address_group_mm
select {
selectField = gender,title,name,phone,email,image,addressgroup
pidInList = 105
join = tt_address_group INNER JOIN (tt_address INNER JOIN tt_address_group_mm ON tt_address.uid = tt_address_group_mm.uid_local) ON tt_address_group.uid = tt_address_group_mm.uid_foreign
where = tt_address_group_mm.uid_foreign = '1'
}

Wie kann ich das Problem lösen?

Gruß, Johannes.

LuP ·

Hallo,

table = tt_address
select{
    selectFields = gender,title,name,phone,email,image
    pidInList = 105
    andWhere = tt_address_group.uid = 1
    join = tt_address_group ON 1=1 JOIN tt_address_group_mm ON (tt_address_group_mm.uid_local=tt_address.uid AND tt_address_group_mm.uid_foreign=tt_address_group.uid)
}

VG,
LuP