i remember there is one time where i have to edit an old module where in the date field in sql is not a date data type but instead, it is a char type… they did that because they wanted to store only the month and year of the date in sql… at first it [...]

There are three essential parts in prayer. one is you pray, second is you believe, third is you act. All of these are needed for your prayer to be answered.
You pray, its too obvious this one is needed in prayer. duh?!? but of course you have to know what’s for you and what’s not [...]

I remember last week when i got a free time and ended up reading my friendster profile specifically my friend’s testimonials to me, it was a really great way to spend a dead afternoon. A great time really! I really felt good reading it. I started to realize how I became part of their lives, [...]

I just recently started my technical blog in wordpress.com. I’m just a newbie in my job so you could count my blog post in your fingers. I post evry problems that i encountered in my career as a software developer. I also explained evry details how i manage to solve it. After a few postings, [...]

I had a query once that contains a divide operation….
SELECT   x, y, ROUND(x/y) as quotient
FROM     dataTbl
It always returns a correct value…
but divide by zero error occurs whenever
there is a zero(0) not NULL value in y column…
now, what i want is instead of having
an error, i want it to return a zero(0) value also…
so I wonder if there [...]