Check if a Function Exists in Javascript

There are times when we want to call a JavaScript function, and in certain circumstances, we want to make sure that the function does exist. e.g. When a dialog window can be opened from more than one page. And, we want to refresh the component of the the parent page from the dialog window. Thus, we need to check if the function really exists. This...

Read More

The Server Was Unable to Process The Request Due to an Internal Error

Error: Message: The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the...

Read More

Get The First and The Last Day of The Month

Just saw a question from someone on a mailing list I join asking for how to get the transactions occurring for the last three months (in other words, three months from current date). First, you may want to do something simple. To get the first day and the last day of the month, we can use: SELECT DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0), DATEADD(month,...

Read More

Select Several Rows into One Row in SQL

In SQL Server, there are times when we want to consolidate the content of several rows into one row. Though it is not meant for sophisticated purposes, there is actually a simple and easy way to do this. Suppose we have a Member table containing  MemberID and Name fields. To...

Read More