Solving NULL values are recognized as text-values within dynamic queries in PostgresSQL

Posted by Eric Bartels

I’ve written a dynamic query which is finally executed via EXECUTE my_dynamic_query; The query contained a select list in which two columns should always be NULL. — … stuff before dynamic_select_cols := ‘tbl1.foo, tbl1.bar, null AS theAlias1, null AS theAlias2, tbl2.foo2′; — … stuff after combining the dynamic queries EXECUTE my_dynamic_query; In my case the [...]

Using a C# preprocessor directive for testing custom timer-jobs

Posted by Eric Bartels

If your are writing custom timer-jobs for your SharePoint solution it will happen that you write jobs which are only executed once a day or even less often. As a developer you cannot wait that long… You could of course comment in and out (via ctrl + k, ctrl + c / ctrl + k, [...]