Trent Richardson

practical web design & development

Archive for January, 2010

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 its native [...]

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 css attributes for [...]

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: mssql_execute() [function.mssql-execute]: stored [...]