Recently Viewed...
DNN Modules
SnowCovered Top Sellers

Document Exchange 5

Edit documents directly on your server. The premier document management solution for DotNetNuke (DNN). Index contents of documents. Share documents across your portal and avoid duplicates. Revised and flexible UI. Extensible architecture.

Opt In Email 4.0

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

Live Content v1.6 :: Web 2.0

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

Catalyst By DrNuke

The Catalyst skins are professionally designed, coded and packaged by a team of DotNetNuke experts. The skins are available in 12 great colours. This skin is easily customisable with our unique DrNuke EasyMod technology. Try our demo!

Dynamic Forms 2.7

In this day and age, knowing as much detailed information as possible about your customer, prospect or web site user is essential. Thankfully, the new 'Dynamics Forms' module from Data Springs, makes it easier than ever to segment your data collection efforts.

Ultra Video Gallery 2.4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

Ultra Media Gallery 5.4

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

Data Springs Collection 2.0 (20+ Modules)

Capture your users attention, enrich your site with multimedia flash, and create and opt in distribution list for your DNN site. These are just a few of the many features the Data Springs Module Collection can provide you.

XMod 5.1

Version 5 of the perennial best-selling tool for creating data-based solutions in DNN without custom programming. This version focuses on greater flexibility, expandability, and ease-of-use.

Minimalist by Evan O'Neil - ALL NEW !

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

    |   Register   |   Sunday, November 23, 2008   
Data Springs Product Forums...
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
Subject: Sql Completion Event- Removing Someone From A DNN Security Role
Prev Next
You are not authorized to post a reply.

Author Messages
Timothy
Posts:17
wading in the water
wading in the water
06/24/2008 10:11 AM  

 

 

 

SQL Completion Events -
Removing a User from a DNN security role

I have a dynamic registration all set up on my DotNetNuke site. I have question fields setup and some completion events.

I currently have it set up so that when a user enters a radio field a certain way they become a basic registered user and the completion event is set up so that they become a member of the DNN Security Role called Basic Site User.

Then when basic users update their registration they are asked if they want to the call in advance user or not. When they choose to become an advance user they are added to the DNN Security role called Advance User. I have the setup, but I do not want an advance user that is in the Advance User security role to also be in the Basic Site User security role because it messes up some of the other dynamic registration pages I have setup and other things on my site.

There are no choices in completion events for taking someone out of a DNN Security Role. Is there an SQL Completion Event that could do? I am only a little familiar with SQL so some examples would be very helpful.

I would suggest data springs to add the following to Dynamic Registration. On the completion event area of Dynamic Registration have a list of all the security roles currently on the DNN site with check boxes next to each DNN Security Roles. When a user creates a completion event relating to some question they can simply check or unchecked what security roles they would like that user to be in or not in.

Timothy A Carey
Chad
Posts:2227
river guide
river guide
06/24/2008 10:24 AM  

Hi... I was getting ready to respond to this but found another thread related to this.

 

SQL Event to Delete User From Security Role

 

Specifically, this covers how the 'Role' completion event works and what it covers, and also shows a SQL event that could be used to remove the user from a role if the standard role completion event doesn't meet your implementation requirements.

 

-Chad

 
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration > Sql Completion Event- Removing Someone From A DNN Security Role


ActiveForums 3.7

Copyright 2005 - 2008 by Data Springs, Inc.
Terms Of Use | Privacy Statement