Adding PostgreSQL Regex Support in CakePHP

In my previous post I commented that CakePHP doesn't like "~" as an operator when building queries for PostgreSQL. Well I got to digging around and found that the fix is relatively simple, however I'm not sure that it follows the Cake intentions. PostgreSQL uses "~", "~", "!~", "!~" as operators for regular expressions. To …



CakePHP, PostgreSQL, and Regex

I was playing with cake and postgresql when I decided I needed to do a search. Sure a classic '%' search would have been sufficient, but we all know I love using regular expressions in sql. Well come to find out it doesn't seem that CakePHP likes PostgreSQL's syntax when using …



Impromptu Quick Fix

Just wanted to make it available that one user reported issues with the height of Impromptu in Safari and Opera. Along with that they also offered a quick fix for those who are able to correct their own until I'm able to revise Impromptu. The fix is to replace the …



Connect to SQL Server from Ubuntu: Part II

A few posts ago I explained how you can connect Ubuntu to SQL Server for PHP. All worked well until you tried to execute stored procedures. (It worked fine if you wrote the query, but not so much with mssql_execute() function). It would result in an error like this: Warning …



Should ODBC Classes have a Syntax Layer?

I don't prefer using an ODBC datasource, but sometimes it is the easiest way to gain access to a database. Often times when using frameworks(php, not sure about others) an odbc option is available, however who knows if it will deliver sql compatible with the database we're trying to …



jQuery Impromptu 2.8 - A Couple Tweaks

I've just released a new version of jQueryImpromptu. This version fixes a bug dealing with 4 or more checkboxes in a prompt. Also version 2.8 changes the Escape key event to rely on the "persistent" option. So if you don't want the prompt to close on Escape you need …



Regular Expressions with XRegExp

Whether you're aware of it or not I love using regular expressions. Something about it just gives me an extra sense of satisfaction and security. However, often I use them on the server side more often than client side for the simple fact that for critical applications it's more reliable …



Connect to SQL Server from Ubuntu

Installing the php5-mssql package in Ubuntu is not as obvious as it should be. I was unable to find it in Synaptic nor apt-get at first. From the install it appears that the package php5-mssql is a virtual package, which really points to php5-sybase. To install php5-mssql for Ubuntu note …



New jQuery Impromptu Show Effect

After a while we all get a little board of seeing the same lame entrance of Impromptu. So this little snippet is to help spice things up a bit by adding a nice fresh entrance effect. Here we will create our own jQuery effect, but we've tailored it to work …



New jQuery Impromptu Theme

It has been a while since I've served up a fresh Impromptu theme, so here goes. I don't think I'll make this the default, however it is based on the default theme with a few minor changes. I'll be adding this to the documentation as well, but here is the …