TommyOnDNN
going with the flow
Posts:26
 |
| 05-07-2010 10:32 PM |
|
I'm having some trouble adding a custom HTML field which is supposed to show an End User License Agreement.
The EULA is about 13.000 words.
I've read the post Chad referred to:
http://www.datasprings.com/Products...fault.aspx
However this doesn't fix it truncating after about 2100 words.
I'm using the latest Dynamic Forms release that's available on snowcovered.
Two questions:
- How do I get the custom HTML field to show the complete EULA (+/- 13.000 words)?
- Did I mess something up by running the SQL query in the linked post and do I have to correct something? I ran the query in the last post from Chad in the thread.
|
|
|
|
|
David To
river guide
Posts:2719
|
| 05-08-2010 12:43 PM |
|
HI, did you also do an update? Try to go to host/sql and repeat the following:
alter table dbo.dynamicforms_questionresponse
alter column response nvarchar(max) null
alter PROCEDURE [dbo].[DynamicForms_AddDynamicResponse]
@QuestionID as uniqueidentifier,
@Response as nvarchar(max),
@UserID as integer,
@UniqueResponseID as uniqueidentifier
AS
Insert Into DynamicForms_QuestionResponse (DynamicQuestionID, Response, UserID, UniqueResponseID) Values(@QuestionID, @Response, @UserID, @UniqueResponseID)
alter PROCEDURE [dbo].[DynamicForms_UpdateDynamicResponse]
@DynamicQuestionResponseID uniqueidentifier,
@QuestionID as uniqueidentifier,
@Response as nvarchar(max),
@UserID as integer,
@UniqueResponseID as uniqueidentifier
AS
Update dbo.[DynamicForms_QuestionResponse]
SET Response = @Response,
UserID = @UserID
Where UniqueResponseID = @UniqueResponseID
AND DynamicQuestionID = @QuestionID
This works fine on my test case. I had over 200,000 characters and they appeared fine on my text/html field. -- David
|
|
|
|
|
TommyOnDNN
going with the flow
Posts:26
|
| 05-08-2010 01:17 PM |
|
I'm getting the following error message and unfortunately I'm not knowledgeable at SQL at all.
Msg 111, Level 15, State 1, Procedure DynamicForms_AddDynamicResponse, Line 15
'CREATE/ALTER PROCEDURE' must be the first statement in a query batch. |
|
|
|
|
David To
river guide
Posts:2719
|
| 05-08-2010 02:48 PM |
|
Please execute each one at a time. I listed the three SQL statements you need to execute. Copy and paste each one separately and execute them. DO not copy the entire thing all at once.
DO this first.
alter table dbo.dynamicforms_questionresponse
alter column response nvarchar(max) null
=============================
Then do this:
alter PROCEDURE [dbo].[DynamicForms_AddDynamicResponse]
@QuestionID as uniqueidentifier,
@Response as nvarchar(max),
@UserID as integer,
@UniqueResponseID as uniqueidentifier
AS
Insert Into DynamicForms_QuestionResponse (DynamicQuestionID, Response, UserID, UniqueResponseID) Values(@QuestionID, @Response, @UserID, @UniqueResponseID)
===================================================
Then do this:
alter PROCEDURE [dbo].[DynamicForms_UpdateDynamicResponse]
@DynamicQuestionResponseID uniqueidentifier,
@QuestionID as uniqueidentifier,
@Response as nvarchar(max),
@UserID as integer,
@UniqueResponseID as uniqueidentifier
AS
Update dbo.[DynamicForms_QuestionResponse]
SET Response = @Response,
UserID = @UserID
Where UniqueResponseID = @UniqueResponseID
AND DynamicQuestionID = @QuestionID
=================================================
-- David
|
|
|
|
|
TommyOnDNN
going with the flow
Posts:26
|
| 05-08-2010 08:07 PM |
|
The queries run fine.
However, the Custom HTML Field is still truncating.
When I paste the text in the Custom HTML Field RadEditor, initally the editor states Words:1997 Characters:12209
After I press Update Field, RadEditor says Words:345 Characters:2211
It thought it might be the RadEditor, so I pasted the EULA in a basic textbox, however it still truncates, so it's probably Dynamic Forms that truncates the text. |
|
|
|
|
David To
river guide
Posts:2719
|
| 05-10-2010 03:06 PM |
|
HI, that's very strange because it works fine on my localhost test. If you have SQL management studio, can you verify that the stored procedures and SQL table are in fact set for nvarchar(max) for the "response" column? Also, what version of Dynamic Forms and SQL are you running on? You could also try updating the column with SQL (host / SQL) and see if it will save or not as a test as well. -- David |
|
|
|
|
TommyOnDNN
going with the flow
Posts:26
|
| 05-10-2010 08:19 PM |
|
D ynamic Forms = v3.30.40
SQL = SQL Server 2008 Enterprise Edition
I'm sorry but I'm not knowledgeable at SQL at all so I don't really know how to check the stored procedures.
I figure these are supposed to be in dbo.DynamicForms_QuestionResponse (by looking at the queries I had to run).
When I select "Select Top 1000 rows" in SQL Server Management Studio it doesn't show any data for this table.
When I select "Edit Top 200 Rows" in SSMS it shows:
- DynicQuestionResponseID = NULL
- DynamicQuestionID = NULL
- Response = NULL
- UserID = NULL
- SortOrder = NULL
- InActive = NULL
- ResponseDateTime = NULL
- UniqueResponseID = NULL
|
|
|
|
|
David To
river guide
Posts:2719
|
| 05-11-2010 02:55 PM |
|
HI, under SQL management studio, click on your DNN website database on the "Object Explorer" on the left pane. Then click on / expand the "Tables" and locate table "dynamicforms_questionresponse". Right click on it and choose "Script Table as" then "Script to" and then "New Query editor window". Tell us what you have set for the[Response] column.
Then scroll down the left pane and expand "Programmability" , then expand "Stored Procedures" and locate the two stored procedures "dynamicforms_questionresponse" and "dynamicforms_updatedynamicresponse". Right click on them and script them to a new query editor window as well and tell us what you have for the [Response] column. -- David |
|
|
|
|
TommyOnDNN
going with the flow
Posts:26
|
| 05-12-2010 05:30 AM |
|
Can't find the "Script To" option, however I figure I needed to select "Create To". In the Query Editor window it says [Response] [nvarchar] (max) NULL,
I did not run the query though, since I don't know if it is the correct one (being "Create To" instead of "Script To") and I'm not sure it is supposed to be executed.
For dynamicforms_updatedynamicresponse: @Response as nvarchar(max),
For dynamicforms_questionresponse:
Can't Find it. Only entries I can find that resemble questionresponse are:
- dbo.DynamicForms_GetDynamicQuestionResponsesByDateTime
- dbo.DynamicForms_GetDynamicQuestionResponsesDateTimeAndSummaryField
- dbo.DynamicForms_GetDynamicQuestionResponsesByUniqueResponseID
- dbo.DynamicForms_GetDynamicQuestionResponsesByUniqueIDAndSummaryField
I "Created To" all these four procedures, however I can't find an entry that resembles "Response".
I've looked through all other Dynamic Forms Procedures, however, I can't find the "dynamicforms_questionresponse" procedure.
|
|
|
|
|
David To
river guide
Posts:2719
|
| 05-12-2010 03:03 PM |
|
There's only two stored procedures you need to look at: "dynamicforms_adddynamicresponse" and "dynamicforms_updatedynamicresponse". Make sure the @Response is set for nvachar(max). The "dynamicforms_questionresponse" is the SQL table. Make sure the Response column is also set for nvarchar(max).
-- David |
|
|
|
|
TommyOnDNN
going with the flow
Posts:26
|
| 05-12-2010 07:50 PM |
|
both procedures show:
@Response as nvarchar(max), |
|
|
|
|
David To
river guide
Posts:2719
|
| 05-13-2010 02:56 PM |
|
HI, then is there a way for you to test with the regular DNN Rich Text Editor as opposed to the RAD editor? Also, try a multi-line text box field and see if it will same some long paragraphs that are beyond 13000 words. -- David |
|
|
|
|