Problems with the ContentByQueryWebPart (CQWP) and its ItemXslLink-property

Posted by Eric Bartels

If you ever tried to set the ItemXslLink (which is a normal property of the ContentByQueryWebPart) you will see that sometimes this simply doesn’t work. You get an exception! Object reference not set to an instance of an object Why? The CmsDataFormWebpart.MakeSiteRelativeUrl (which is called somewhere when setting this property) needs the HttpContext.Current which isn’t [...]

How to speed up the deletion of large amounts of list items within SharePoint

Posted by Eric Bartels

If you have code which deletes a lot of items from a SharePoint list (“clear the list”) your best only friend is the ProcessBatchData-Method of the current SPWeb-object. Recycling will slow you down… Every item you delete will be stored in the recycle-bin of your site and later in the recycle-bin of your site-collection. …so [...]

get-Routinen inkl. cachen unter PL/SQL

Posted by Sven Thämar

Dieser Abschnitt befasst sich mit dem Thema des auslesen von Feldinhalten eines Datensatzes einer Tabelle welcher über eine ID (i.d.R der PK) angesprochen wird. Die meisten ermitteln den Inhalt einer Spalte ganz Normal über eine Cursor-Programmierung innerhalb einer Funktion. Das bedeutet, dass für jede Spalte, die ermittelt werden soll, eine Funktion geschrieben wird. Dies erzeugt [...]