Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...


Or... now make it easy with Facebook Integration
Connect via Facebook



Top Sellers

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

Dynamic Registration HTLM Field Error
Last Post 08-28-2006 02:16 PM by Ben Brush. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
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">
    You are not authorized to post a reply.


     
     

    Join our mailing list...

    Get current news and events the easy way
     
     
       
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • 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