[TYPO3-german] (no subject)

[Andreas Otto]

Hallo Jesse,

Jesse Adler wrote:
> Nun soll die tt_address Tabelle zusätzliche Infos aus der static_countries
> bekommen. Dafür joine ich beide Tabellen über die Verknüpfung von
> tt_address.country und static_countries.uid.
> Das Problem ist nur, dass beim joinen das Feld uid aus der tt_address mit
> dem uid Feld der static_countries überschrieben wird.
> Wie kann ich das verhindern?

Ich habe das bei der Extension chc_forum mal vor ewigen Zeiten wie folgt
gelöst:

# Latest entries for chc_forum
#
temp.chc_forum_latest = COA
temp.chc_forum_latest {
        10 = CONTENT
        10.table = tx_chcforum_post
        10.select {
                #UID of the sysfolder containing the posts
                pidInList = 168
                orderBy = tx_chcforum_post.crdate DESC
                max = 3
                join = tx_chcforum_conference, fe_users
                where = tx_chcforum_conference.uid=tx_chcforum_post.conference_id
                andWhere = tx_chcforum_post.post_author = fe_users.uid
                selectFields =
tx_chcforum_post.crdate,tx_chcforum_post.category_id,tx_chcforum_post.conference_id,tx_chcforum_post.thread_id,tx_chcforum_post.post_author,tx_chcforum_post.post_author_name,tx_chcforum_post.post_author_email,tx_chcforum_post.post_subject,tx_chcforum_post.post_text,tx_chcforum_post.cache_parsed_text,tx_chcforum_conference.conference_pid,
fe_users.uid AS fuid, fe_users.username,tx_chcforum_post.uid
        }
        10.renderObj = TEXT
        10.renderObj {
                cObject = COA
                cObject {
                        10 = TEXT
                        10 {
                                field = post_subject
                                wrap = <strong>Thema:&nbsp;|<br />
                        }
                        20 = TEXT
                        20 {
                                field = username
                                wrap = |
                                crop  = 10 | ...
                        }
                        30 = TEXT
                        30{
                                field = crdate
                                strftime = %d.%m.%Y
                                wrap = &nbsp;vom&nbsp;|</strong><br />
                        }
                        40 = TEXT
                        40 {
                                field = cache_parsed_text
                                crop = 95
                                wrap = |...<br />
                                stripHtml = 1
                        }
                }
                wrap = <li>|</li>
                innerWrap = |<img
src="fileadmin/rauch-frei/images/arrow.redOnGray.right.gif" width="27"
height="13" alt="Pinboard: " title="Zum Pinboard:" />
                #UID of the page where the chc_forum plugin is installed
                typolink.parameter.insertData = 1
                typolink.parameter = {field:conference_pid}
                typolink.parameter.dataWrap = |#{field:uid}
                typolink.additionalParams.insertData = 1
                typolink.additionalParams =
&view=single_thread&cat_uid={field:category_id}&conf_uid={field:conference_id}&thread_uid={field:thread_id}
        }
        20 = TEXT
        20.value = Keine Forumposts
        20.if.isFalse.numRows < .10
        wrap = <div class="tx_chcforum_latest"><h2><img
src="fileadmin/rauch-frei/images/headline.latestPosts.gif" width="196"
height="35" alt="Aktuelle Postings" /></h2><ul>|</ul></div>
}


Liebe Grüße,
Andreas