[Typo3-UG UK] getting several values from tables and keeping them somewhere safe

[joachim rinck]

dear mailing list,

i want to use the CONTENT object to fetch some values from the database and 
use them to fill in marks in a template. the following snippet does the 
query and gives the description field from the user_program table:

page.20 = CONTENT
page.20.renderObj = TEXT
page.20.table = user_program
page.20.select.pidInList = 10
page.20.select.selectFields = title, LEFT(title, 1) hoofdletter, description
page.20.renderObj.field.1=title
page.20.renderObj.field.2=hoofdletter
page.20.renderObj.field.3=description

title and hoofdletter are of course overwritten by description. 

if anyone on the list could point me to information as to how i can store 
those values for further use, that would be very much appreciated, thanks a 
lot:)

best regards, 
joachim rinck
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.netfielders.de/pipermail/typo3-uk/attachments/20050523/6c9a897e/attachment.htm