<?xml version="1.0" encoding="UTF-8"?><rss version="0.92">
<channel>
	<title>devbox@COMPUTEC</title>
	<link>http://devbox.computec.de</link>
	<description>The Computec development blog</description>
	<lastBuildDate>Fri, 25 Nov 2011 08:16:48 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	<!-- generator="WordPress/3.2.1" -->

	<item>
		<title>ColdFusion vs. Railo on &lt;cftransaction action=&#8221;rollback&#8221;&gt;</title>
		<description><![CDATA[While migrating one of our ColdFusion 8 servers to Railo I stumbled over a small problem with the cftransaction tag today. Consider this snippet of code: &#60;cftransaction action=&#34;begin&#34;&#62; &#60;cftry&#62; &#60;cfquery name=&#34;variables.qTestQuery&#34; datasource=&#34;#variables.strDs#&#34;&#62; SELECT version(); &#60;/cfquery&#62; &#60;cfcatch type=&#34;database&#34;&#62; &#60;cftransaction action=&#34;rollback&#34;&#62; &#60;/cfcatch&#62; &#60;/cftry&#62; &#60;/cftransaction&#62; Done. This was running fine on ColdFusion 8.0.1, Railo 3.1.2.019 on the other [...]]]></description>
		<link>http://devbox.computec.de/2010/08/coldfusion-vs-railo-on-cftransaction-actionrollback/?utm_source=rss&#038;utm_medium=rss&#038;utm_campaign=coldfusion-vs-railo-on-cftransaction-actionrollback</link>
			</item>
	<item>
		<title>Coldfusion UDF to create &amp; CHMOD a full directory path</title>
		<description><![CDATA[The following problem has come up during a file caching implementation: We've got a directory /var/www/MYCACHE; our filecaching mechanism uses a key-based directory structure to store files there. So let's suppose our key would be 123456789, we'd like to store the file 123456789.cache under /var/www/MYCACHE/123/123456/123456789.cache. This would make sure that no directory needs to hold [...]]]></description>
		<link>http://devbox.computec.de/2010/07/coldfusion-udf-to-create-chmod-a-full-directory-path/?utm_source=rss&#038;utm_medium=rss&#038;utm_campaign=coldfusion-udf-to-create-chmod-a-full-directory-path</link>
			</item>
	<item>
		<title>ColdFusion 8 CHF4 [doesn&#039;t] break CFIMAGE [UPDATE]</title>
		<description><![CDATA[UPDATE 2: There is actually an issue with ColdFusion Cumulative Hotfix 4, though it's not the Hotfix itself, it's the installation instructions explicitly telling you to skip installing another hotfix if you're not on JVM 1.5. Don't skip installing hf801-71557, even when you're on JVM 1.6 - that has fixed it with our installation. There [...]]]></description>
		<link>http://devbox.computec.de/2010/07/coldfusion-8-chf4-breaks-cfimage/?utm_source=rss&#038;utm_medium=rss&#038;utm_campaign=coldfusion-8-chf4-breaks-cfimage</link>
			</item>
	<item>
		<title>ColdFusion: Get date from Unix timestamp</title>
		<description><![CDATA[A quick followup on a previous post ColdFusion UDF to get Unix timestamp from date: Here's a oneliner that provides you with the complimentary function to get a date from a Unix timestamp - as I've discovered that the dateAdd() route mostly recommended on the net not only suffers from being quite clumsy, the result [...]]]></description>
		<link>http://devbox.computec.de/2010/07/coldfusion-oneliner-to-get-a-date-from-a-unix-timestamp/?utm_source=rss&#038;utm_medium=rss&#038;utm_campaign=coldfusion-oneliner-to-get-a-date-from-a-unix-timestamp</link>
			</item>
	<item>
		<title>String methods: ColdFusion vs. Java</title>
		<description><![CDATA[You may know from previous blog posts that I strongly advise every ColdFusion developer to familiarize himself/herself with the thing that actually makes ColdFusion tick, i.e. with Java. Everybody who writes a single line of CFML should know about the possibilities of extending ColdFusion by directly accessing the underlying Java methods of certain objects. One [...]]]></description>
		<link>http://devbox.computec.de/2010/07/string-methods-coldfusion-vs-java/?utm_source=rss&#038;utm_medium=rss&#038;utm_campaign=string-methods-coldfusion-vs-java</link>
			</item>
	<item>
		<title>ColdFusion 8 and MySQL 5.1 via JDBC: Help needed! [Solved]</title>
		<description><![CDATA[UPDATE: We have now found the cause of the issue. Please scroll to the end of the article for explanation and workaround. In one of our latest projects we need to access a MySQL 5.1 server (5.1.45) from ColdFusion 8 (8,0,1,195765). Creating the datasource was no problem, the datasource does verify okay - but there [...]]]></description>
		<link>http://devbox.computec.de/2010/06/coldfusion-8-and-mysql-5-1-via-jdbc-help-needed/?utm_source=rss&#038;utm_medium=rss&#038;utm_campaign=coldfusion-8-and-mysql-5-1-via-jdbc-help-needed</link>
			</item>
	<item>
		<title>ColdFusion UDF to get Unix Timestamp from Date</title>
		<description><![CDATA[For some legacy MySQL database application I really need Unix timestamps - and I need them in ColdFusion, so MySQL's UNIX_TIMESTAMP just wasn't sufficient for the job. At first I thought I could get away with a simple DateDiff - and the result did look plausible. A closer look revealed however that there is probably [...]]]></description>
		<link>http://devbox.computec.de/2010/05/coldfusion-udf-to-get-unix-timestamp-from-date/?utm_source=rss&#038;utm_medium=rss&#038;utm_campaign=coldfusion-udf-to-get-unix-timestamp-from-date</link>
			</item>
	<item>
		<title>ColdFusion UDF to generate SEO-friendly URL strings</title>
		<description><![CDATA[This function might be convenient if you need to create a seo-friendly URL from a headline that could contain special characters such as German umlauts or accented letters; spaces would be replaced by dashes as recommended by Matt Cutts of Google. Unrecognized characters in a certain Unicode range will finally be replaced by x's, everything [...]]]></description>
		<link>http://devbox.computec.de/2010/05/coldfusion-udf-to-generate-seo-friendly-url-strings/?utm_source=rss&#038;utm_medium=rss&#038;utm_campaign=coldfusion-udf-to-generate-seo-friendly-url-strings</link>
			</item>
	<item>
		<title>PostgreSQL DBA Snippet: Largest Tables in a Database</title>
		<description><![CDATA[For my own reference - this little query will list all the tables in the current database with their respective physical size, including indexes and TOAST: SELECT table_schema , TABLE_NAME , pg_size_pretty&#40;pg_total_relation_size&#40;table_schema &#124;&#124; '.' &#124;&#124; TABLE_NAME&#41;&#41; , pg_total_relation_size&#40;table_schema &#124;&#124; '.' &#124;&#124; TABLE_NAME&#41; FROM information_schema.TABLES WHERE table_type = 'BASE TABLE' ORDER BY pg_total_relation_size DESC;]]></description>
		<link>http://devbox.computec.de/2010/05/postgresql-dba-snippet-largest-tables-in-a-database/?utm_source=rss&#038;utm_medium=rss&#038;utm_campaign=postgresql-dba-snippet-largest-tables-in-a-database</link>
			</item>
	<item>
		<title>Full-text search with ColdFusion using Sphinx</title>
		<description><![CDATA[A thorough tutorial on using the Sphinx search engine for ColdFusion developers, from compilation and setup to using the Java Sphinx API in a CFC.]]></description>
		<link>http://devbox.computec.de/2010/05/full-text-search-with-coldfusion-using-sphinx/?utm_source=rss&#038;utm_medium=rss&#038;utm_campaign=full-text-search-with-coldfusion-using-sphinx</link>
			</item>
</channel>
</rss>

