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

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

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,

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.

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

required region field with sql
Last Post 06-21-2010 03:25 PM by Chad Nash. 8 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Curtis EidsonUser is Offline
river guide
river guide
Posts:98
Avatar

--
01-18-2010 07:18 AM

    I've created a "region" combo box using the following sql:

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

    except I can not set this to be required while allowing someone to choose any option (unable to pick the first option that is shown).  I don't want a default value because that value is not an allowed selection when the region field is required. 

    I've also tried to add "--- please select ---" as an option in the list, however, am not allowed to put this as the default option (as unchecking the default option doesn't force someone to make a selection and doesn't respect the "required" option)

    This seems to be a catch 22 with using this.  Anyone have any advice on how to use this correctly? 

    thanks,

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    01-19-2010 11:18 AM
    Hi Curtis... There are 'many' examples of this within forums and demos but basically you use your query and also a 'Union All'. I would search our forums for Union All and see what you find.

    Basically...

    select '-- Select a Country --' as question option, '-- Select a Country --' as questionoptionvalue union all
    select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Region'

    And then you can make the field required and it won't allow option #1 to be selected.


    Thanks!

    -Chad

    Curtis EidsonUser is Offline
    river guide
    river guide
    Posts:98
    Avatar

    --
    01-21-2010 12:27 PM

    thanks for the help on this!

    Ray DixonUser is Offline
    skipping stones
    skipping stones
    Posts:7
    Avatar

    --
    05-12-2010 10:43 PM
    Posted By Chad Nash on 01/19/2010 1:18 PM
    Hi Curtis... There are 'many' examples of this within forums and demos but basically you use your query and also a 'Union All'. I would search our forums for Union All and see what you find.
     

    I tried searching for 'Union All' in the Dynamic Forms forum and got zero results. I know this is incorrect because at least this thread has that phrase.

    Can you please point out some examples? I can't get a combo box that I'm using SQL driven options with a union all query to validate correctly when I set it as a required field. No matter what I choose, it always gives the required field error and resets to the default value.

    Curtis EidsonUser is Offline
    river guide
    river guide
    Posts:98
    Avatar

    --
    05-13-2010 09:38 AM

    Hi Ray--

     

    True, a search with a space seems to give you 0 results.  I tried searching for just "union" and didn't really see anything.

    I had used the exact code that Chad provided and it worked perfectly for me. 

    Can you try adding a new/test combo box and use the code from above (make sure you remove the space between the words question & option ). My settings are as follows:

    1. Combo Box
    2. question option > sql driven options
    3. sql: select '-- Select a Country --' as questionoption, '-- Select a Country --' as questionoptionvalue union all
      select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Region'
    4. click test to make sure the sql is correct (if you have an error here this could be the issue. fresh dnn install returns 65 results
    5. advanced field options > no default value IS checked.
    6. scroll down to question validation and check the box "required field" and put something in the "required field error" .  this will help show if it's working or not.
    7. i've also gone to module config > validation config and checked "Display * next to field label"

    i'd test this out first to make sure it works and then work backwards from there.  If you can, also post your sql.

     

    I should als note that I'm running the latest version of dynamic forms (3.3.5) (top of df shows 3.3.40.0 but host > modules shows 3.3.5) on the latest version of DNN (5.4.1 (26))

     

    Curtis

     

    Ray DixonUser is Offline
    skipping stones
    skipping stones
    Posts:7
    Avatar

    --
    05-13-2010 10:13 AM

    What I'm trying to do is make a combo box that contains the list of users on the site with the DisplayName as the QuestionOption and UserID as the QuestionValue. I also want to make the combo box required, so I need to add "-- Select Coach --" as the first option. I also need to account for the possibility of the assigned coach not yet having a user account. So, I need to have "(No User Account)" as the second option, with the users listed after the first two options, ordered by display name. Here is the SQL code:

    (SELECT '-- Select Coach --' AS QuestionOption, -3 AS QuestionValue)
    UNION ALL
    (SELECT '(No User Account)' AS QuestionOption, -2 AS QuestionValue)
    UNION ALL
    (SELECT DisplayName as QuestionOption, UserID AS QuestionValue
    	FROM Users
    	WHERE UserID <> 1 AND UserID <> 2)
    ORDER BY QuestionOption

    When I use this and click Test SQL, it populates the options list as expected and in the correct order. I have tried this with and without "No default value" selected and the behavior is always the same. When I make the field required, it always gets flagged with the Required Field validation error when I try to save the form and resets the combo box to the first option (with or without setting a default value).

    This is running Dynamic Forms version 3.3.40.0 on DotNetNuke version 5.1.4.

    Thanks,
    Ray

    Curtis EidsonUser is Offline
    river guide
    river guide
    Posts:98
    Avatar

    --
    05-13-2010 10:30 AM

    Hi Ray--

     

    You need to use "questionoptionvalue" and not questionvalue.  i tested this and it works.

    (

    SELECT '-- Select Coach --' AS QuestionOption, -3 AS QuestionOptionValue)

    UNION ALL

    (

    SELECT '(No User Account)' AS QuestionOption, -2 AS QuestionOptionValue)

    UNION ALL

    (

     

     

    SELECT DisplayName as QuestionOption, UserID AS QuestionOptionValueFROM UsersWHERE UserID <> 1 AND UserID <> 2)

    ORDER

    BY QuestionOption

    Ray DixonUser is Offline
    skipping stones
    skipping stones
    Posts:7
    Avatar

    --
    05-13-2010 10:51 AM

    Wow, am I embarrassed. I guess that's what I get for working on this after midnight.

    Changing QuestionValue to QuestionOptionValue fixed it. Thanks, Curtis!

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-21-2010 03:25 PM
    Thanks for the useful post Curtis!

    -Chad
    You are not authorized to post a reply.


     
     

    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