<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>Project 2061 Techlog</title>
	<link>http://techlog.p2061.org</link>
	<description>Blogging from Project 2061 technology group</description>
	<lastBuildDate>Fri, 05 Mar 2010 23:27:57 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Rewriting URLs on IIS6</title>
		<description><![CDATA[One of the nice things about CakePHP is that it attempts to make a site more friendly to the average web site visitor by creating easier-to-remember URLs. There are a few techniques that CakePHP uses, but for the sake of this conversation we&#8217;ll focus on one way in particular: apache&#8217;s mod_rewrite functionality. Using mod_rewrite, URLs [...]]]></description>
		<link>http://techlog.p2061.org/2010/03/05/rewriting-urls-on-iis6/</link>
			</item>
	<item>
		<title>Moving from Microsoft Access to MySQL</title>
		<description><![CDATA[We recently decided to make a public release of an old web-based application coded in ASP (classic, using VBScript) and using Microsoft Access. In order to make this application public we need to make a few modifications, not the least of which is moving from Microsoft Access to MySQL. Using Microsoft Access on the back-end [...]]]></description>
		<link>http://techlog.p2061.org/2010/02/26/moving-from-microsoft-access-to-mysql/</link>
			</item>
	<item>
		<title>Subversion and Third-Party Code</title>
		<description><![CDATA[Often in the course of developing a project it is desirable to use code from a  third party. The main benefit, of course, is being able to add functionality without developing that functionality from scratch. Some third-party projects we have used in the past include FCKEditor (now CKEditor), the Yahoo! User Interface library, and, more [...]]]></description>
		<link>http://techlog.p2061.org/2009/05/08/subversion-and-third-party-code/</link>
			</item>
	<item>
		<title>CakePHP and CURRENT_TIMESTAMP</title>
		<description><![CDATA[As of cakePHP 1.2.1.8004 you can&#8217;t use CURRENT_TIMESTAMP as the default for a column. With MySQL when the default is set to CURRENT_TIMESTAMP the current date+time is inserted for a new row that doesn&#8217;t specifically define the value of the column.
From what I can tell, when CakePHP specifies the values for all columns when it [...]]]></description>
		<link>http://techlog.p2061.org/2009/04/17/cakephp-and-current_timestamp/</link>
			</item>
	<item>
		<title>Authentication &amp; Authorization with Scaffolding</title>
		<description><![CDATA[Though scaffolding is not recommended for production sites, I&#8217;ve found it quite handy when just getting started. Unfortunately, it doesn&#8217;t appear that the authentication/authorization (auth^2) mechanism works with scaffolding. You can, however, get auth^2 working manually with just a few lines of code.
First, follow the steps of the Simple Acl controlled Application tutorial from the [...]]]></description>
		<link>http://techlog.p2061.org/2009/04/17/authentication-authorization-with-scaffolding/</link>
			</item>
	<item>
		<title>Updates for IE8</title>
		<description><![CDATA[With the release of IE8 getting closer I took a moment to check out our web site and Benchmarks Online in the new browser. As I suspected, the incompatibilities on our web site were of the same ilk as when IE7 was released and required minor updates. The updates to Benchmarks were also fairly minor, [...]]]></description>
		<link>http://techlog.p2061.org/2009/02/20/updates-for-ie8/</link>
			</item>
	<item>
		<title>Excel drops empty columns on CSV export</title>
		<description><![CDATA[I&#8217;m often tasked with getting data from a flat format (Excel, CSV, etc.) into a database. When the format is Excel  and I have only a few files to work with I find it easiest to export the Excel file to CSV or TSV format. This makes it much easier to script the data conversion [...]]]></description>
		<link>http://techlog.p2061.org/2009/02/06/excel-drops-empty-columns-on-csv-export/</link>
			</item>
	<item>
		<title>Internet Explorer blocks Firefox downloads</title>
		<description><![CDATA[When designing the school reports I decided to use a GET request on form submission so that it would be easier to bookmark or share a report. I knew at the time that using GET might cause problems down the road, but the utility/programming trade-off seemed worthwhile.
Long URLs
The main problem with GET is that the [...]]]></description>
		<link>http://techlog.p2061.org/2009/01/16/internet-explorer-blocks-firefox-downloads/</link>
			</item>
	<item>
		<title>CakePHP, Apache, and Ampersands</title>
		<description><![CDATA[I&#8217;m still learning CakePHP. My most recent experimentation is with forms and URL redirecting. In the process I noticed that if the URL includes an ampersand, even in URL-encoded form, CakePHP will read in the URL incorrectly.
In my case, I was taking a form submission and redirecting it to a new page, appending the submitted [...]]]></description>
		<link>http://techlog.p2061.org/2009/01/15/cakephp-apache-and-ampersands/</link>
			</item>
	<item>
		<title>Your float is showing</title>
		<description><![CDATA[Float styling is a useful aspect of CSS &#8230; until it&#8217;s not. When a floated element occurs inside a container and you want it to be wholly in that container you have to resort to hacks to do so. Or do you? Never content to assume that a question has been resolved, I decided to [...]]]></description>
		<link>http://techlog.p2061.org/2008/11/21/your-float-is-showing/</link>
			</item>
</channel>
</rss>
