This answer from one of the dumber Zopesters at DC... caveat emptor...
In particular, I like the ability to validate against my db. However, I'm wondering if there's some clever method of overriding the SQL methods used by UserDb, short of 'cut&paste' code reuse to make myUserDb. See, I've already got tables & fields with usernames and passwords, but I need different queries to access them. Ideally, I'd like to overide a particular _instances_ methods - so, for example, I can have users in different Teams, and return only the users that exist in a particular team. Any bright ideas out there? Is this another something obvious that I failed to grasp, any you're all now laughing at me?
<untested> What about: /top/UserDB /Team1Stuff /Team2Stuff /Team3Stuff Team1Stuff folder has a property: team_name = 'Team1' Team2Stuff folder has a property: team_name = 'Team2' Team3Stuff folder has a property: team_name = 'Team3' Then you tweak the SQL methods used by UserDB to include a test... WHERE {existing stuff} AND team = <!--#sqlvar team_name--> All of the interesting stuff could still go in /top and be acquired into each Team folder. We've done that in a number of cases... </untested> As I look at this though, it sounds more like you might want to use roles... Make Team1, Team2, and Team3 roles and assign them as such in the user table. Then you can use organic security/permissions... What did you want to do with the list of Team1 members? --Rob
Rob Page wrote: <Rob's excellent suggestion for my simple-minded question deleted> This is actually my plan - I've already got the folders with appropriate properties, being used by other SQL queries to generate various team specific pages. Now that I've perused the UserDb source code a little - "Gee, look Ross, right there under manage_properties - you can edit all the SQL queries!" <FX> Ross goes and clicks on the properties tag </fx> I'll go be quiet for a while now, merrily using all these wonderful toys DC has provided. Ross P.S. Thanks DC!! -- Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005
participants (2)
-
Rob Page -
Ross J. Reedstrom