[TYPO3] select.andWhere from fe_users table. How ?

[Rob De Vries]

Hey girls and boy's,

I have a GPvar in my url (usc=1) where usc is the uid of a fe_user. this
url is generated with the dmail ext to end everyone in a mailinglist a
unique url that will send them to a form page (mailformplus) so we know
who filled out what in a form.

Now, we also would like to add a hidden filed to the form, what will
state the usergroup of that person: normaly not that difficult:
select.andWhere.

BUT as the tsref state : NOTE: Only tables allowed are “pages” or tables
prefixed with one of these: “tt_”, “tx_”, “ttx_”, “fe_”, “user_”

bummer ! I need the fe_users tabel.


so how do I solve this?
this code is what I have, but not working:

plugin.tx_thmailformplus_pi1.markers.grp = CONTENT
plugin.tx_thmailformplus_pi1.markers.grp {
	
	table = fe_users
	
	select.pidInList = 32
	select.andWhere.cObject = COA
	select.andWhere.cObject {
	
		10 = TEXT
		10.data = GPvar:usc
		10.noTrimWrap = | uid='|'|
		}
}


tnx

Rob


-- 
------------------------------------------------------------
web : http://www.rob-ot.be
skype : rob-ot
------------------------------------------------------------
[O_o] -- Don't feed the rob-ot