Recently Viewed...
DNN Modules
SnowCovered Top Sellers

Engage: Publish 5.2

Content Workflow + Versioning + Categorization + Multiple Display Options = Truly Advanced DotNetNuke Content Management (Requires DNN 4.5.1 or later)

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!

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.

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

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.

Dynamic Forms 2.7

In this day and age, knowing as much detailed information as possible about your customer, prospect or web site user is essential. Thankfully, the new 'Dynamics Forms' module from Data Springs, makes it easier than ever to segment your data collection efforts.

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.

Data Springs Collection 2.0 (20+ Modules)

Capture your users attention, enrich your site with multimedia flash, and create and opt in distribution list for your DNN site. These are just a few of the many features the Data Springs Module Collection can provide you.

Document Exchange 5

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.

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

    |   Register   |   Thursday, December 04, 2008   
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:2271
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:2271
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 - 2008 by Data Springs, Inc.
Terms Of Use | Privacy Statement