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 4860 posts 12121 karma points MVP 3x 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

Please Sign in or register to post replies

Write your reply to:

Draft