|
|
|
|
|
|
|
To help you navigate to pages you most recently visited, select from the links below.
|
|
|
Product Forums
|
|
Sharepoint Forums
|
|
Overview on Installing Sharepoint 2007
|
|
Handing File Uploads
|
|
Sharepoint 2007 Custom Web Parts
|
|
Web.Config Entries in the DotNetNuke Framework
|
|
SharePoint / MOSS 2007 RSS Feeds
|
|
DotNetNuke Forum Module - Install & Config
|
|
Why move to DotNetNuke?
|
|
Password Reset Requests
|
|
|
|
|
|
|
|
| Login | Register | Sunday, November 23, 2008
|
|
|
| Data Springs Product Forums...
|
|
|
|
|
| Author |
Messages |
|
Peter
Posts:4
skipping stones
 |
| 08/19/2006 9: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="/js/dnncore.js"></script>
|
|
|
|
|
Chad
Posts:2227
river guide
|
| 08/19/2006 12:39 PM |
|
Peter,
By default the textbox database length for HTML and Respones 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
Posts:2
new to the springs
|
| 08/25/2006 11: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
Posts:2227
river guide
|
| 08/26/2006 8: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
Posts:2
new to the springs
|
| 08/28/2006 4: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)
| |
Change the bolded area above to 3000.
-Ben
|
|
|
|
|
| You are not authorized to post a reply. |
|
|
|
ActiveForums 3.7
|
|
|
|
|
|
|
|
|
|
|