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
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
Hello,
That's because DEWD doesn't support SQL CE. The email section can only be used if you're using SQL Server.
Jeroen
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
is working on a reply...