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

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

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,

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.

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

Larger response fields...
Last Post 06-29-2010 04:38 PM by David To. 20 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Chad NashUser is Offline
Posts:5260
Avatar

--
09-01-2006 09:28 AM

    I wanted to let everyone know that currently response fields are limited to 300 characters with Dynamic Forms. If you would like the user to respond to larger field types (i.e. Multi line textbox's etc...) Please execute this query under Host, SQL.

     

    Alter Table DynamicForms_QuestionResponse
    Alter Column Response nVarchar(3000) Not Null

     

    This will allow up to 3000 characters. We are looking into including this in future releases since it has come up multiple times and doesn't sound like it would take too much of a performance hit.

     

    -Chad

     

    Ohad KlessUser is Offline
    new to the springs
    new to the springs
    Posts:3
    Avatar

    --
    11-05-2006 11:06 AM

    Chad,

    I have changed to nvarcchar(3000) and still the field gets only 300 characters somehow.

    Do you have any more ideas? (I have version 2.0)

     

    Ohad

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    11-05-2006 04:36 PM
    Ohad,

    Hi. Check out the max length of your textbox field. What is it set at?

    -Chad
    Ohad KlessUser is Offline
    new to the springs
    new to the springs
    Posts:3
    Avatar

    --
    11-06-2006 07:41 AM

    Chad had found out that the procedure should be changed too, and it worked:

    "

    Ohad,

    Hi. I just looked at the scripts. Please execute this under Host, SQL. If this does works would you mind posting to the forum and lettings users know? I think the problem is that the stored procedure before was only set to allow 300 characters as well.

    Under Host, SQL:
    drop procedure DynamicForms_AddDynamicResponse

    then execute script...
    Then execute this:

    CREATE PROCEDURE DynamicForms_AddDynamicResponse

    @QuestionID as uniqueidentifier,
    @Response as varchar(8000),
    @UserID as integer

    AS
    Insert Into DynamicForms_QuestionResponse (DynamicQuestionID, Response, UserID) Values(@QuestionID, @Response, @UserID)

    "

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    11-16-2006 10:40 AM
    Ohad,

    Thanks for the tips. We have noted this for the next patch or release and for other users will have this automatically changed during installation/upgrade.

    -Chad
    Art SchrammUser is Offline
    skipping stones
    skipping stones
    Posts:10
    Avatar

    --
    12-07-2006 09:29 AM
    Did this work?  I'm having the same issue with only getting 300 characters showing in the results.
    Will SuggUser is Offline
    going with the flow
    going with the flow
    Posts:70
    Avatar

    --
    01-09-2007 09:22 AM
    Hey Chad,

    Was this included in the latest release of Dynamic Forms?

    Thanks,

    Will
    Will SuggUser is Offline
    going with the flow
    going with the flow
    Posts:70
    Avatar

    --
    01-09-2007 10:13 AM
    This fix does work I changed it to 4000. Now I need to get hard returns to stay in between the paragraphs in this response field. I have folks that are using a multi-line text box to submit a 'concept letter' one page and it is tough to read without the hard returns or tabs included.

    thanks,

    Will
    Will SuggUser is Offline
    going with the flow
    going with the flow
    Posts:70
    Avatar

    --
    01-10-2007 05:11 AM
    Well changing the char to 4000 did send an email with the additional text entered in the field but when you go to 'view form results' there is nothing there for that entry, for any field?!

    Thanks,

    Will
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    02-24-2009 01:47 PM
    Ok... Well apparently this is still having for a few users, my guess is for upgrade implementations, from what I saw I think there is a problem with the query that 'increased' the size of this column because its set to 'not null' so when its altering the column it throws an issue and therefore the size doesn't get larger.

    So... If anyone is still running into problems with the size issue, please execute this under Host, SQL:


    Alter Table {databaseOwner}{objectQualifier}DynamicForms_QuestionResponse
    Alter Column Response nVarchar(3000) Null
    GO

    ALTER PROCEDURE {databaseOwner}{objectQualifier}DynamicForms_AddDynamicResponse

    @QuestionID as uniqueidentifier,
    @Response as nvarchar(4000),
    @UserID as integer,
    @UniqueResponseID as uniqueidentifier

    AS
    Insert Into {databaseOwner}{objectQualifier}DynamicForms_QuestionResponse (DynamicQuestionID, Response, UserID, UniqueResponseID) Values(@QuestionID, @Response, @UserID, @UniqueResponseID)



    This supports the latest Dynamic Forms 2.7 for any users running into character limits on fields (such as multi-line textbox) where its truncating after 300 characters.

    -Chad


    BWassinkUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    06-29-2010 07:12 AM
    Good Morning,
    I'm hoping someone will still check this post even though the last entry was over a year ago. I ran the suggested string through the host SQL and now my dynamic forms aren't posting results to the form results table. I really hope someone can help me figure out why.

    -Ben
    CandaceUser is Offline
    river guide
    river guide
    Posts:2431
    Avatar

    --
    06-29-2010 07:31 AM

    Hi Ben,

    Let's start with the basics:  1) What is your exact module version from Host, Module Definitions   and  2)  What DNN version are you on?

    Do you have redirection settings on your form?  When you hit submit, does it redirect or does it just sit there?

    Also, do you see any errors in Admin, Even Viewer?

    Thanks,

    Candace

    BWassinkUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    06-29-2010 07:42 AM
    My module version is 02.30.70 and my DNN version is 04.07.00.
    The form does redirect to a thank you page and currently I have it set up to email me the results while the table is not receiving them. It goes through all the steps of emailing me the results and redirecting to the correct page the results just don't show up in the table. As for my eventlog it times out when I try to view it, or gives me an error message saying event viewer is currently unavailable.
    BWassinkUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    06-29-2010 07:50 AM
    I may have just figured out why its not working so I should qualify that first I'm not experienced in SQL and should probably have not tried this method. Second I ran it EXACTLY as it was written meaning that I didn't replace {databaseOwner} with the actual owner account name. I'm not sure if thats what I was supposed to do or if I was supposed to run it exactly as written. I apologize for my lack of foresight and appreciate your help.
    Ryan BakerinkUser is Offline
    river guide
    river guide
    Posts:1900
    Avatar

    --
    06-29-2010 07:59 AM

    Hello,

     

    I am glad that you have found resolution to the issue you were encountering. If you have any additional comments or questions please let us know so we can be of further assistance.

     

    Thanks,

     

    Ryan

    BWassinkUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    06-29-2010 08:02 AM
    Sorry but that wasn't a/the solution... that was just me explaining that, that may have been the cause. I still have absolutely no clue how to fix my issue.
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-29-2010 08:05 AM
    Hi. It could be a version difference between when this was posted and the latest version. Can you please let me know what version you are running on of Dynamic Forms? I think the query above was specific to version 2.7.

    -Chad
    BWassinkUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    06-29-2010 08:36 AM

     My module version is 02.30.70 and my DNN version is 04.07.00. 
    Is there anyway I can just revert the module back to default settings?

    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    06-29-2010 09:41 AM
    Ahhh... Well yes, this would explain the problem. Version 2.3 is a pretty old version of the module (well over 2+ years ago). I don't think you would be able to do this with version 2.3 as I am not sure what stored procedure it used... You will want to upgrade to the latest version of 3.3 for full support, I believe this was handled automatically in future versions as well. There is no direct upgrade patch from version 2.3 but you can find our full upgrade policy at http://www.datasprings.com/Upgrade-Policy. You wouldn't lose any of your existing forms or settings during the upgrade and the latest version of Dynamic Forms does support 4.7 of DNN still.

    Thanks,

    Chad
    BWassinkUser is Offline
    skipping stones
    skipping stones
    Posts:6
    Avatar

    --
    06-29-2010 09:53 AM

    Could you tell me how to revert what I did back to the old version? I can give you a part of the error I'm getting if it would help. Or could you tell me how to located the stored procedure since thats what was changed by running the script?

     

    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    06-29-2010 04:38 PM
    HI, one way is to locate the install (.zip) file that you use to install the module. Check for the latest SQL data provider file and copy and paste that entire content to host / SQL execute it. This should get back to the original version. See if this will work for you. -- David To
    You are not authorized to post a reply.


     
     

    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