Recently Viewed...
DNN Modules
SnowCovered Top Sellers

Live Content v1.6 :: 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...

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.

Catalyst By DrNuke

The Catalyst skins are professionally designed, coded and packaged by a team of DotNetNuke experts. The skins are available in 12 great colours. This skin is easily customisable with our unique DrNuke EasyMod technology. Try our demo!

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: SQL Query parameter
Prev Next
You are not authorized to post a reply.

Author Messages
Aarthi
Posts:12
wading in the water
wading in the water
08/06/2008 12:17 PM  

Hey Chad,

I have purchased the latest dynamic forms module from data springs and I am having issues with using query string in SQL driven options.

my query is

SELECT off_date as QuestionOption, off_date as QuestionOptionValue from mw_DynamicForms_Custom_Offerings where offering = '$(Offering)'

This query works fine when I use a value in place of the token. I also made sure the offering field's sort order is less than the offering date field for which I am using this query.

I saw a post in this forum which was posted an year back and deals with the same issue. You had then mentioned that it is was a bug in the module and you would send a patch for the same.

Am not sure if this has been take care in the latest release as I am not able to make this work.If this is still a bug in the module, could you pls send me the patch asap?

If not and if I am missing something, please guide me.

Thanks,

Aarti
Chad
Posts:2271
river guide
river guide
08/06/2008 4:23 PM  
Hi,

Well yes it should be fixed if you are running on 2.6. You would also need to create a question event though so that 'option 1' causes a postback.

A few things...

1. If you can setup a similar implementation on www.betasprings.com (login as host/dnnhost) we should be able to determine if the issue is a version difference or if its a implementation and setup issue

2. Have you checked out the Dynamic Forms Demos? There is one specifically related to multiple dropdownlists and data driven form fields based on other questions. Usually the biggest issue is that you need to setup a question event to cause a postback.

-Chad
Aarthi
Posts:12
wading in the water
wading in the water
08/06/2008 9:27 PM  

hey Chad,

I am facing a weird problem when I setup my question event.

Here is the situation.

"Field 1 ":

1. It is a text box.

2. It gets its value from a querystring

"Field 2"

1. It is a combo box whose values are populated using a sql.

2. The sql has a where clause which depends on the value of "field 1" (which means it is indirectly dependent on the query string)

Now, when I try to setup the question event, only those fields which are combo boxes get listed under "Initiation / Postback Question" which means "Field 1" does not get listed there (as it is a text box)

Please let me know how to handle this. I have also tried to simulate this in the page Dynamic Forms > rt_test in betasprings.com. (I have not simulated the querystring passing though)

Thanks,

Aarti

 

 

 

 

 
Aarthi
Posts:12
wading in the water
wading in the water
08/07/2008 1:21 PM  
Hey Chad,

Could you pls. provide a solution for this as am stuck with this problem big time and need this functionality in production by tomorrow..

Thanks,
Aarti
Chad
Posts:2271
river guide
river guide
08/07/2008 2:12 PM  

Aarti,

Hi. Yes there is some build in functionality to NOT allow textbox entries to be allowed within SQL Options. This is (right now) because of security reasons and possibly SQL Injections that can occur. We have worked out a few security measures and are allowing certain parameters to be passed and parsed for implementations such as these. If you look within the forums search for 'DSPARAM1' etc... You can pass this variable and $(DSParam1), $(DSParam2), $(DSParam3) are allowable querystring parameters you should be able to pass and it will get rendered properly within the SQL events.

-Chad
Aarthi
Posts:12
wading in the water
wading in the water
08/07/2008 2:24 PM  
Great ! it worked ! Thanks a ton Chad!
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms > SQL Query parameter


ActiveForums 3.7

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