[TYPO3] Author of page

[Allan Jacobsen]

You could just use the 'responsible' extension.

Best regards/MVH
Allan Jacobsen
Infrastruktur, Dansk Tipstjeneste A/S
Korsdalsvej 135, 2605 Brøndby

-----Oprindelig meddelelse-----
Fra: typo3-english-bounces at lists.netfielders.de [mailto:typo3-english-bounces at lists.netfielders.de] På vegne af Jan Bidner
Sendt: 2. marts 2006 14:59
Til: typo3-english at lists.netfielders.de
Emne: [TYPO3] Author of page

Beloved list,
 
I'm trying to automatize the output of who's responsible for the page.
I have a SELECT-issue in my typoscripting that I'd love to have sorted out.
My SETUP code goes like this:
 
 
# Page Author:
subparts.pageauthor = TEXT
subparts.pageauthor {
data= page:perms_userid
if.isTrue.data = page:perms_userid
wrap = Responsible for page:  |
}
 
In my template I added the tag:
<div id="pageauthor"></div>
 
This outputs in the f.ex: "Responsible for page: 2"  (where the number is
selected from the table "PAGES" and the column "perms_userid" which relates
to "BE_USERS" table who has owner permissions for the page.)
What I want to do is to do a SELECT query to get the value of the column
realName from table "BE_users" (like this: SELECT 'realName' FROM 'BE_USERS'
WHERE 'BE_USERS.uid'='PAGES.perms_userid').
Anyone with a suggestion how to do this in typoscript?
 
All suggestions are appreciated!
/Jan

----------------------------------------------------------------------------
----------
Jan Bidner                                          Tel: +46(0)90 - 786 66
31, 58 59 
Ladokenheten                                     Fax: +46(0)90 - 786 69 91
Umeå University                                  www:
www.umu.se/ladokenheten
SE - 90187 Umeå                                 AIM: jnlad2
----------------------------------------------------------------------------
----------
"Det enda vi vet om framtiden är att 
det kommer att förändras snabbare än 
historien."

- Sveriges Näringslivsminister, 1997

 
_______________________________________________
TYPO3-english mailing list
TYPO3-english at lists.netfielders.de
http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english