Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
Dynamic Registration HTLM Field Error
Last Post 08-28-2006 02:16 PM by Ben Brush. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Peter EdwardsUser is Offline
new to the springs
new to the springs
Posts:3
Avatar

--
08-19-2006 07:27 AM
    Hi All,

    I'm trying to add a custom HTML field but when I update the field I get this error.

    String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DataSprings.Modules.DynamicRegistration.SqlDataProvider.UpdateDynamicQuestion(Guid DynamicQuestionID, Int32 PortalID, Int32 ModuleID, String Question, String HelpText, String QuestionType, Int32 IsRequired, Int32 DNNField, Int32 UserViewable, String OptionType, Int32 SortOrder, Int32 Inactive, String ExampleText, String RequiredFieldText, String DefaultValue, String ShortFieldName, Int32 MaxLength, Int32 UseSQL, String SQLText, String JavaValidation, Int32 IsReadOnly, Int32 IsHidden, Int32 TextboxLength, Int32 PullInQuery, Int32 PushToQuery, Int32 PullInSession, Int32 PushToSession) at DataSprings.Modules.DynamicRegistration.DynamicQuestionController.UpdateDynamicQuestion(DynamicQuestionInfo DInfo) at DataSprings.Modules.DynamicRegistration.DynamicRegistrationQuestions.strSaveTheQuestion()

    I've tried increasing the textbox max length to 999 in case that was 'truncating' it but it didn't help.  Anybody else had this problem? <script src="http://old.datasprings.com/js/dnncore.js"></script>
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    08-19-2006 10:39 AM

    Peter,

    By default the textbox database length for HTML and Response is set to 300 which is causing some issues when the HTML field is more than 300 characters. Please execute the following script which will allow you to have up to 3000 characters.

    Also, if you have a field response that you want more than 300 you can execute the other script.

    This should be done under Host, SQL.
    Alter Table DynamicRegistration_Question
    DROP CONSTRAINT [DF_DynamicRegistration_Question_Question]
    GO
    Alter Table DynamicRegistration_Question
    Alter Column Question nVarchar(3000) Not Null
    GO
    Alter Table DynamicRegistration_Question
    ADD CONSTRAINT [DF_DynamicRegistration_Question_Question] DEFAULT ('') FOR [Question]


    AS far as Question Responses, they are also by default limited to 300 in the current version. We are evaluating if this should be an automatic update in future versions.

    Alter Table DynamicRegistration_QuestionResponse
    Alter Column Response nvarchar(2000) Not Null

    -Chad
    Ben BrushUser is Offline
    new to the springs
    new to the springs
    Posts:2
    Avatar

    --
    08-25-2006 09:45 AM
    I'm in a similar situation with the Help Text limitation of 200 chars. Is there a similar fix for expanding this area?

    Thanks,
    -Ben
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    08-26-2006 06:45 PM
    For Help text you would just need to execute this under Host, SQL. This will allow up to 3000 characters for the field. The field currently allows 255.

    Alter Table DynamicRegistration_Question
    Alter Column HelpText nVarchar(3000) Not Null

    -Chad
    Ben BrushUser is Offline
    new to the springs
    new to the springs
    Posts:2
    Avatar

    --

    Change the bolded area above to 3000.

    -Ben
    08-28-2006 02:16 PM
    Thanks Chad,

    Wanted to add this tidbit for anyone else having this issue. The following file must be updated as well to allow more than 200 characters to be entered:

    dnn\DesktopModules\Dynamic Registration\DynamicRegistrationQuestions.ascx (line 54)

    		<asp:textbox id="txtHelpText" runat="server" Cssclass="NormalTextbox" MaxLength="&#91;b&#93;200&#91;/b&#93;" Width="368px">

    Forums > Product Discussion - DotNetNuke Modules > Dynamic Registration
    ---
  • 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