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: |<br />
}
20 = TEXT
20 {
field = username
wrap = |
crop = 10 | ...
}
30 = TEXT
30{
field = crdate
strftime = %d.%m.%Y
wrap = vom |</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
_______________________________________________
TYPO3-german mailing list
TYPO3-german@lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-german
