SQL Validation running on hidden form fields
Last Post 05-14-2013 07:55 AM by Ryan Bakerink. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages Not Resolved
Chris CsanyiUser is Offline
going with the flow
going with the flow
Posts:29
Avatar

--
05-14-2013 06:14 AM
    I came across an entry like this on another form section but not dealing with Registration.

    http://www.datasprings.com/dnn-modu...-problems/

    I am running 4.10.70 version of DR wondering if this is a bug in this version or I am not doing something correctly. Thanks Chris
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    05-14-2013 07:55 AM
    Hello Chris,

    Can you please enable Debug mode in your Dynamic Registration module? Then attempt to submit the form in such a way that's invoking the SQL Validation.

    Look at the Query that the SQL Validation is rendering and attempting to execute, do you see any issues with the Query? Are there any tokens in this statement that aren't rendering??

    Tokens not rendering can be the result of a Question not being on the form(hidden until forced visible by Question Event). So if you're making a token call for a Question that's not on the page, the token call will not render to the expected value.

    Sometimes you can add this into your SQL Validation.

    IF '$(TokenName)' = 'SpecificValue' OR '$(TokenName)' like '%(TokenName)%'
    BEGIN

    END
    ....

    This condition is checking to see if the token didn't render the value.

    '$(TokenName)' like '%(TokenName)%'


    Please let me know if you have any questions.

    Thanks,

    Ryan


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