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
Character Limitation
Last Post 11-06-2012 11:51 AM by Ryan Bakerink. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
SushanUser is Offline
new to the springs
new to the springs
Posts:1
Avatar

--
01-13-2012 01:08 PM
    Hi,

    I am trying to have a question that is radio button type. The issue is that, every one of the answers for this question has very very long answer options. For example,

    This is the question.

    1.This is a very very long answer option for the questionnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn
    1.This is another very very long answer option for the questionnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn

    I have been told that the character limitation is around 200. One possible way to get around this issue is to do the following: 

    "included within the Radio Button an HTML SPAN or DIV tag and then use client side events to set the values upon page load using the "Initial JavaScript" functionality." 

    Demo 20 has been suggested as an example to apply this strategy in my case, but I am having trouble setting it up and get it to work yet. 
    <!--[endif]-->

    If someone can provide a detailed step to implement the suggested method, it will be much appreciated. 
    or if you know any better way to resolve this limitation issue, please let me know.  Thank you.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    01-24-2012 03:24 AM
    Hello Sushan,

    I would suggest going to Host -> SQL and update the column in the DynamicForms_Question table.

    To see the structure of this table you can run the following query:

    sp_columns "DynamicForms_Question"

    The column that you want to extend is named "Question". So if you're going to modify the size of this column, you will need to alter 3 sections.

    Firstly you will need to alter the column Question by running the following query at Host->SQL:

    Alter Table DynamicForms_Question
    Alter Column Question nvarchar(4000)

    Now after altering this column, there are two stored procedures that you will need to modify or else there will be errors in Dynamic Forms.

    Go to Host -> SQL and look at these two stored procedures:

    sp_helptext "DynamicForms_AddDynamicQuestion"

    and

    sp_helptext "DynamicForms_UpdateDynamicQuestion"

    You will need to alter these stored procedures to have the Question name variable to accept the same nvarchar value as you specified for the column in the DynamicForms_Question table.

    So if you made the Question column an nvarchar(4000) then you will need to use this value in the stored procedures.

    After altering these stored procedures you will need to go to Host -> Host Settings and Restart the Application.

    Please let me know if you have any questions.

    Thanks,

    Ryan
    Steve AunanUser is Offline
    Posts:26
    Avatar

    --
    10-31-2012 01:03 PM
    I just performed this procedure using nvarchar(max) for the Question column, and there is a Constraint on the table that results in this error:

    Msg 5074, Level 16, State 1, Line 2
    The object 'DF_DynamicForms_Question_Question' is dependent on column 'Question'.
    Msg 4922, Level 16, State 9, Line 2
    ALTER TABLE ALTER COLUMN Question failed because one or more objects access this column.

    Maybe this error only occurs when changing the column to nvarchar(max) -- I don't know. My solution was to drop the Constraint first, then alter the Table, then add the Constraint again. I'm not posting the T-SQL code I used because I used the SQL Management Studio, and the syntax would be different when using the DNN Host SQL tab.

    Just thought I'd share. Perhaps someone from DataSprings could chime in if there's something I'm missing.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    11-06-2012 11:51 AM
    Hello Steve,

    I would recommend looking into this I. Go to Host -> SQL and run this query to look at the information on this Constraint:



    SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,
    SCHEMA_NAME(schema_id) AS SchemaName,
    OBJECT_NAME(parent_object_id) AS TableName,
    type_desc AS ConstraintType,
    *
    FROM sys.objects
    WHERE type_desc LIKE '%CONSTRAINT'
    and name = 'DF_DynamicForms_Question_Question'


    From what I can tell, this is a false constraint. I would just analyze the Constraint, recreate the Constraint type, then drop it. Then make the modifications to the Table and Procedures listed above and recreate the Constraint if you wish.

    Thanks,

    Ryan

    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