Chad Nash Posts:5260
|
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 Kless
new to the springs Posts:3
|
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 Nash Posts:5260
|
11-05-2006 04:36 PM |
|
Ohad,
Hi. Check out the max length of your textbox field. What is it set at?
-Chad
|
|
|
|
|
Ohad Kless
new to the springs Posts:3
|
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 Nash Posts:5260
|
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 Schramm
skipping stones Posts:10
|
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 Sugg
going with the flow Posts:70
|
01-09-2007 09:22 AM |
|
Hey Chad,
Was this included in the latest release of Dynamic Forms?
Thanks,
Will
|
|
|
|
|
Will Sugg
going with the flow Posts:70
|
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 Sugg
going with the flow Posts:70
|
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 Nash Posts:5260
|
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 |
|
|
|
|
BWassink
skipping stones Posts:6
|
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 |
|
|
|
|
Candace
river guide Posts:2431
|
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 |
|
|
|
|
BWassink
skipping stones Posts:6
|
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. |
|
|
|
|
BWassink
skipping stones Posts:6
|
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 Bakerink
river guide Posts:1900
|
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 |
|
|
|
|
BWassink
skipping stones Posts:6
|
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 Nash Posts:5260
|
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 |
|
|
|
|
BWassink
skipping stones Posts:6
|
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 Nash Posts:5260
|
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 |
|
|
|
|
BWassink
skipping stones Posts:6
|
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 To
river guide Posts:2719
|
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 |
|
|
|
|