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 available too [not demo’d] DataModelBrowser to apis.mesh.com; showing REST/JSON/APP…

1

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 a simple matter of adding some extra SQL to the INSERT statement, and popping the…

2

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. As the SQLServer drivers change, I will update this…

1

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 import data into my new SQLServer database:   Having previously installed the MySQL…

1

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, I exported the tables as SQL; and specifically ANSI SQL:…

3