Open Script Solution

Sometimes, I have to view special character that could not be displayed directly on my website for the certain reason. For example, when I wanted to share a knowledge about How to Translate Your Blog Title and Description Using qTranslate Plugin then I have to display special tag related to this topic like [:en] which has the special character [ and ]. In order to display the output properly, first of all, I have to convert first those both characters become the HTML Code. In this case, the left square bracket is equal with &-#-91-; (without minus sign between those characters), and the right square bracket is equal to &-#-93-; (without minus sign between those characters). Otherwise, those real characters in the browser view will work as they should be, translating the sentence after that tag based on the language code. It means that I am not be able to display the real character based on their HTML Code if I have not converted them, yet. Another example is, when you want to display the symbol of Copy Rights or Registered. So, here you will find the list of HTML Code belong to the special characters, in order to display the real character in your browser, especially if those characters are being used for such function on your website script. Read more…

I have hundreds of records that need to be imported from one table and database (let’s say that this is the first database) to another table in different database (and the last one is the second database). Unfortunately, one of the columns in the table in first database has the Date value in 10 digits numeral format. For example: 1206980969. Actually, this value equals with March 31, 2008 16:29:29 on UTC. Then, how do I convert that 10 digits numeral to the Data value since the column in the second database is a Date field type? And how do I convert again that date according to my local time? Read more…

A few days ago, a friend of mine asked me for help. He wanted to export his data from Excel file into Access database file. There were about sixteen thousand rows in Excel that have to be exported into Access. One of the columns in that Excel had a Date data. Unfortunately, most of those rows have the 5 digits numeral data, and not in the real Date Value data. For example, there was a row with value ‘38353. As we know, this is not a valid Date, right? Besides that, there is a ‘ character before the value itself. In this case, that value become a String and not a numeral value anymore. Read more…