s
Contact Login Register
h M

Search Blog...

In The Flow

A Solution to Performance Issues with Dynamic Forms

Makes a world of difference!


There have been some reports that Dynamic Forms can be very slow in edit mode and becomes cumbersome, especially when creating a large form with a variety of field types.  Thanks to Peter Nuiten and Ernst Peter Tamminga of www.xcess.nl, we are happy to share a solution with you! 


Thursday, May 22, 2014/Author: Candace/Number of views (3535)/Comments (-)/ Article rating: No rating
Categories: In The Flow
Tags:

DNN Security Leak Bypassing Dynamic Registration

We found a workaround for this!

We've come across a situation that we want to share with you.  Several customers using Dynamic Registration were finding that people were able to bypass this and somehow get to the standard DNN registration without the extended fields.  Apparently, this was done by simply adding "?ctl=register" to the URL.  Here's a workaround that was helpful to one of our clients (thanks, Bob!). 

Thursday, May 22, 2014/Author: Candace/Number of views (4338)/Comments (-)/ Article rating: 3.0
Categories: In The Flow
Tags:

IE 10 & Dynamic Form Submit Button issues

I’ve seen several cases of this in IE 10. I found that when the Dynamic Form’s submit button is rendered by IE 10, the OnClick event has: “JavaScript:;” inside of the onClick event. It seems that IE 10 does not like this and instead disables the button from executing as it should.

To alleviate the inconsistencies between browsers, I create a custom submit button. It’s also a plus to have a custom submit button, because you can:

1.) Have the ability to fully customize the submit button

2.) Have the ability to control the submit button layout/placement.

 

To learn how to create a custom submit button in Dynamic Forms, please review the following blog:

http://www.datasprings.com/news/blog/postid/53/custom-dynamicforms-submit-button

 

This is a quick tip that should help conform your Submit button for most Internet Browsers.

Thursday, April 25, 2013/Author: Chad Nash/Number of views (9473)/Comments (-)/ Article rating: 3.0
Categories: In The Flow

JavaScript Function to replace ' and " with Single Quote or Double Quotes

We all know that collecting information from users can be potentially dangerous. Not because the user means to be malicious, but because you may not have a procedure/function in place to handle single quotes or double quotes. This can cause issues when the data is passed to the database. In most cases a SQL Stored Procedure can handle “SQL Injection” with single quotes and double quotes. However with Dynamic Forms or Dynamic Registration tokens should be encapsulated inside of '$(Token)'. So if you’re passing a Token into a stored procedure call:

exec MyProcedure '$(Token)'

You can see how collecting a ' in a textbox and passing to a stored procedure or inserting directly into a database table can become an issue. For instance, let’s say that the value I provided for a textbox in Dynamic Forms was:

FireShot Screen Capture #063 - 'Dynamic Registration' - dnn7_betasprings_com_ModuleTesting_DynamicRegistration_tabid_91_Default_aspx

 

When using the $(FirstName) token from this form in a SQL Completion Event the value would render as:

'John O'Neal'

You can see how handling this on the client side instead of Server side can be beneficial within Dynamic Forms or Dynamic Registration.

 

Add this JavaScript function to your Dynamic Form or Dynamic Registration Custom JavaScript file:

-------------------------------------------------------------------------------------------------------------------------

function Replace_Single_Double_Quotes(DF_QuestionID)
{
    //Assigning passed in parameter to variable
    var QuestionValue = document.getElementById(DF_QuestionID).value;
   
    //This field will assist us in knowing whether to replace " with a left or right double quote
    var NeedRightQuote = 'False';

    //Loop that checks each character in the QuestionValue variable
    for ( var i = 0; i < QuestionValue.length; i++ )
    {
        //Is this character a '?
        if(QuestionValue.charAt(i) == "'")
        {
            //Replace ' with an apostrophe
  &

Thursday, April 11, 2013/Author: Chad Nash/Number of views (10453)/Comments (-)/ Article rating: No rating
Categories: In The Flow

SQL Driven Queries for Combo Boxes, Radio Buttons, Listboxes, and Checkbox Groups

Dynamic Forms & Dynamic Registration require that you return at least two columns for a SQL Driven questions: QuestionOption and QuestionOptionValue

QuestionOption = Text User will see

QuestionOptionValue = Value behind the Item that User will see

 

For Dynamic Views, you can have SQL Driven Combo Boxes and Radio Buttons for Search Filters. This requires that you return at least two columns named SearchOption and SearchOptionValue.

SearchOption = Text User will see

SearchOptionValue = Value behind the Item that User will see

This means that you can use the queries below in Dynamic Forms / Dynamic Registration or Dynamic Views by simply changing the alias of the columns being returned.

 

Example:

Query for Dynamic Forms / Dynamic Registration:

SELECT RoleName AS QuestionOption, RoleId AS QuestionOptionValue FROM Roles 

Query for Dynamic Views:

SELECT RoleName AS SearchOption, RoleId AS SearchOptionValue FROM Roles 

 

Below are queries that I use often:


1.) Get States
---------------------------------------------------------------------------------------------------

SELECT '-- Select State --' AS QuestionOption, '-1' AS QuestionOptionValue, '0' AS SortOrder
UNION ALL
SELECT Text AS QuestionOption, Value AS QuestionOptionValue, Text AS SortOrder
FROM Lists
WHERE ListName = 'Region' AND ParentID = 221
ORDER BY SortOrder

---------------------------------------------------------------------------------------------------

2.) Get States and Territories:
---------------------------------------------------------------------------------------------------

SELECT '-- Select State --' AS QuestionOption, '-1' AS QuestionOptionValue, '0' AS SortOrder
UNION ALL
SELECT Text AS QuestionOption, Value AS QuestionOptionValue, Text AS SortOrder
FROM Lists
WHERE ListName = 'Region'
ORDER BY SortOrder

---------------------------------------------------------------------------------------------------

 

3.) Get Countries with United States at the top:

---------------------------------------------------------------------------------------------------

SELECT '-- Select Country --' AS QuestionOption, '-1' AS QuestionOptionValue
UNION ALL
SELECT Text AS QuestionOption, Value AS QuestionOptionValue
FROM Lists
WHERE ListName = 'Country' AND Text = 'United States'
UNION ALL
SELECT Text AS QuestionOption, Value AS QuestionOptionValue
FROM Lists
WHERE Lis

Monday, March 25, 2013/Author: Chad Nash/Number of views (10555)/Comments (-)/ Article rating: No rating
Categories: In The Flow
RSS
12345

Enter your email below AND grab your spot in our big giveaway!

The winner will receive the entire Data Springs Collection 7.0 - Designed to get your website up and running like a DNN superhero (spandex not included).


  
Subscribe