Forum

HomeHomeCoreCoreSamples and oth...Samples and oth...Problems with the Roles SampleProblems with the Roles Sample
Previous
 
Next
New Post
11/3/2008 3:47 PM
 

Hi:
Sorry, can't get it to work at all.  In debug I see:

Original
Select roles.roleid, rolename,ispublic,autoassignment, description from roles
--join userroles on roles.roleid = userroles.roleid
where portalid =
{IIF,"'[frmSelectPortalRole]' = ''","[*portalid]","[frmSelectPortalRole]"}
[OrderBy]


Actual

Select roles.roleid, rolename,ispublic,autoassignment, description from roles
--join userroles on roles.roleid = userroles.roleid
where portalid =

~~~~~~~~~~~~~~~~~~~~~

I also see several querys that are looking for PortalID=NULL and I have no null portalID's.

~~~~~~~~~~~~~~~~~~~

Are the Object Owner and Object Qualifier syntax going to be added?  These seem to work on the users example although they don't work in administration and click Execute.

 

Previous
 
Next
HomeHomeCoreCoreSamples and oth...Samples and oth...Problems with the Roles SampleProblems with the Roles Sample


 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seattle, WA • info@openwebstudio.com

Bookmark & Share Bookmark and Share