Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
SQL Options not saved
Last Post 12-27-2006 09:15 PM by Mike Hickman. 6 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Thomas StensitzkiUser is Offline
new to the springs
new to the springs
Posts:4
Avatar

--
12-07-2006 05:39 AM

    When I add a new Combo Box, the SQl Driven Options are not saved.

     

    The 'Test SQL' button returns valid values. The 'Update Field' command is send without any errors.

     

    The Combo Box is still empty in the registration form.

     

    Thomas
    Thyme CurtisUser is Offline
    new to the springs
    new to the springs
    Posts:4
    Avatar

    --
    12-07-2006 07:59 AM
    Hi Thomas,

    A few questions:

    1) What version of the module are you running?
    2) Can you copy and paste the SQL into the forum?

    Also note: The most recent version requires you to update the field before entering options.

    Let me know how it goes,
    Thyme
    Thomas StensitzkiUser is Offline
    new to the springs
    new to the springs
    Posts:4
    Avatar

    --
    12-07-2006 10:29 PM

    Hello Thyme,

     

    the module version used is 2.3 for DNN43plus. The module installations has been done without any errors :)

     

    The used SQL is:

    select Text as QuestionOption, Text as QuestionOptionValue from Lists where ListName= 'Country'

    The "Test SQL" returns the list of countries. Even the default drop down is populated and a default can be selected.

     

    The "Update Field" command does not update the field.

     

    Thomas

     
    Ken FayalUser is Offline
    Posts:4
    Avatar

    --
    12-08-2006 08:30 PM
    We are experiencing the exact same problem.  Here's how to duplicate the problem.  (I am a developer myself and I know how much a step by step documented process can help reproduce the problem in a development environment.)

    1. Create new Dynamic Field
    2. Put in the Question field:  State
    3. Put in the Short Name field: State
    4. Put in the Help Text field: Choose your state from the list.
    5. In my case, I entered a sort order of  9
    6. I left the Textbox Max Length field with the default value of 50
    7. Question Type: Combo Box
    8. Click Update Field
    9. Select newly created State field from the Dynamic Question dropdown list
    10. In Question Options, select SQL Driven Options
    11.  Enter SELECT Text AS QuestionOption, Value AS QuestionOptionValue FROM Lists WHERE ListName = 'Region' into the SQL query box.
    12.  Click the Test SQL button to verify that the SQL works.  (You get the same results whether you click the Test SQL button or not)
    13.  Click Update Field
    14.  Click Exit and view a user account.  A drop-down list appears correctly but it is not populated.
    15.  Go back in to edit the State field and notice that there are no SQL Options stored.
    Ken FayalUser is Offline
    Posts:4
    Avatar

    --
    12-08-2006 08:34 PM
    After a bit of examination of the DynamicRegistration_Question table, I found that the UseSQL and SQLText fields were not being populated.  I updated the UseSQL field to 1 and set the SQLText field to my appropriate query and voila it worked.  There is definitely a bug in the code there.
    Thyme CurtisUser is Offline
    new to the springs
    new to the springs
    Posts:4
    Avatar

    --
    12-12-2006 09:16 AM

    Hello,

    Sorry for the delay in responding. I tried duplicating the issue on BetaSprings.com and was unable to - both Ken's and Thomas' SQL worked for me. We understand there is definitely a bug there and we want to fix it. Betasprings is running off the same DNN release as well, so there must be another factor that is affecting the SQL. 

     

    Are you able to duplicate in BetaSprings?

     

    I'm glad there is a work around for the time being.

    Ken - thank you for the step-by-step instructions on how you found the bug - it is extremely helpful.

    Thyme
    Mike HickmanUser is Offline
    new to the springs
    new to the springs
    Posts:1
    Avatar

    --
    12-27-2006 09:15 PM
    Just for the record, I'm having the same problem. I entered my SQL statement (the state list from the lists table) exactly as it is demonstrated in the Dynamic Registration V2.2 User Guide and the list data is not being persisted. I'm running DNN 4.4 on WebHost4Life.com using your module which I bought a few hours ago so I'm assuming it's the latest version. I'll use Ken's work around for now. Thanks Ken.

    Other than that, it's a great product.
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi