Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
SQL-driven drop-down list not populating
Last Post 10-03-2011 12:35 AM by Don Gee. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
RokhiUser is Offline
skipping stones
skipping stones
Posts:9
Avatar

--
09-29-2011 07:54 PM

    I haver a SQL-driven drop-down list that calls a URN and a text value for each list item as follows:

    select URN as QuestionOptionValue,CategoryName as QuestionOption   from Categories where (Suppressed  is null or Suppressed = 0)order by CategoryName


    this should pull a list of 2 columns as below, and the test SQL display shows the text column only.

    1   ListItem1
    2   ListItem2
    3   Listitem3

    The text items column is visible in the drop-down, and the hidden number is saved to the form response on submission - all good so far.
    The problem is that I have set a user profile field to populate the list default (DotnetNuke User Default) but this is not populating when the form is opened.  The list always shows '-select one-'. even though the user source field is populated.

    If I reverse the SQLfield mapping and get the URN as QuestionOption and the CategoryName as QuestionOptionValue, the list will prepopulate ok,   But this shows the numbers in the drop-down - not the text and the response field is not populated.

    Any clues as to how I can get this to work?

    cheers






     


     
    Don GeeUser is Offline
    river guide
    river guide
    Posts:273
    Avatar

    --
    09-30-2011 07:59 AM
    Hi Rokhi,
    Actually the result of one column in the result of the SQL driven drop-down is the normal way for it to function.
    Thanks
    RokhiUser is Offline
    skipping stones
    skipping stones
    Posts:9
    Avatar

    --
    09-30-2011 06:45 PM
    Using the 2 columns to populate the drop-down results in a number being returned to the table on a user selection. This is as I would expect and works in with the topology I'm employing in the software this form feeds - using a category URN in the user table linking to a lookup table with related category text values in it.

    I would have thought - give that this works - that the reverse would be true, that given a number in the field used to drive this drop-down, the corresponding text would be called in the drop-down display when the form renders.

    If this is not the case (by design) when could we reasonably expect this (?normal?) functionality to be incorporated in the forms module?
    Don GeeUser is Offline
    river guide
    river guide
    Posts:273
    Avatar

    --
    10-03-2011 12:35 AM
    Hi Rokhi,
    What you will have in a general query is something like this for sql drop down:

    SELECT field 1 as QuestionOption, field 2 as [QuestionOptionValue]

    From Table

    If you choose the Table ID column as one of the fields then you will have the numbers in the result if field 2 is the Table ID column as it will be questionoptionvalue but field 1 or field 2 will be in the drop down but not both. Sorry, but this is the best way to explain what I think you are asking

    Here is a sample query you can try. Play with it and see if it helps you with understanding drop dwon values. This sample is for Lists table in DNN. Here only one field is used called the Text field:

    select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country' and Value != 'US'

    Thanks

    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi