basketweaving for the mind

Demos and Links from Edge of the Web, Nov’08 Perth

During the 50 minutes of presentation (including at least 9 ICHC images), I demonstrated the following bits and pieces of open source and or free Microsoft bits. Demo set 1: Web Standards Live Mesh Mobile : take photo to mesh on laptop MacOS X 10.5 client Read More...

Posted Tuesday, November 11, 2008 1:08 PM by nhodge | 1 Comments

October 2008 Update: Microsoft SQL Server 2005 Driver for PHP

Now available, prebuilt is available for download Source is also available from Codeplex: CodePlex Read More...

Posted Monday, October 20, 2008 8:44 AM by nhodge | 0 Comments

SQL Server Driver for PHP: Last Inserted Row ID

After a mysql_query with an INSERT statement, a quick call to mysql_insert_id provides the ID of the last inserted row. $lastRow = mysql_insert_id($link); How do you accomplish the same with the SQL Server Driver for PHP? In this extended example, it’s Read More...

Posted Tuesday, September 23, 2008 12:56 AM by nhodge | 1 Comments

SQL Server Driver PHP commands compared with MySQL PHP commands

Over the years I have used the inbuilt PHP drivers for MySQL. The best mechanism for mapping the two methods is a simple table laying out a comparison between the two systems. Note this is not a SQLServer vs. MySQL argument, just for information and reference. Read More...

Posted Monday, September 22, 2008 5:20 PM by nhodge | 1 Comments

MySQL to SQLServer 2008 Express [redux]

Last week, the SQLServer 2008 Express team released a download with the SQL Server Management Studio . A few weeks ago, I blogged how to export/import the .sql from one system to another . Having installed the Management Studio, I noticed that I could Read More...

Posted Monday, September 01, 2008 4:58 PM by nhodge | 1 Comments

MySQL to SQLServer [Express] 2008

Being a historical LAMP guy, the first problem is how do I get my data across? The release of free SQLServer Express 2008 , with the integration with Vista x64, PHP and Visual Studio is an attractive proposition. But: schema and data first. 1. Using PHPMyAdmin Read More...

Posted Monday, August 18, 2008 4:44 PM by nhodge | 3 Comments