Recently Viewed...
DNN Modules
SnowCovered Top Sellers

Ultra Media Gallery 5.3
Ultra Media Gallery is the most popular photo gallery and media gallery module for DotNetNuke, the major purpose of this module is to allow you create unlimited pictures and medias to your gallery and organize them by albums, your albums and medias are browsed in flash interface.

Flex By DrNuke
The Flex skins are professionally designed, coded and packaged by a team of DotNetNuke experts. Available in 8 great colours, each with 15 banner images, 2 menu types and a choice of 3 background styles. The entire pack features a total of 2448 skins!

Ultra Video Gallery 2.3
Ultra Video Gallery is a brother product of Ultra Media Gallery, The major purpose of this product is to provide an easy way to add videos in various formats to your website by and play them in a unique flash gallery.

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.

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

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.

Events Calendar and Registration 2.1.8 for DNN4.xx
One stop solution for events calendar and events registration! Demo site available for free trial.

Form Master 1.6 For DNN 4
Form Master 1.6 improves on the success of version 1.5 with new features in Function, and Presentation, while maintaining the Intuitive User Interface. Form Master 1.6 delivers visual form design where input fields can easily be created, modified, and moved.

DNNMasters SEO Suite Enterprise w/Source
If you want better Search Engine ranking you need KeepAlive, URL Rewrite, Custom 404 error, Custom Redirect, Friendly URL's, Sitemap, Google Sitemap.DNNMasters SEO Suite delivers all of it and more!

CATALooK.netStore Pro & Booking Tools w/source DNN4
Powerful multilingual, search engine optimized ecommerce store and renting/letting system including a concept utilizing many business models in one application integrates:Catalog,Media gallery,Configurator,Packages,Data entry forms,Subscriptions,Recurring billing,40+ CC Gateways,UPS and USPS support
    |   Register   |   Saturday, August 30, 2008   
Data Springs Product Forums...
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 AM  

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

Chad
Posts:1863
river guide
river guide

04/23/2008 10:19 AM  
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 AM  

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.



ActiveForums 3.7

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