Recently Viewed...
To help you navigate to pages you most recently visited, select from the links below.
Product Forums
Newsletter
Sharepoint Forums
Dynamic Forms Demonstrations
Page Tags
DNN Modules
SnowCovered Top Sellers

'Relationship Building' and 'Communication' are two essential nuts and bolts for a business to prosper. This module allows you to bridge both of these and easily generate continuous awareness of your web site, products and services. Your prospects and customers will greatly appreciate this featur

Live Content uses Web 2.0 approach to provide a Rich User Interface and streamlines content presentation by overlaying content on current page. Overlay images, videos, audio, text/html content, flash, dotnetnuke modules, and external content. Experience the demo...

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.

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.

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to add videos in various format and automatically convert them to flv format, you also can add videos from embed code and play them in our integrated flash video player.

Gloss is the first ALL COLORS! skin, featuring a powerful XML-based flash and being 100% W3C CSS XHMTL1.0 compliant. Tune it yourself on the fly, changing colors, backgrounds, containers, text color and size, width and more! Brilliant!Available for DNN4 and DNN5

The award winning discussion forum and community solution for DotNetNuke is now even better. When you need to build the best community site, you need the best module, Active Forums!

ALL NEW ! - Minimalist includes skin packs in 12 great colors. Each color has Flat, Gradient and Glass versions. Feature rich XML Flash header, perfect for just about any purpose. 9 Different menu options in each skin pack; 3 horizontal menus, 3 vertical menus and 3 all-new Twin level menus . . .

Edit documents directly on your server. The premier document management solution for DotNetNuke (DNN). Index contents of documents. Share documents across your portal and avoid duplicates. Revised and flexible UI. Extensible architecture.

Ultra Media Gallery is the most popular photo gallery and media gallery solution for DotNetNuke, UMG offers 10 different flash player to browse your gallery with completely different user interface experience.

    |   Register   |   Thursday, January 08, 2009   
Data Springs Product Forums...
Subject: SQL Driven Options (V2.3)
Prev Next
You are not authorized to post a reply.

Author Messages
Michael
Posts:19


07/25/2007 7: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 neccessary.  Can Hidden fields be made SQL Driven?

 

 

 

Chad
Posts:2385
river guide
river guide

07/27/2007 1:35 PM  
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
Posts:2385
river guide
river guide

07/27/2007 1:42 PM  
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
Posts:19


07/30/2007 5: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 municipaility (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
Posts:19


08/03/2007 12:24 PM  

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
Posts:19


08/03/2007 12:36 PM  
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.



ActiveForums 3.7

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