andy toenz wrote:
Hi Chris,
1. I can't add ZSQL Methods because I've only one user which is the 'emergency'-user. So I'm not able to add a Method X Error Type: EmergencyUserCannotOwn X Error Value: Objects cannot be owned by the emergency user
I don't think that's a SUF problem. Why have you only got access to the emergency user? Are you trying to use SUF as your top-level user folder? If so, get the ZSQL methods working before you delete the old user folder ;-)
2. When I define a ZSQL Method e.g. X Id: get_users_from_db X Query Template: X select m_admin_uid, m_admin_pwd, rules from user;
How can I use this ZSQL method (get_users_from_db) together with SUF ?
You should read the readme.txt file in the SUF distribution. The method needs to be called 'getUserDetails', not 'get_users_from_db'. It also needs to take a parameter called 'name' then, the select would be something like: SELECT m_admin_uid as NAME, m_admin_pwd as PASSWORD, ROLE FROM user WHERE m_admin_uid=<dtml-sqlvar name type="string"> Now, you'll notice that you probably don't have a column called 'ROLE'. What I do is have a seperate table mapping user names to roles, something like: Table:roles NAME ROLE chris Manager andy Manager andy Member Do you see what I mean? Then the select becomes: SELECT m_admin_uid as NAME, m_admin_pwd as PASSWORD, ROLE FROM user LEFT JOIN roles ON user.m_admin_uid=roles.NAME WHERE m_admin_uid=<dtml-sqlvar name type="string"> cheers, Chris