Recently Viewed...
DNN Modules
SnowCovered Top Sellers

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!

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.

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

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

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.

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.

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.

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

    |   Register   |   vrijdag 21 november 2008   
Data Springs Product Forums...
Forums > Product General Information / User Guides > General Information / Enhancement Requests
Subject: Feature request
Prev Next
You are not authorized to post a reply.

Author Messages
Bamse
Posts:70
river guide
river guide
04-22-2008 4:01  

In DR and DF, it would be good to have a possibility to create answers from DNN built in lists to populate answers in a form

We use a Stored procedure and executes this with a parameter for the list different list name, but it should be easy to have this as a fixed option when creating a answer option. Like a drop down to select the name of the list, and then it would populate answers  using the built in sort order in DNN lists.

Can share the SP we use if anyone is interested.
Chad
Posts:2207
river guide
river guide
04-23-2008 10:19  
Hi. Please feel free to post the stored procedure, I am sure any users making use of this feature would appreciate it. We will review this in the future, but again since its possible but just not directly in the interface I am not sure it will have the highest priority over other enhancement requests. Would be nice though to have 'Enter Options', 'SQL', and then another option for 'List' though where you can select the list its tied too. Thanks for the feedback.

-Chad

Bamse
Posts:70
river guide
river guide
04-23-2008 10:38  

Sure, here it is. test before you use it...

 

Create SP:

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetAnswersFromList]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[GetAnswersFromList]
GO
CREATE PROCEDURE GetAnswersFromList
(
  @ListName nvarchar(500)
)
AS
BEGIN
 select
  l.[Text] as QuestionOption,
  l.[Text] as QuestionOptionValue
 from
  Lists AS l (NOLOCK)
 where
  l.ListName = @ListName
 ORDER BY
  l.SortOrder ASC
END


Usage:
EXEC GetAnswersFromList @ListName = 'LISTNAME'
You are not authorized to post a reply.
Forums > Product General Information / User Guides > General Information / Enhancement Requests > Feature request


ActiveForums 3.7

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