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
How to create a table of options for SQL Driven Options
Last Post 05-29-2009 09:01 AM by Ken Maudsley. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Ken MaudsleyUser is Offline
going with the flow
going with the flow
Posts:33
Avatar

--
05-29-2009 06:14 AM

    Sorry for this basics question. I would like to take advantage of using SQL Driven Options. I have seen how to implement the SQL statement by reading posts and using the provided U.S. States template. What I don't know how to do though is create the table of options. I looked at Demo 11 but didn't see how to do this part. Obviously I have minimal SQL experience. I appreciate any help.

    Ken

    Edit: one thought – if I manually enter the options, then they are now in a table. If this is the answer to my question, then how can I identify this table?
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    05-29-2009 06:57 AM
    Hi Ken, you have several options:
    1) if your list isn't extensive and you're only using it on a combobox once on a particular DF module on a page somewhere, then it's more convenient to enter the values manually (however, this means if you have other DF forms on other pages and you want to use this same list, you will have to manually add them there as well)
    2) if your list is going to be used often on other DF modules/pages, then it's more convenient to create a list table
    Go to HOST / LISTS and create your table there once
    3) Then to use this Lists table, you can use SQL driven options

    or
    4) you can create a separate SQL table and insert your record into it and call it

    Once you set up your Host / Lists table or separate SQL table, feel free to repost here and I'll or someone else can help you with the SQL statement once we know what the field names / table name is for your table. -- David
    Ken MaudsleyUser is Offline
    going with the flow
    going with the flow
    Posts:33
    Avatar

    --
    05-29-2009 08:21 AM

    Fantastic! I was able to create a list and use the following code to generate my options dynamically:

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

    I just modified the code provided in the States list example. Let me ask a related SQL statement question. In the example for the states, if I wanted to only list the US states (i.e. not the Canadian states), what would be the correct statement. The lists are both named region but have different parents:

    Country.Canada:Region
    Country.United States: Region

    The statement is:

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

    Thanks so much for clueing me in to Lists.
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    05-29-2009 08:49 AM
    HI Ken, add a where clause at the end of your SQL statement.

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

    if 221 is the ParentID for US on your System. It is on my DNN install. -- David
    Ken MaudsleyUser is Offline
    going with the flow
    going with the flow
    Posts:33
    Avatar

    --
    05-29-2009 09:01 AM

    Thank you, once again.
    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