Hi Todd,
I fixed this tonight, it required a change in the stored procedure script and in the mojoPortal.Data.dll . I can send you a zip if you like. I'm going to commit the changes to svn right now but the current svn version has a partial implementation of the search feature I'm working on. It doesn't work yet. If you compeile the svn version though, you should be able to just run the stored proc script and replace the mojoPortal.Data.dll in your site.
There is also a change in the Admin/Roles.ascx to make it show the display name of the role instead of the role name. The role name never changes, but the display name can be changed.
I also fixed the calendar day view problem mentioned in a different post, that fix is also just in the stored procs and data dll
A couple other bug fixes for the stored procs are coming as soon as I get the patches from Dean for the other 2 bugs he found.
This site is also hosted at grokthis but uses the MySQL db otherwise I would have caught these bugs sooner
Thanks,
Joe