[TYPO3] Author of page [Solved]

[Jan Bidner]

> You could just use the 'responsible' extension.
> 
> Best regards/MVH
> Allan Jacobsen
> Infrastruktur, Dansk Tipstjeneste A/S
> Korsdalsvej 135, 2605 Br?ndby

Thnxs a lot! :)

----------------------------------------------------------------------------
---------
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


> 
> -----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