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: Problems with combo box SQL Driven Options
Prev Next
You are not authorized to post a reply.

Author Messages
Luke
Posts:20
going with the flow
going with the flow
08/14/2006 11:52 AM  
Recently I have been attempting to use the SQL driven options on the dynamic forms module. Every time I save and attempt to view my handiwork, the combo box is not populated with any data. I have tested the query with the "test SQL" button and the database returns several rows which fill the listbox is with greyed out  items.  I then click update field and then update settings.  Upon viewing the form however, the  combo box is empty.  Did I do something wrong? This is my query: 

SELECT SerialNumberBoard AS QuestionOption FROM QcdMaster.dbo.TraceBoard WHERE SerialNumberBoard LIKE '11%0%S'

I have also tested this query on the  SQL query analyzer and I  can assure you that it works correctly. Thanks in advance.
Chad
Posts:2271
river guide
river guide
08/14/2006 1:44 PM  
Hi. With version 2.0 of Dynamic Forms the sql syntax has changed to allow for Option Text and Option Value fields. For example (California as the text but CA as the value).

Example:
select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country' Order By TEXT ASC

Example 2 (yours):
SELECT SerialNumberBoard AS QuestionOption FROM QcdMaster.dbo.TraceBoard, SerialNumberBoard AS QuestionOptionValue FROM QcdMaster.dbo.TraceBoard WHERE SerialNumberBoard LIKE '11%0%S'


Let me know if this works.


-Chad
Luke
Posts:20
going with the flow
going with the flow
08/14/2006 2:22 PM  
Well that was a good idea (and will be useful in the future), but unfortunately, it did not work. Here is the new query:

SELECT TOP 5
SerialNumberBoard AS QuestionOption,
SerialNumberBoard AS QuestionOptionValue
FROM QcdMaster.dbo.TraceBoard

I also tried reversing the order that the text and value fields are returned in, to no avail. I am open to any other suggestions. Thanks in advance.
Chad
Posts:2271
river guide
river guide
08/14/2006 4:16 PM  
Luke,

I did find an issue just sent you an attached patch. Let me know if this fixed your issue and I will get it posted.

-Chad
Luke
Posts:20
going with the flow
going with the flow
08/14/2006 4:33 PM  
Yes, the patch did seem to solve the problem. I havent done any rigorous testing however. As a sidenote, the combo box sends its data to the querystring when saving, however, it doesn't retrieve data from the querystring (automatically select the item that corresponds to the querystring entered). I don't know if this was originally the functionality intended, but I thought I should point it out. I would also like to thank you for your prompt service.
You are not authorized to post a reply.
Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms > Problems with combo box SQL Driven Options


ActiveForums 3.7

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