[TYPO3] Author of page

Jan Bidner jan.bidner at ladok.umu.se
Thu Mar 2 14:58:33 CET 2006

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 Bidner                                          Tel: +46(0)90 - 786 66
31, 58 59 
Ladokenheten                                     Fax: +46(0)90 - 786 69 91
Umeå University                                  www:
SE - 90187 Umeå                                 AIM: jnlad2
"Det enda vi vet om framtiden är att 
det kommer att förändras snabbare än 

- Sveriges Näringslivsminister, 1997


More information about the TYPO3-english mailing list