jqGrid Documentation

The link is for jgGrid 3.4 version

This is a good source of information for all developers who are using jQuery jqGrid plugin.

MS SQL Military and Standard Time Format

There are times that you want to display non-Military or AM/PM time format. The standard Convert formats do not have an option to return the time in this format. The SQL below will return only the time portion of the current date/time in the AM/PM format.



SELECT substring(convert(varchar(20), GetDate(), 9), 13, 5) + ' ' + substring(convert(varchar(30), GetDate(), 9), 25, 2)<br />


However, when you want to retrieve the military time format:



SELECT CONVERT(CHAR(10),GETDATE(),108)



You can replace the GetDate function with any datetime field to return the time portion of that field.

Web Page Optimization

A good reference for overall site speed:

Best Practices for Speeding Up Your Web Site at Yahoo

It describes some important techniques in keeping a site loading quickly.

Philippine Holidays for 2009

Gloria Macapagal Arroyo signs Philippine Proclamation no. 1699 outlining the Philippine Holidays for 2009. Isn't it great to live in the Philippines as you get more holidays.

Check this out: Proclamation no. 1699

Start of Something Good

Now those who had been scattered went about preaching the word. – Acts 8:4

When Margaret first came to the U.S., she didn’t speak English well. She needed money so she went out looking for a job. She lied about her age so she could be hired as a waitress. After going through several jobs, she became the head waitress at a vegetarian hotel in New York.She took up law and after graduating in 1976, she found it difficult to find a good job. She was Asian and there were very few Asian women practicing law. She got fired several times but each time she learned something. Now, she is a successful immigration lawyer and has her own law firm.In today’s first reading, a severe persecution of the church broke out in Jerusalem. The Christians were scattered “throughout the countryside of Judea and Samaria.” But their sufferings brought about the spreading of the Gospel. We may not understand why things happen. They may appear to be tragedies or misfortunes but God can bring good out of it in order to fulfill His purposes. We just have to trust His heart for He knows what’s best. - by Judith Concepcion

REFLECTION: Are you suffering right now? Maybe God is working something in you. He will bring great results out of your suffering.

Lord, help me to trust in You

WAIT

 People nowadays would prefer to accomplish many things within a short period of time. They treat time as something very precious and valuable. Some of them would even prefer to shorten their meal times by eating instant and ready-to-eat food so that they can save time. Students also have a quick, easy and instant access to information through the Internet. This would require them a smaller amount of time to spend in research. These are just some realities that make our lives more convenient. These realities spare us from waiting for a long time to accomplish things through the long and traditional processes.

But there are certain tasks in life that require us to take the long process and wait. And I think this is what Jesus was referring to when He said, "Ask and it will be given to you, search and you will find, knock and the door will be opened to you." When Jesus said these words, He does not mean that we can easily get what we pray for, just like eating instant noodles. When we come to meet Jesus in prayer and ask for something, He does not readily give us the answer to our prayer. Instead, He gives us certain situations in life that form part of the process in achieving what we pray for.

Why does God want us to undergo the long process? Perhaps it is because He wants to teach us something that we might miss if He would readily give us the answer to our prayers. It is the waiting and going through the process that matter most. We are not mere passive recipients. And this is what Jesus taught us. In the desire of God to save us from our sins, He chose to undergo the long process of becoming man like us. He chose to suffer and to experience the excruciating pains as He was nailed to the cross. God had the option to save us by just a single stroke of His hand. But He did not choose that. He chose to wait and to undergo the long and hard process so that people may truly learn and believe in Him. Fr. Joel O. Jason

 
 

Reflection Questions:

How willing am I to wait and to choose the long process?

 
 

Lord, help me to learn Your ways. May I be patient enough to wait and to choose the long process so that I may learn more the lessons You want to teach me. Amen.

Closing Cycles

By Paulo Coelho


One always has to know when a stage comes to an end. If we insist on
staying longer than the necessary time, we lose the happiness and the
meaning of the other stages we have to go through.

Closing cycles, shutting doors, ending chapters whatever name we give
it, what matters is to leave in the past the moments of life that have
finished. Did you lose your job? Has a loving relationship come to an
end? Did you leave your parents' house? Gone to live abroad? Has a
long-lasting friendship ended all of  sudden?

You can spend a long time wondering why this has happened. You can tell
yourself you won't take another step until you find out why certain
things that were so important and so solid in your life have turned into dust, just like that. But such an attitude will be awfully stressing for everyone involved: your parents, your husband or wife, your friends, your children, your sister, everyone will be finishing chapters, turning over new leaves, getting on with life, and they will all feel bad seeing you at a standstill.

None of us can be in the present and the past at the same time, not even when we try to understand the things that happen to us. What has passed will not return: we cannot for ever be children, late adolescents, sons that feel guilt or rancor towards our parents, lovers who day and night relive an affair with someone who has gone away and has not the least intention of coming back.

Things pass, and the best we can do is to let them really go away. That
is why it is so important (however painful it maybe!) to destroy souvenirs, move, give lots of things away to orphanages, sell or donate
the books you have at home.

Everything in this visible world is a manifestation of the invisible
world, of what is going on in our hearts and getting rid of certain
memories also means taking some room for other memories to take their place.

Let things go. Release them. Detach yourself from them. Nobody plays
this life with marked cards, so sometimes we win and sometimes we lose.
Do not expect anything in return, do not expect your efforts to be appreciated, your genius to be discovered, your love to be understood. Stop turning on your emotional television to watch the same program over and over again, the one that shows how much you suffered from a certain loss: that is only poisoning you, nothing else. Nothing is more dangerous than not accepting love relationships that are broken off, work that is promised but there is no starting date, decisions that are always put off waiting for the ideal moment. Before a new hapter is begun, the old one has to be finished: tell yourself that what has passed will never come back. Remember that there was a time when you could live without that thing or that person. Nothing is irreplaceable. A habit is not a need. This may sound so obvious, it may even be difficult, but it is very important.

Closing cycles. Not because of pride, incapacity or arrogance, but
simply because that no longer fits your life. Shut the door, change the
record, clean the house, shake off the dust. Stop being who you were,
and change into who you are.