Recently Viewed...
DNN Modules
SnowCovered Top Sellers

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...

Content Workflow + Versioning + Categorization + Multiple Display Options = Truly Advanced DotNetNuke Content Management (Requires DNN 4.5.1 or later)

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.

'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

Powerful, Ajax Enabled, Easy to Use. Document Management has never been better. Open-DocumentLibrary allows DotNetNuke users to share and manage documents in a flexible, intelligent way, offering granular control over Folder and Document access.

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 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.

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.

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.

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   |   maandag 1 december 2008   
Data Springs Product Forums...
Subject: Anyone help?
Prev Next
You are not authorized to post a reply.

Author Messages
Pete
Posts:2
new to the springs
new to the springs

02-20-2007 5:30  

Hi,

 

I have basically created a load of generic usernames to give out with default "firstname", "Surname", "display name" & "email@mydomain.com" fields pre-filled.

 

What I want to do is some kind of IF statement to say that if

SELECT FirstName

FROM Users

WHERE UserID = $(UsedID)

= 'FirstName'

then display a message to say "Please update you profile, Click Here"

But I'm not sure how to do this... Probably very basic, but would appreciate if anyone could point in the right direction.

Many thanks

Pete

Chad
Posts:2244
river guide
river guide

02-21-2007 10:09  

Hmmmm... I am thinking that this could be done a few ways.

#1. Maybe use the Tailored Text/HTML module to return a stringle variable. That string would be a SQL or stored procedure that passed to the procedure the UserID and then it would return text text as the variable.

So within the stored procedure itself it would either return 'Please update your profile,..." or it would return 'Your profile is up to date.

#2. You could (you would want to backup your database and review this in more details first) add users via SQL to a security role called 'Update Account Role'. Basically Update UserRole Set RoleID = 3 (or whatever roleID the Update Account Role was in), UserID = (select UserID from yourtable where you determine they need updated).

Then, you can set that security role to show the tailored text or even standard text that says '$(FirstName), your account information needs to be updated, please click here to manage your profile'.

A few other thoughts:

You could use your Dynamic Login module to redirect them to that specific page based on their security role

There is some core functionality that might work too, you can specify some fields that are required and then within DotNetNuke specify that their account must be required before they can continue.

Pete
Posts:2
new to the springs
new to the springs

02-22-2007 1:06  

Chad,

 

Thanks, sorted it with SQL query string! Cheers

Pete

You are not authorized to post a reply.



ActiveForums 3.7

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