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)
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.
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?
Hi Marc-Anthony
What version of Umbraco are you using? And what database?
Looking forward to hearing more from you.
/Jan
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
is working on a reply...