Copied to clipboard

Flag this post as spam?

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


  • fabrice 104 posts 227 karma points
    Dec 13, 2013 @ 09:39
    fabrice
    0

    Error SQL CE in the email section

    Hello,

    For info, I have tried to check the emails from the custom Email section (SQL CE database) and I have the error :

    ---------------

    "Error running Reader:
    SQL Statement:
    SELECT fromName AS [Sender name], fromEmail AS Sender, toEmail AS Receiver, IsNull(ccEmail, '') As Cc, IsNull(bccEmail, '') AS Bcc, date AS [Date sent], [subject] AS Subject, [message] AS Message
               FROM email
               WHERE [type] = 'Contact'
               ORDER BY id DESC

    Exception:
    System.Data.SqlServerCe.SqlCeException (0x80004005): The number of arguments specified for the function is not correct. [ Minimum argument count = 1, Maximum argument count = 1,Name of function(if known) = IsNull ]
      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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)"

    -----------------

    It seems that ISNULL() function is not implemented in SQL CE. And you use it in Ekponent.Dewd.config :

    SELECT fromName AS [Sender name], fromEmail AS Sender, toEmail AS Receiver, IsNull(ccEmail, '') As Cc, IsNull(bccEmail, '') AS Bcc, date AS [Date sent], [subject] AS Subject, [message] AS Message
                FROM email
                WHERE [type] = 'Contact'
                ORDER BY id DESC

    Best Regards

    Fabrice

     

     

     

     

     

     

  • Jeroen Breuer 4909 posts 12266 karma points MVP 6x admin c-trib
    Dec 13, 2013 @ 09:47
    Jeroen Breuer
    100

    Hello,

    That's because DEWD doesn't support SQL CE. The email section can only be used if you're using SQL Server.

    Jeroen

  • fabrice 104 posts 227 karma points
    Dec 13, 2013 @ 09:54
    fabrice
    1

    Thank you for the precision.

    It works great for me with SQL CE if I just replace IsNull(ccEmail, '') As Cc by "" As Cc (cheap workaround as test)

    Fabrice

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies