Blog
PostgreSQL – Selecting the Newest Records
One of the things that I often had a difficult time with was finding a way to select the newest records from a table that had one or more columns to group by and then one column to order by. Read more…
Blog
OpenKM Scripting – Creating Folders
We recently had the need to create hundreds of folders but didn’t want to do so manually. Unfortunately, this wasn’t as easy as simply going into the database and adding them. Fortunately, it was as easy as using the following Read more…
Blog
JScript – Select Parent Folder
A while back, I wanted to have a script that would select a file or a folder in Windows Explorer. The following JScript selects the parent folder of the script that is run within Windows Explorer: For instance, if the Read more…
Blog
PostgreSQL – Convert A String Into A Table
Recently at work we had the need to convert a string parameter (passed into an iReport) into a table. For many people, the first thing that may come to mind is either the STRING_TO_ARRAY(...) function combined with the UNNEST(...) function. Read more…
Blog
PostgreSQL – Granting Access To All Functions
Now to grant all access for roles on all of the functions in the database, you can use a query such as the following: After running this query, you will have all of the GRANT statements that are needed to Read more…
Blog
PostgreSQL – Granting Access To All Sequences
Once again, since the DBA is on vacation today, I have to assume some of his duties. It seems that nobody has access to anything in the development databases. After granting them permissions to all of the tables in the Read more…
Blog
Unbreakable Encryption Technique
That’s right! As of right now, I have a totally open source, unbreakable encryption tool available to the masses called Crypter. What Is Meant By Unbreakable The only way that I can conceive of breaking any of the encryption methods Read more…
Blog
POW Answer – Fixing Compilable JavaScript Code
The following answers the Problem of the Week from May 14, 2012: At first glance, it may seem that the following would be the solution: Unfortunately, the above results in true being returned. In order to get false to be Read more…
Blog
POW – Fixing Compilable JavaScript Code
Many JavaScript/JScript developers use Google Closure Compiler to compile their code. Even though this tool is a great way of minifying JavaScript code, believe it or not, it doesn’t always work (at least as of May 14, 2012). The following Read more…
Blog
POW Answer – 0.999999 Repeating Equals One?
The following answers the Problem of the Week from May 7, 2012: One of the simplest ways to prove that 0.999999 = 1 is by doing the following: 0.333333 = 1 / 3 3 × (0.333333) = 3 × (1 Read more…