Month: September 2015

Some scientific actions

A few months ago, myself along with friends, wrote an article to the ICWSM ’06 conference which should have take place in Boukder, USA. The titke of the article was: “E-Learning on the Social Semantic Information Sources”. We wrote quite a few pages but the paper was rejected icon_neutral-6077409 The reviewers stated it was quite good, but needed to be …

Data Transformation Services

Recently, I’ve learned how to write DTS (Data Transformation Services) in SQL Server 2000. In general, this tool allows transformation of data: copying between different databases (by different vendors) and files (Excel, CSV, etc.). The idea is simple; the usage often priceless.

The execution path of a package is defined using a kind of graph, where nodes are tasks to …

Firefox add-ons

Firefox is a powerful web browser; it’s popular since it’s free and offers a great many add-ons and plugins that enhance its capabilities. I decided to present a set of add-ons I use and find useful. They are groupped in a few categories, which facilitates browsing.

Developer tools

Firebug

Great extension that facilitates developing web pages.
It allows inspecting and …

Using PUT and DELETE methods in AJAX requests with prototype.js

Whenerver I write JavaScript I use prototype.js. I find it brilliant, especially when you deal with AJAX. With this library it’s easy to create an AJAX request and process its response from the server.

To send an AJAX request you create a following HTML code:

a link
...
$('ahref').onclick = function() {
    new Ajax.Request('/some_url', {
        method:'get', 
        parameters:'param1=value',
        onSuccess: function(transport){
            var 

Faculty research day

On 16th of April, there will be Faculty of Engineering Research Day at NUI Galway. Researchers will be given possibility to present themselves and what they are making research on. Those who apply shall prepare an abstact and a poster.

I will present my research ideas, regarding my Master’s Thesis and what I working on at DERI: the idea of …

C#, decimal.toString(), and how to get rid of trailing zeros

Today I spend A LOT OF time on trying to display a percentage – string representation of a decimal but without trailing zeros, e.g. 15.1% instead of 15.10%.

In the application I already had NumberFormatInfo for displaying monetary values and percentages. An object of that type was defined as follows:

NumberFormatInfo nfi = new NumberFormatInfo();
nfi.PercentDecimalDigits = 2;
// some 

How to dynamically add new columns to report created with Reporting Services?

Imagine you have a report that displays some data and the number of columns cannot be defined at the design stage, i.e. the number of columns depends on user input. That seems to cause some problems when you want to render this report with Reporting Services…

Solution:

Note: The described solution applies to the case when RDLC files are used …

TSQL – How to select multiple rows into a single row

I spend too long on finding the solution for this problem…

Basically I had a table which looked like this
table-9146579

What I wanted was to select all as one row as a set of items separated with a comma, where an item was ‘id: name’. The items had to be sorted by the id. So the result was supposed to …

Microsoft JScript runtime error: Object doesn't support this property or method.

Yesterday I spent two hours analyzing this issue, which of course I had only with Internet Explorer…

As the background: I wrote a library that would make a table sortable and paginable. I decided to use prototype.js and script.aculo.us. I tried to test the result not only in Firefox which I use by default, but then I simply forgot… Then, …

Reporting Services – problem with passing parameters directly in the URL

In one of the projects I had to create reports (using Reporting Services) that then should be accessible from the application I’ve been developing.

As the first thing I created the reports themselves (RDL files), deployed them using the Report Manager (more often http://localhost/Reports or http://localhost/Reports$SQLExpress), and configured so I could access them. However, each time I accessed a …