I was developing a telecommunication bill using Jasper Studio (V6.0.4) on Windows and Jasper Server (V6.0.1) which was remotely hosted on an Ubuntu server. Jasper Studio was used to design layout while Jasper Server was in charge of generating final
Postgresql debugger
It took me a while to figure out how to enable debugger for Postgresql server on Ubuntu. Initially I thought it was pre-packaged by Ubuntu therefore apt-get installed a few packages such as pgadmin3, pgadmin3-dev, postgresql-version.dbg. Here is a post
PHP debugging
I recently came cross debugging in PHP. I know from my own experience that a lot of people are still using echo/print, var_dump to debug code. Nothing wrong but sometimes when you scratch you head wondering what’s inside that tiny
Building a web site using PHP on IIS/SQL server using Windows authentication.
PHP+IIS, although not a popular combination, it may be the easiest solution in a corporate departmental environment, which is largely Windows based. PHP programming won’t be discussed here, rather I’d discuss how Windows authentication is achieved. The beautify of Windows
SQL server computed field
I recently came across this very interesting rounding issue in MS SQL server. Originally I thought in order to keep computation in highest accuracy possible, I should use the max allowed precision, i.e. on SQL server a decimal(38,18). However after definition of
ACL 10.5 new features
I recently upgraded my ACL ( a data analysis tool widely used by IT auditors) to 10.5 and noticed there are a number of new functions introduced. EOMONTH( ): Returns the date of the last day of the month that
dropdown list using AJAX and Laravel
On my website, I want to display a drop-down list of cars, from which once the item(car) is chosen, the corresponding car’s price is retrieved from DB. The challenges are: 1. car price is just part of the screen 2. car price
Microstrategy metrics relationship
Today I had a Microstrategy reporting problem: on my report there are two metrics, one is total number of incidents and attribute month; the other is total amount of payments received.They come from two different tables and have no relationship
Some thoughts about WordPress security
In general, WordPress blogs are not considered to contain much sensitive data therefore the default behavior of using user name and password suits most bloggers. However there are cases you want to enhance this default security a bit, below are
WordPress Theme – Spacious part 2
This is another post about theme Spacious. Spacious shortens all posts on front page(excerpt), this makes the front page tidy however I want to control how much to show instead of the default(55 words). Thought there would be an option