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