When viewing Users in User Directory, I would like to display the
userstatus.
User Status is strored in farUser
So I thought I could pass in my own query - but memberStatus is displaying
as '-- not available --'
Is there a way to make this happen?
Farcr 6.0
<ft:objectadmin
qRecordSet="#qryUserProfile#"
typename="dmProfile"
title="Member Administration"
columnList="username,membershipnumber,firstname,lastname,department,memberStatus"
sortableColumns="username,department"
lFilterFields="username,firstname,lastname,department"
sqlorderby="username asc"
lCustomActions="Change password"
lButtons="#lButtons#"
/>
<cfquery name="qryUserProfile" datasource="#APPLICATION.dsn#">
SELECT dmProfile.*, farUser.userstatus as memberStatus
FROM dmProfile, farUser
where userName = CONCAT(userID, '_CLIENTUD')
order by username
</cfquery>
--
AJ Mercer
http://webonix.net
http://twitter.com/webonix
--
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: [email protected]
To unsubscribe, email: [email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
