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 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…
adminMicrosoft 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…
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…
Terminal server has exceeded maximum number of allowed connection – how to kill open sessions?
When you RDC (connecting remotely using Remote Desktop Connection) to a server and get “Terminal server has exceeded maximum number of allowed connection” message there’s still light at the end of the tunnel. Solution (tested on Windows 2003) RDC to another server in the same workgroup as the one you cannot access and go to…
Reporting Services – deploying RDL files
In this post I’ll describe how to deploy RDL files using Report Manager (more often http://localhost/Reports or http://localhost/Reports$SQLExpress). Note: This description applies to the situation where Microsoft SQL Server is used. Go to Report Manager Too keep all clean, you can create a folder in which you will keep all your reports Create the data…
System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
One of my applications was supposed to use image having its URL. The Image was instantiated with the stream the server that stored the image file responded with after being requested as below: // create a request for image HttpWebRequest request = (HttpWebRequest)WebRequest.Create(IMAGE_URL); request.Method = “GET”; request.ContentType = “multipart/form-data”; request.UserAgent = “Mozilla/4.0+(compatible;+MSIE+5.01;+Windows+NT+5.0”; request.Proxy.Credentials = CredentialCache.DefaultCredentials;…
Exception – ORA-00604: error occurred at recursive SQL level 1 ORA-01003: no statement parsed
In my application data were collected from database (Oracle) using web services that called stored procedures. One of the stored procedure had SELECT defined similar to the one below: WITH sth1 as ( SELECT … ), sth2 as ( SELECT … ) SELECT … This construction was the reason why in my application I was…
How to wait until AJAX call completes in Selenium tests
If you introduce AJAX to the application that is web tested with Selenium your tests might fail from time to time. In my case the tests were failing randomly, not that often but it made their quality decreased. So, how can you fix this? Solution Ideally, what you need is to stop the test execution…
Collection classes in Java
Collections are very important on SCJP exam. It’s useful to remember the following… List ordered (index) duplicates allowed ArrayList fast iteration fast random access; as of Java 1.4 implements RandomAccess interface slower instertion and deletion Vector the same as ArrayList but its metods are synchronized (therefore slower) LinkedList elements are doubly linked to one another;…