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

Opt In Email 4.0

'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

Ultra Flash Player 6.1(16-in-1)

A 16-in-1 dnn module.Powerful yet easy to use. Capable of producing a multitude of functions including:Image rotator/Numeric rotator/ Mp3 player/Wmv player/ Flash video player /YouTube video player/Multimedia player / Text-to-speech podcast / Flipping book player/Banner topic player/Silverlight albu

XMod 5.1

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.

Ultra Video Gallery 2.4

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.

Active Forums

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!

Gloss // ALL COLORS! skin // XML Flash // W3C CSS XHTML1.0

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

Open-DocumentLibrary v3.0

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.

Minimalist by Evan O'Neil - ALL NEW !

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

Live Content v1.6.1 :: Web 2.0

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

Ultra Media Gallery 5.4

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...
Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
Subject: Userinformation
Prev Next
You are not authorized to post a reply.

Author Messages
A
Posts:4
skipping stones
skipping stones
03/12/2008 2:32 AM  

We have a table called 'Leerlingen' with fields Naam, Klas en Mentor

We want to creat a form that comes up with a dynamic field called 'name' that passes this name to fields Klas  and Mentor as a combobox with with SQL-driven options resp.
This field 'name' should be the default DisplayName

select Klas as QuestionOption, Klas as QuestionOptionValue from Leerlingen where Naam='$(Name)'

and

select Mentor as QuestionOption, Mentor as QuestionOptionValue from Leerlingen where Naam='$(Name)'

Problem is to pass the '$(Name)''

Can someone help me?
Chad
Posts:2387
river guide
river guide
03/13/2008 12:01 AM  
Hi. So are you passing this variable from a querystring or session variable? Is the field (using the query) setup after the Name field? Also, for these types of fields I believe you have to use a postback question event before that query can accept and use the parameter. We are working on changing this though to allow for more options. If you can setup a test page demonstrating what exactly you are attempting to accomplish on www.betasprings.com (login as host/dnnhost) and let us know where the page is at and what you are attempting to accomplish/attempt... This can help give us a better idea and determine if this is already possible, a bug, or a feature request that we can review adding.

-Chad
A
Posts:4
skipping stones
skipping stones
03/13/2008 1:43 AM  
Thanks for your response.
I created a page Ursula with the module Dynamic Forms on it.
I cannot simulatte the whole project, because there is not a table Leerlingen with the fields Naam, Klas and Mentor.
So I want to pass the variable in the read-only textfield Name to the next field Klas what is a SQL-driven combobox.
Thanks for your help.

Arnoud
Chad
Posts:2387
river guide
river guide
03/18/2008 1:04 PM  
Arnoud,

Hi. Please check this page again (I do believe you have to be signed in or signed in as an admin).

http://www.betasprings.com/Ursula/tabid/232/Default.aspx

Here is the basic understanding of this. The ability to use other fields values within SQL queries for other fields is somewhat of a new feature of Dynamic Forms within the last few releases. This was primarily used in conjunction with other fields that would cause a postback (such as country region, or select make/model of a car for example). So we added the feature to be able to use field tokens within SQL Options as well as other parameters that were already there (such as $(UserID), $(PortalID), $(CurrentLanguage) etc.... so... Additionally we needed to not allow this for textbox fields because of issues dealing with SQL Injection risks. If you use stored procedures within the SQL Options this is not as risky but we if we do later allow this you will need to enable it with some notes associated with the risks and how to avoid the risks of SQL Injections if you want to enable textbox's to be parsed for SQL Options.

So.... If you go to the test page setup you will see that there is a hidden field called test with a short field name of test. This is a hidden field and you could change this to retrieve from querystring or session variable but right now it defaults to the DNN Core field 'UserName'. The next field uses SQL Options to pull in values and also references the hidden field '$(test)'. This functions properly but only after a question event is fired (notice checking the checkbox field I setup to demonstrate this). So... Its working but its not setup to currently offer this feature without a postback. I am reviewing the code to see if we can insert this to see if there was a reason why it was coded to only work on postback or if not changing this to work initially as well as on postback.

Additionally in 2.6 we are adding new features to be able to use other properties such as session variables and cookies. Such as $(Session:MyName) or $(Cookie:test). Again, reviewing the risks associated with possible SQL Injection why we add these options. Because of this I don't think we will enable this same feature with querystring parameters.


-Chad
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms > Userinformation


ActiveForums 3.7

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