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 Forms
Checkbox Validation Causes Value Problem
Last Post 05-17-2010 04:21 PM by David To. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
AdamUser is Offline
river guide
river guide
Posts:116
Avatar

--
05-13-2010 11:23 PM

    I have a form that has only two field, one text field and one checkbox field. The checkbox field has SQL validation against it and when the checkbox fails validation the user is asked to remove the tick from the checkbox. However after removing the tick from the checkbox the backgroud value isn't changed and so the validation fails again. help!
    CandaceUser is Offline
    river guide
    river guide
    Posts:2431
    Avatar

    --
    05-14-2010 02:23 PM

    HI Adam,

    What is your exact Dynamic Forms version from Host, Module Definitions?  Also, what DNN version are you running?

    Can you please try to duplicate this over at our test site?  Just go to www.betasprings.com and log in with  host  /  dnnhost  then create your own page under Dynamic Forms parent page.  Let us know your resutls and your test page URL so we can review it for you.  Thanks!

    Candace
    AdamUser is Offline
    river guide
    river guide
    Posts:116
    Avatar

    --
    05-15-2010 08:17 AM

    Hi,

    My version is Ver:3.3.40.0 / 5.4.1.

    I have replicated the same problem on your betasprings site and the same bug occurs. A simple form with only a checkbox on it and SQL validation  of;

    DECLARE @return_value int

    SET @return_value = 1

    IF ('$(chkBox)' = 'Yes')
      BEGIN
        SET @return_value = 0
      END

    SELECT @return_value AS IsValid

    If the checkbox is unticked then no validation error is prompted, however once you tick the checkbox and submit a validation error occurs, which is correct, but after you remove the tick from the checkbox the error is still promtped after submit. The value of the checkbox is obviously not reset after validation.
    AdamUser is Offline
    river guide
    river guide
    Posts:116
    Avatar

    --
    05-15-2010 08:30 AM

    You can find my test page at;

    http://www.betasprings.com/Dynamic-...fault.aspx

    thanks
    AdamUser is Offline
    river guide
    river guide
    Posts:116
    Avatar

    --
    05-17-2010 03:22 AM

    Just another note... the checkbox value when not selected and before being selected is NULL (''). Is this correct? It appears to be a problem when I send an email based on the value of the checkbox being unselected.
    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    05-17-2010 04:21 PM
    HI Adam, okay I was able to duplicate this on my localhost system as well. I had one simple checkbox like you. However, I used a stored procedure:

    usp_validate_checkbox '$(chkBox)'


    create procedure usp_validate_checkbox @chkBox nvarchar(10)
    as
    begin
    declare @return_value int
    IF (@chkBox = 'Yes')
    BEGIN
    SET @return_value = 0
    END
    else
    begin
    set @return_value = 1
    end

    SELECT @return_value AS IsValid

    end

    I have redirection on submit to HOME page. If I check the box and hit submit, it will give me the SQL validation error message. If I uncheck the box, it will still give me the SQL validation error message which is incorrect. Enabling debug mode shows that the checkbox doesn't get reset to '' but stays on 'Yes'.

    I will notify Chad of this. For now, I believe you can use client side javascript to reset it. Another words, create a hidden field and use client side javascript on the checkbox to set this hidden field to a value of 'Yes' if checked and 'No' if unchecked. Then use SQL validation on the hidden field instead. This should accomplish what you want to achieve. -- David
    You are not authorized to post a reply.

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Forms
     
     

    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