User Postal Code > DotNetNuke Module Product Forums > Data Springs Inc.

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

Engage: Publish 5.2

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

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.

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

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.

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

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.

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

Data Springs Product Forums...

Unanswered Active Topics

Forums Search

Forums > Product Discussion - DotNetNuke Modules > Tailored Text/HTML

Subject: User Postal Code

Email me when someone replies to this thread.

Prev Next

You are not authorized to post a reply.

Author

Messages

Rob
Posts:2

new to the springs

01/17/2007 7:37 AM
How would I get the user postal code out the profile using Tailored Text/HTML Settings? Thank you, Rob

Chad
Posts:2244

river guide

01/17/2007 9:06 AM
Rob, Hi. The postal code is not one of the default user tags that is available, but, no worries you will be able to get the current users postal code by creating a SQL token. SQL Tokens can use other tokens throughout the module, so you can use the $(USERID) within the SQL to gather the users postal code. Now I did a little research and setup this scenerio on our test site so you should be able to get it working without much trouble. The query would depend on your DNN installation, I tested on the latest DotNetNuke 4.4 release and I believe this should work for almost all 4.3.x releases... Step 1: Within the settings create a new SQL token and name it PostalCode Step 2: Use this as the query: select PropertyValue from UserProfile Where PropertyDefinitionID = 30 AND UserID = $(USERID) Note: The property DefinitionID of 30 is the definitionID for PostalCode. IF you are wanting to get other extended profile fields or just wanting to know what the definitionID for those fields is you can go to Host, SQL and execute this query: select PropertyDefinitionID, PropertyName from ProfilePropertyDefinition Step 3: After adding the PostalCode SQL Token, navigate to add content and add content that will include that token. Example: The user that is signed in has a postal code value of $(PostalCode). That should do it... -Chad

Rob
Posts:2

new to the springs

01/17/2007 10:07 AM
Great! that did it, Thank you, Rob

You are not authorized to post a reply.

Forums > Product Discussion - DotNetNuke Modules > Tailored Text/HTML > User Postal Code

ActiveForums 3.7