Hi All,

I am currently looking to use an object of this type to designate users in my class.  Getting the users is not much of a problem; however what is a bit of a problem is how I want to use the user list in my select element: I'd like to show user's firstname and lastname BUT store only the users login (iow use the .value and .text assignment seperately in the generated select list).  This new class would normally appear multiple times in another class (similar to a Comment object but with selectable users).

Has anyone done something similar, or got any idea's on an alternative?

[current query used in the object:
select firstname.value || ' ' || lastname.value from BaseObject obj, StringProperty firstname, StringProperty lastname where obj.className='XWiki.XWikiUsers' and firstname.id.id=obj.id and lastname.id.id=obj.id and firstname.name='first_name' and lastname.name='last_name' and firstname.value <> 'XWiki' order by firstname.value

]

Brandon Esbach
Software Engineer
M/A-Com Eurotec Operations
LoughMahon Technology Park,
Skehard Road,
Blackrock,
Cork, Ireland
Tel  +353 21 4808305