Archive for the ‘Programming’ Category
The web is a global resource for anything, anywhere, any timezone. But often times we are careless in consideration for people in other areas of the world. The different timezones offset people’s schedules from one area to the next. When handling user profiles (or anything for that matter) where date and time [...]
I had an opportunity recently to get back to a little design work with a local flooring company, Waccamaw Floor Covering. I had fun with it but I also tried to integrate a few new things I’ve not done in the past, everything from seo, flowplayer, to google maps (street view). In the [...]
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 [...]
Connect to SQL Server from Ubuntu: Part II
11 Jan
Posted by: trent in: Database, Linux, PHP, Programming
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 [...]
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 gain access to. I’ll [...]

