Recently Viewed...
To help you navigate to pages you most recently visited, select from the links below.
Product Forums
Sharepoint Forums
Newsletter
Dynamic Forms Demonstrations
Page Tags
DNN Modules
SnowCovered Top Sellers

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

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.

Open-DocumentLibrary v3.0

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.

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.

Gloss // ALL COLORS! skin // XML Flash // W3C CSS XHTML1.0

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!Available for DNN4 and DNN5

Active Forums

The award winning discussion forum and community solution for DotNetNuke is now even better. When you need to build the best community site, you need the best module, Active Forums!

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

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.

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.
    |   Register   |   Thursday, January 08, 2009   
Data Springs Product Forums...
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
Subject: Country drop down?
Prev Next
You are not authorized to post a reply.

Author Messages
Niclas
Posts:11
wading in the water
wading in the water
10/26/2006 3:07 PM  

Hi Chad & Datasprings.

 

Just purchased Dynamic Registration & the Opt in email modules, they are excellent!

 

Question that I have not figured out yet:

Q: I want to add a drop down from which COUNTRY my visitors are from. How do I add this from the DNN core and tie it together with a Dynamic Registration Field?

 

Thanks...
Chad
Posts:2386
river guide
river guide
11/05/2006 6:26 PM  
Hi. You would want to do this using the SQL Options.

Step 1: Create a new Dynamic Field called Region, make the field a dropdownlist field and choose the standard defaults for the field.
Step 2: Save Field
Step 3: Reopen field and choose SQL Options instead of entering them all in
Step 4: Review the SQL statement example that is given, it should be this:

select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Region'

Step 5: Save the field again
Step 6: Navigate to the DNN Core Integration area, and under optional fields specify your region field to represent the DotNetNuke Region field.

Hope this helps!
Peter
Posts:6
skipping stones
skipping stones
11/10/2006 4:38 PM  

I think the SQL should be like this for country:

 

select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country'

 

If you use Region it will return States etc.

 

Question:  How can I use the ComboBox to show the list of Country and Regions?  That way it only takes up one line on screen.
ccain
Posts:17
wading in the water
wading in the water
01/29/2007 9:33 AM  

This is good, but how to I set the default to the United States? I tried entering United States in the Default field; that didn't work.

 

Thanks.
Chester
Posts:28
going with the flow
going with the flow
01/31/2007 8:40 AM  
Here is an idea for you

select Text, 'a' as ord from lists where listname = 'Country' AND right(text,6) LIKE '%States'
Union
select Text, 'b' as ord from lists where listname = 'Country' AND right(text,6) NOT LIKE '%States' order by ord
ccain
Posts:17
wading in the water
wading in the water
01/31/2007 11:23 AM  

Actually, i got that to work with out-of-the-box Dynamic Registration functionality. I didn't explain well. I am getting State and Country from a Session variable and I want State and Country to default to the one provided in the session variable unless there isn't one. But if it's not the right State or Country (or Province or Region) then I want the user to select the correct one from the list of Region and Country. Can you solve this one? LOL
Chester
Posts:28
going with the flow
going with the flow
01/31/2007 1:06 PM  

Hmm I would stay away from session variables if possible but I guess that not the case here.

 

I could think of a way if we could write a sproc and pass the session variable to it...
Jack
Posts:44
paddling down the creek
paddling down the creek
04/13/2007 8:44 AM  
I would love to know how to get the default country listed as United State. Any help would be appreciated.
Mike
Posts:11
wading in the water
wading in the water
06/10/2007 5:26 PM  

I removed all of the countries other than Canada and United states, then used the query

select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country' order by QuestionOptionValue DESC

You _could_ have modified the List table contents to use a Sort Order, then set the Order By clause to use the Sort Order column
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration > Country drop down?


ActiveForums 3.7

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