Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Marc-Anthony Taylor 55 posts 68 karma points
    Nov 16, 2012 @ 10:49
    Marc-Anthony Taylor
    0

    SQL Error with Custom DataEditor

    I followed the video to create a custom dataeditor but when I try to enter the char limit on the data type I get the following exception:

     

    Error running NonQuery: 
    SQL Statement:
    insert into cmsDataTypePreValues (datatypenodeid, [value], sortorder, alias) values (@dtdefid, @value,0,' '))

    Exception:
    System.Data.SqlServerCe.SqlCeException: There was an error parsing the query. [ Token line number = 1,Token line offset = 109,Token in error = ) ]
      at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
      at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
      at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
      at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
      at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

     

    Any ideas?

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Nov 17, 2012 @ 04:00
    Jan Skovgaard
    0

    Hi Marc-Anthony

    What version of Umbraco are you using? And what database?

    Looking forward to hearing more from you.

    /Jan

  • Marc-Anthony Taylor 55 posts 68 karma points
    Nov 17, 2012 @ 10:19
    Marc-Anthony Taylor
    0

    Hi Jan

    Thank you so much for the reply! Although I thought I had deleted this question as I found my mistake (an extra parentheses in the string at the end of the query) shortly after posting it. Sorry about that.

    I'm looking forward however to taking part in the community.

    Cheers,

    Marc-Anthony

Please Sign in or register to post replies

Write your reply to:

Draft