<?xml version="1.0"?>
<rss version="2.0">
	<channel>
		<title>Aliaspooryorik Musings - Last 20 posts</title>
		<link>http://www.aliaspooryorik.com/blog/</link>
		<description>The thoughts on web development with ColdFusion and Frameworks of John Whish</description>
		<language>en-gb</language>
		<pubDate>Thu, 02 Sep 2010 20:33:26 GMT</pubDate>
		<lastBuildDate>Thu, 02 Sep 2010 20:33:26 GMT</lastBuildDate>
		<docs>http://blogs.law.harvard.edu/tech/rss</docs>
		<copyright>Copyright 2010 http://www.aliaspooryorik.com/</copyright>
		<ttl>120</ttl>
		
			
			
		<item>
			<title>ORM and the Nested Set Model</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/orm-and-the-nested-set-model-240</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[Hibernate]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[Using hibernate ORM&apos;s HQL with the Nested Set Model for storing hierarchical data.]]></description>
			<pubDate>Thu, 12 Nov 2009 13:52:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/240</guid>
		</item>
		
			
			
		<item>
			<title>Getting started with HQL</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/getting-started-with-hql-238</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[Hibernate]]></category>
			
			<category><![CDATA[OOP]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[Hibernate has it&apos;s only query language called HQL. I thought I&apos;d put together some simple examples of how you can use it in your ColdFusion 9 applications.]]></description>
			<pubDate>Thu, 05 Nov 2009 17:49:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/238</guid>
		</item>
		
			
			
		<item>
			<title>cfquery in cfml with parameters</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/cfquery-in-cfml-with-parameters-218</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[Just a quick post about using queries in cfscript with named parameters.]]></description>
			<pubDate>Wed, 15 Jul 2009 16:37:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/218</guid>
		</item>
		
			
			
		<item>
			<title>Replicating MySQL&apos;s LIMIT clause in ColdFusion</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/replicating-mysql-s-limit-clause-in-coldfusion-210</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[Replicating MySQL&apos;s LIMIT clause in ColdFusion]]></description>
			<pubDate>Mon, 08 Jun 2009 16:35:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/210</guid>
		</item>
		
			
			
		<item>
			<title>Scheduled MSSQL Express Backup</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/scheduled-mssql-express-backup-206</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[DevonCFUG]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[Microsoft SQL Server Express is a free slimmed down version of Microsoft SQL Server. One of the features missing from the Express edition is the backup facility, however you can still use the SQL commands.]]></description>
			<pubDate>Thu, 07 May 2009 12:27:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/206</guid>
		</item>
		
			
			
		<item>
			<title>The Definitive Guide to MySQL 5, Third Edition for $10</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/-the-definitive-guide-to-mysql-5-third-edition-for-10-183</link>
			
			<category><![CDATA[Resources]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[In case you don&apos;t know (or don&apos;t check everyday) you may not have spotted that today&apos;s $10 ebook from Apress is The Definitive Guide to MySQL 5, Third Edition]]></description>
			<pubDate>Tue, 27 Jan 2009 11:51:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/183</guid>
		</item>
		
			
			
		<item>
			<title>Transfer ORM Cheat Sheet</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/transfer-orm-cheat-sheet-171</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[Resources]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<category><![CDATA[Transfer]]></category>
			
			<description><![CDATA[A little quick start guide I&apos;ve put together for Transfer ORM]]></description>
			<pubDate>Tue, 09 Dec 2008 10:36:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/171</guid>
		</item>
		
			
			
		<item>
			<title>Installing SQL Server 2008 Express</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/installing-sql-server-2008-express-162</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[Installing SQL Server 2008 Express - you&apos;d think it would be simple, but you&apos;d be wrong! here are the steps you will need to go through (on Windows XP at least!)]]></description>
			<pubDate>Wed, 12 Nov 2008 14:05:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/162</guid>
		</item>
		
			
			
		<item>
			<title>Maximum list values for cfqueryparam</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/maximum-list-values-for-cfqueryparam-159</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[I&apos;ve just managed to get ColdFusion 8 to blow up MS SQL Server 2000! This is the error message I was getting MacromediaSQLServer JDBC Driver The DBMS returned an unspecified error. The command code was 0.]]></description>
			<pubDate>Wed, 22 Oct 2008 15:47:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/159</guid>
		</item>
		
			
			
		<item>
			<title>Use Subqueries - they are fast!</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/use-subqueries-they-are-fast--137</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[Using SQL subqueries can give your huge performance gain over manipulating recordsets with ColdFusion.]]></description>
			<pubDate>Fri, 05 Sep 2008 12:57:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/137</guid>
		</item>
		
			
			
		<item>
			<title>Using Identity insert</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/using-identity-insert-102</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[I was looking at Todd Sharp&apos;s getGeneratedKey function on UDFLib, which returns the identity (auto generated primary key) when you insert data into a database. It works by making use of the result attribute of cfquery, that was introduced in ColdFusion 8. This lead me to think about what ColdFusion was doing under the hood and how you could do it with older versions of ColdFusion.]]></description>
			<pubDate>Thu, 26 Jun 2008 10:59:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/102</guid>
		</item>
		
			
			
		<item>
			<title>Search for  sign in SQL.</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/search-for-sign-in-sql--100</link>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[MS SQL server uses the percentage sign () as a wildcard when you use the like operator. So what if you want to search for the percentage sign?]]></description>
			<pubDate>Wed, 25 Jun 2008 14:50:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/100</guid>
		</item>
		
			
			
		<item>
			<title>My DAOGateway hybrid</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/my-dao-gateway-hybrid-99</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[As a spin off of my post An ORM sceptic a few people have asked me how I handle my database interaction. So here it is...]]></description>
			<pubDate>Thu, 19 Jun 2008 14:35:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/99</guid>
		</item>
		
			
			
		<item>
			<title>Extract Time from DateTime field</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/extract-time-from-datetime-field-97</link>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[I had a problem in MS SQL Server, where I need to do some calculations on the time part of a datetime field, to see how many people had arrived late for the job they were booked for. Normally I&apos;d use the DATEDIFF function in SQL Server. For example&amp;hellip]]></description>
			<pubDate>Mon, 16 Jun 2008 17:35:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/97</guid>
		</item>
		
			
			
		<item>
			<title>cfparam, SQL Server and datatypes</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/cfparam-sql-server-and-datatypes-89</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[This one always catches me out, so once and for all I&apos;m going to post it for future reference! If you use the attribute values of cfsqlnumeric or cfsqldecimal for decimals then they are rounded to the nearest integer.]]></description>
			<pubDate>Mon, 02 Jun 2008 15:07:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/89</guid>
		</item>
		
			
			
		<item>
			<title>Using Query of Queries to improve performance</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/using-query-of-queries-to-improve-performance-86</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[I&apos;m pretty sure that this has been blogged about before but I thought it was important enough to write about as some people may not have seen it or forgotten!I am currently building an application that requires a lot of database interaction. I&apos;ve d&amp;hellip]]></description>
			<pubDate>Wed, 28 May 2008 13:33:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/86</guid>
		</item>
		
			
			
		<item>
			<title>Performance gain with Subquery instead of group</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/performance-gain-with-subquery-instead-of-group-80</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[I&apos;ve often used SubQueries in SQL for filtering data, but I&apos;ve not tried using one in a select statement. I recently had a query that was running slowly due to the number of fields referenced in the group by clause. By changing it to use a SubQuery in the select it has actually reduced the execution time.]]></description>
			<pubDate>Mon, 12 May 2008 16:38:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/80</guid>
		</item>
		
			
			
		<item>
			<title>ClearCode Standards in practice</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/clearcode-standards-in-practice-75</link>
			
			<category><![CDATA[ColdFusion]]></category>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[I&apos;ve just watched Ben Nadel&apos;s thought provoking presentation on Code Standards. I&apos;ve always been a fan of standards, Ben takes this further and talks about how the eye and brain process the code on the screen. As a result I thought I&apos;d try comparing &amp;hellip]]></description>
			<pubDate>Sat, 26 Apr 2008 08:59:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/75</guid>
		</item>
		
			
			
		<item>
			<title>Adding a Not Null column to a table with data</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/adding-a-not-null-column-to-a-table-with-data-55</link>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[If you want to add a column to your database table that already has data in it, then you would normally have to make the new field nullable.-- add new columnALTER TABLE dbo.Products ADD    productgrams int NULLGO-- set default valueU&amp;hellip]]></description>
			<pubDate>Mon, 14 Apr 2008 10:14:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/55</guid>
		</item>
		
			
			
		<item>
			<title>Import from MS SQL 2005 to 2000</title>
			<link>http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/import-from-ms-sql-2005-to-2000-52</link>
			
			<category><![CDATA[SQL]]></category>
			
			<description><![CDATA[Believe it or not you can not restore an MS SQL 2005 Server backup to an MS SQL 2000 Server. This is a major pain and I&apos;ve spent all morning trying to figure out how to get data on a live 2005 box to my local 2000 box.To be honest the easiest soluti&amp;hellip]]></description>
			<pubDate>Tue, 08 Apr 2008 15:49:00 GMT</pubDate>
			<guid isPermaLink="true">http://www.aliaspooryorik.com/blog/index.cfm/e/posts.details/post/52</guid>
		</item>
		
	</channel>
</rss>

		
	

		
	