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!

SQL Driven Options (V2.3)
Last Post 08-03-2007 10:24 AM by Michael Fisher. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Michael FisherUser is Offline
wading in the water
wading in the water
Posts:18
Avatar

--
07-25-2007 05:17 AM

    Is the Combo Box the only Question Type which can be populating via a SQL select statement?

    My Challenge:

    I have a form where the user selects a Municipality from a combo box (SQL Driven).  The user will make several other selections (Project Type, Cost, Population).

    I then would like to populate several hidden fields with data elements based upon the selected municipality.  I suppose this would occur by question Event.

    Upon form submission the user will presented with possible funding information based upon information gathered from user selection & located in the hidden fields.

    I plan on passing these elements to another Dynamic Form in order to build the funding information.

    In order to accomplish this do I need to create additional combo boxes instead of hidden fields?  I really don't need additional combo boxes because no additional user selection will be necessary.  Can Hidden fields be made SQL Driven?

     

     

     

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    07-27-2007 11:35 AM
    Hmmmm, yes I see the concern here. At this time hidden fields can not be driven from query statements. I will talk with my guys here and see if we can add this in. We recently added the ability for Default Values in Dynamic Registration to be able to use SQL to pull in the default (not yet added to Dynamic Forms) but that wouldn't help you as well. What you can do (if you are passing values from one form to the other) would be to pass the values via a querystring and then maybe perform a calculation? Is this something like YourHiddenField = $(Quantity) * $(Price). Is that basically what you are needing? It sounds like maybe a field calculation feature is necessary (possibly as a question event or maybe even just as an option that is possible for each field under advanced settings?). I am interested in your thoughts on this so we can include it in the next release, we were already planning on adding more integrations with shopping carts such as Authorizenet and Paypal so this would go hand in hand with a few other enhancements around the corner.

    -Chad
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    07-27-2007 11:42 AM
    I like the idea of possibly adding a calculation field event or possibly ability to just calculate fields as the value instead of SQL. My concern is possibly the ability to use SQL Injection. We have already not allowed values from textbox's to be used in SQL queries on completion events or to populate dropdownlists (unlike combo box's and other fields types that can be used). The reasoning for this is that someone could enter something in the textbox that would then get passed in the SQL and there are some significant security concerns here with SQL injection.

    -Chad
    Michael FisherUser is Offline
    wading in the water
    wading in the water
    Posts:18
    Avatar

    --
    07-30-2007 03:45 AM

    No calculation necessary for my project. I simply need to retrieve 2 additional data elements from the database based upon the user selected municipality (Combo Box). I then want to pass the municipality & 2 additional elements to another Dynamic Form (via a querystring) to display customized results ( I'll spare you the details).

    I have read some forum posts where Form Developers are populating additional combo boxes based upon a selection in a combo box. I may try this method and not display the additional combo boxes.

    I realize this is a lot to ask of Dynamic Forms, but this tool comes very close to doing what I need it to do. Plan B is building a custom DNN Module.

    Michael FisherUser is Offline
    wading in the water
    wading in the water
    Posts:18
    Avatar

    --
    08-03-2007 10:24 AM

    I am so close to making this work.

    I was able to auto populate my additional combo boxes with SQL driven values based upon a selection in the Community Combo box. It looks as if I will be able to hide these combo boxes from anonymous users thus making them SQL driven hidden fields. Still wish Hidden fields could be made SQL Driven.

    Now for Problems & Frustrations:

    I'm trying to create question events that will display Custom HTML Fields based upon my hidden combo boxes.

    I can create the event ok but I am unable to enter an Initiation / Postbaclk Question. The values do not appear in the field because they are generated from a SQL Query which uses a parameter. Also, the field is not available for me to hand enter in a value. Any way to hand enter a value thru SQL Express Manager?

    Also Custom HTML Fields do not have names as do other question types, therefore you have do guess (based on sort order) which fields to hide/display.

    Finally, If I cannot make the above work, Is it possible to add conditional logic to a system message to display or not display certain text?

    Michael FisherUser is Offline
    wading in the water
    wading in the water
    Posts:18
    Avatar

    --
    08-03-2007 10:36 AM
    I made any error in my previous post.

    I stated that the question events will not allow be to select from the Initiation/Postback Question. I meant the Initiation Response is empty when I try to create a Ques. Event based upon a combo box whose SQL Driven request uses a parameter.

    I could pass the value to a hidden field but I believe the Initiation Response field is not even available for this field type.
    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