<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>Little Handy Tips</title>
	
	<link>http://littlehandytips.com</link>
	<description>Helping you save time and be more productive</description>
	<lastBuildDate>Sun, 29 Jan 2012 00:53:41 +0000</lastBuildDate>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=</generator>
		<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/LittleHandyTips" /><feedburner:info uri="littlehandytips" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><image><link>http://littleHandyTips.com</link><url>http://littlehandytips.com/wp-content/themes/arthemia/images/logo-medium.gif</url><title>Little Handy Tips</title></image><feedburner:emailServiceId>LittleHandyTips</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><feedburner:feedFlare href="http://add.my.yahoo.com/rss?url=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://us.i1.yimg.com/us.yimg.com/i/us/my/addtomyyahoo4.gif">Subscribe with My Yahoo!</feedburner:feedFlare><feedburner:feedFlare href="http://www.newsgator.com/ngs/subscriber/subext.aspx?url=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://www.newsgator.com/images/ngsub1.gif">Subscribe with NewsGator</feedburner:feedFlare><feedburner:feedFlare href="http://www.bloglines.com/sub/http://feeds.feedburner.com/LittleHandyTips" src="http://www.bloglines.com/images/sub_modern11.gif">Subscribe with Bloglines</feedburner:feedFlare><feedburner:feedFlare href="http://www.netvibes.com/subscribe.php?url=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://www.netvibes.com/img/add2netvibes.gif">Subscribe with Netvibes</feedburner:feedFlare><feedburner:feedFlare href="http://fusion.google.com/add?feedurl=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://buttons.googlesyndication.com/fusion/add.gif">Subscribe with Google</feedburner:feedFlare><feedburner:feedFlare href="http://www.pageflakes.com/subscribe.aspx?url=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://www.pageflakes.com/ImageFile.ashx?instanceId=Static_4&amp;fileName=ATP_blu_91x17.gif">Subscribe with Pageflakes</feedburner:feedFlare><feedburner:feedFlare href="http://www.plusmo.com/add?url=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://plusmo.com/res/graphics/fbplusmo.gif">Subscribe with Plusmo</feedburner:feedFlare><feedburner:feedFlare href="http://www.thefreedictionary.com/_/hp/AddRSS.aspx?http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://img.tfd.com/hp/addToTheFreeDictionary.gif">Subscribe with The Free Dictionary</feedburner:feedFlare><feedburner:feedFlare href="http://www.bitty.com/manual/?contenttype=rssfeed&amp;contentvalue=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://www.bitty.com/img/bittychicklet_91x17.gif">Subscribe with Bitty Browser</feedburner:feedFlare><feedburner:feedFlare href="http://www.live.com/?add=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://tkfiles.storage.msn.com/x1piYkpqHC_35nIp1gLE68-wvzLZO8iXl_JMledmJQXP-XTBOLfmQv4zhj4MhcWEJh_GtoBIiAl1Mjh-ndp9k47If7hTaFno0mxW9_i3p_5qQw">Subscribe with Live.com</feedburner:feedFlare><feedburner:feedFlare href="http://mix.excite.eu/add?feedurl=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://image.excite.co.uk/mix/addtomix.gif">Subscribe with Excite MIX</feedburner:feedFlare><feedburner:feedFlare href="http://www.webwag.com/wwgthis.php?url=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://www.webwag.com/images/wwgthis.gif">Subscribe with Webwag</feedburner:feedFlare><feedburner:feedFlare href="http://www.podcastready.com/oneclick_bookmark.php?url=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://www.podcastready.com/images/podcastready_button.gif">Subscribe with Podcast Ready</feedburner:feedFlare><feedburner:feedFlare href="http://www.wikio.com/subscribe?url=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://www.wikio.com/shared/img/add2wikio.gif">Subscribe with Wikio</feedburner:feedFlare><feedburner:feedFlare href="http://www.dailyrotation.com/index.php?feed=http%3A%2F%2Ffeeds.feedburner.com%2FLittleHandyTips" src="http://www.dailyrotation.com/rss-dr2.gif">Subscribe with Daily Rotation</feedburner:feedFlare><item>
		<title>Google+ Cheat Sheet</title>
		<link>http://feedproxy.google.com/~r/LittleHandyTips/~3/4tPUFERnCLY/</link>
		<comments>http://littlehandytips.com/google-cheat-sheet/#comments</comments>
		<pubDate>Mon, 17 Oct 2011 22:10:16 +0000</pubDate>
		<dc:creator>Edwin Kwan</dc:creator>
				<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://littlehandytips.com/?p=1186</guid>
		<description><![CDATA[Cheat Sheet to formatting your status updates on Google+.
]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>Found this on the web a while back and figured its a good reference to share.</p>
<p><a href="http://littlehandytips.com/wp-content/uploads/2011/10/English.jpg"><img class="alignnone size-full wp-image-1187" title="Google+ Cheat Sheet" src="http://littlehandytips.com/wp-content/uploads/2011/10/English.jpg" alt="" width="540" height="531" /></a></p>
<div class="shr-publisher-1186"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic -->
<p><a href="http://feedads.g.doubleclick.net/~a/DZohLQ1NMiwn9g_IcEsrrE9PwTA/0/da"><img src="http://feedads.g.doubleclick.net/~a/DZohLQ1NMiwn9g_IcEsrrE9PwTA/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/DZohLQ1NMiwn9g_IcEsrrE9PwTA/1/da"><img src="http://feedads.g.doubleclick.net/~a/DZohLQ1NMiwn9g_IcEsrrE9PwTA/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=4tPUFERnCLY:2HiA6Zg0oIM:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=4tPUFERnCLY:2HiA6Zg0oIM:-BTjWOF_DHI"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=4tPUFERnCLY:2HiA6Zg0oIM:-BTjWOF_DHI" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=4tPUFERnCLY:2HiA6Zg0oIM:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=4tPUFERnCLY:2HiA6Zg0oIM:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=4tPUFERnCLY:2HiA6Zg0oIM:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=4tPUFERnCLY:2HiA6Zg0oIM:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=4tPUFERnCLY:2HiA6Zg0oIM:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=4tPUFERnCLY:2HiA6Zg0oIM:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=4tPUFERnCLY:2HiA6Zg0oIM:F7zBnMyn0Lo" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/LittleHandyTips/~4/4tPUFERnCLY" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://littlehandytips.com/google-cheat-sheet/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://littlehandytips.com/google-cheat-sheet/</feedburner:origLink></item>
		<item>
		<title>reCAPTCHA – Stop Spam, Read Books</title>
		<link>http://feedproxy.google.com/~r/LittleHandyTips/~3/5Z0OnPT0Z88/</link>
		<comments>http://littlehandytips.com/recaptcha-stop-spam-read-books/#comments</comments>
		<pubDate>Tue, 11 Oct 2011 08:21:22 +0000</pubDate>
		<dc:creator>Edwin Kwan</dc:creator>
				<category><![CDATA[Computers]]></category>
		<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://littlehandytips.com/?p=1177</guid>
		<description><![CDATA[You're probably come across the image above quite a number of times. It's usually used when filling up a form to validate that you are a human being and not a spam bot. However did you know that it is also a service that helps to digitize books, newspapers and old time radio shows? Well, neither did I.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p><a href="http://littlehandytips.com/wp-content/uploads/2011/10/stop-spam-read-books.png"><img class="alignnone size-full wp-image-1178" title="stop-spam-read-books" src="http://littlehandytips.com/wp-content/uploads/2011/10/stop-spam-read-books.png" alt="" width="332" height="144" /></a></p>
<p>You&#8217;re probably come across the image above quite a number of times. It&#8217;s usually used when filling up a form to validate that you are a human being and not a spam bot. However did you know that it is also a service that helps to digitize books, newspapers and old time radio shows? Well, neither did I.</p>
<p>About 200 million CAPTCHAs are solved by humans around the world every day. In each case, roughly ten seconds of human time are being spent. Individually, that&#8217;s not a lot of time, but in aggregate these little puzzles consume more than 150,000 hours of work each day. That effort is spent into reading books.</p>
<p>Physically books which are being digitised are scanned and read using &#8220;Optical Character Recognition&#8221; (OCR). However OCR is not perfect and so the words which it can&#8217;t identify are being used in reCAPTCHA for a human to identify.</p>
<p>So how does it detect a bot if it can&#8217;t identify the word itself? Well it does so by presenting you with two words, the word it doesn&#8217;t know and a word which is knows. If the user solves the word for which the system knows, then the system assumes the answer is correct for the new word. Pretty neat ah?</p>
<h3>Play a part in digitising the books</h3>
<p><strong>If you run a website</strong> that suffers from problems with spam, you can <a href="http://www.google.com/recaptcha/whyrecaptcha">put reCAPTCHA on your site</a>. For some applications (such as <a href="http://code.google.com/apis/recaptcha/docs/wordpress.html">WordPress</a> and <a href="http://code.google.com/apis/recaptcha/docs/mediawiki.html">Mediawiki</a>), there are <a href="http://code.google.com/apis/recaptcha">plugins</a> that allow you to use reCAPTCHA without writing any code. There are also easy-to-use code for common web programming languages such as <a href="http://code.google.com/apis/recaptcha/docs/php.html">PHP</a>.</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<div class="shr-publisher-1177"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic -->
<p><a href="http://feedads.g.doubleclick.net/~a/ttnpifVUvHuD5vRzEJvrKuHH3Qs/0/da"><img src="http://feedads.g.doubleclick.net/~a/ttnpifVUvHuD5vRzEJvrKuHH3Qs/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/ttnpifVUvHuD5vRzEJvrKuHH3Qs/1/da"><img src="http://feedads.g.doubleclick.net/~a/ttnpifVUvHuD5vRzEJvrKuHH3Qs/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=5Z0OnPT0Z88:iTM6Qghxmgg:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=5Z0OnPT0Z88:iTM6Qghxmgg:-BTjWOF_DHI"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=5Z0OnPT0Z88:iTM6Qghxmgg:-BTjWOF_DHI" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=5Z0OnPT0Z88:iTM6Qghxmgg:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=5Z0OnPT0Z88:iTM6Qghxmgg:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=5Z0OnPT0Z88:iTM6Qghxmgg:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=5Z0OnPT0Z88:iTM6Qghxmgg:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=5Z0OnPT0Z88:iTM6Qghxmgg:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=5Z0OnPT0Z88:iTM6Qghxmgg:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=5Z0OnPT0Z88:iTM6Qghxmgg:F7zBnMyn0Lo" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/LittleHandyTips/~4/5Z0OnPT0Z88" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://littlehandytips.com/recaptcha-stop-spam-read-books/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://littlehandytips.com/recaptcha-stop-spam-read-books/</feedburner:origLink></item>
		<item>
		<title>Cheat Sheet for Designing Web Forms</title>
		<link>http://feedproxy.google.com/~r/LittleHandyTips/~3/7nO3Xfn4QOU/</link>
		<comments>http://littlehandytips.com/cheat-sheet-for-designing-web-forms/#comments</comments>
		<pubDate>Sun, 09 Oct 2011 11:00:29 +0000</pubDate>
		<dc:creator>Edwin Kwan</dc:creator>
				<category><![CDATA[Featured]]></category>
		<category><![CDATA[General]]></category>
		<category><![CDATA[Web Design and Development]]></category>

		<guid isPermaLink="false">http://littlehandytips.com/?p=1134</guid>
		<description><![CDATA[Web Forms, we all have our share of filling up countless such forms. Some of our experience were pleasant, and some were just down right horrible. In this post, Joe Leech from cxpartners, bring together their experience in designing forms that are easy to use and get users through the process as quickly and easily as possible.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p><a name="top"></a><strong>Web Forms</strong>, we all have our share of filling up countless such forms. Some of our experience were pleasant, and some were just down right horrible. In this post, <a href="http://www.cxpartners.co.uk/thoughts/the_myth_of_the_page_fold_evidence_from_user_testing.htm">Joe Leech</a> from cxpartners, bring together their experience in designing forms that are easy to use and get users through the process as quickly and easily as possible.</p>
<ul>
<li><a href="#simple-form-field">Simple form field</a></li>
<li><a href="#optional-field">Optional fields</a></li>
<li><a href="#support-text">Support text</a></li>
<li><a href="#help-text">Help text</a></li>
<li><a href="#date-fields">Date fields</a></li>
<li><a href="#buttons">Buttons</a></li>
<li><a href="#inline-validation">Inline validation</a></li>
<li><a href="#postcode-look-up">Postcode look-up</a></li>
<li><a href="#entering-currency-values">Entering currency values</a></li>
<li><a href="#password-strength">Password strength</a></li>
<li><a href="#adding-more-than-one">Adding more than 1 email/phone</a></li>
<li><a href="#layout-and-examples">Layout and examples</a></li>
<li><a href="#page-level-error-handling">Page level error handling</a></li>
<li><a href="#some-no-nos">Some no-nos</a></li>
<li><strong><a href="#download-cheat-sheet">Download cheat sheet as PDF</a></strong></li>
</ul>
<p>&nbsp;</p>
<h3><a name="simple-form-field"></a>Simple form field</h3>
<p>Centre align all form fields. Use a different style of text for the label versus support text. The further help field sits on the right hand side of the input. The label should follow sentence case; that is Upper case first word, then lower case second word(s).</p>
<p><img class="alignnone size-medium wp-image-1135" title="designing-web-form-1" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-1-300x58.png" alt="" width="300" height="58" /></p>
<p>Select boxes where possible should default to a value. If this is not possible default to italic text, slightly grey in colour saying <em>&#8216;Please select&#8230;&#8217;</em></p>
<p><img class="alignnone size-medium wp-image-1137" title="designing-web-form-2" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-2-300x53.png" alt="" width="300" height="53" /></p>
<p>Place radio buttons underneath each other where possible. This allows for easy scanning:</p>
<p><img class="alignnone size-medium wp-image-1138" title="designing-web-form-3" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-3-300x96.png" alt="" width="300" height="96" /></p>
<p>Checkbox buttons take the same form. These can be listed in rows if needs be but only if there are more than five.</p>
<p><img class="alignnone size-medium wp-image-1139" title="designing-web-form-4" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-4-300x139.png" alt="" width="300" height="139" /><br />
<a href="#top">[back to top]</a></p>
<h3><a name="optional-field"></a>Optional fields</h3>
<p>Users do not always understand the mandatory field marker (*) and on long pages the explanation can be lost. Where possible mark optional fields.</p>
<p><img class="alignnone size-medium wp-image-1140" title="designing-web-form-5" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-5-300x71.png" alt="" width="300" height="71" /><br />
<a href="#top">[back to top]</a></p>
<h3><a name="support-text"></a>Support text</h3>
<p>Support text should be used to give key information that is essential to complete the form field. Examples include password format and explanations for data collection.</p>
<p><img class="alignnone size-medium wp-image-1142" title="designing-web-form-6" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-6-300x70.png" alt="" width="300" height="70" /><br />
<a href="#top">[back to top]</a></p>
<h3><a name="help-text"></a>Help text</h3>
<p>Help text should be used to offer advice on a complex question. Where possible is should offer example answers and the format of that answer.</p>
<p><img class="alignnone size-medium wp-image-1143" title="designing-web-form-7" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-7-300x68.png" alt="" width="300" height="68" /></p>
<p>Help text should be activated by click and be a layer/lightbox next to the form field. Also if needed include links to contact form and the telephone number.<br />
<a href="#top">[back to top]</a></p>
<h3><a name="date-fields"></a>Date fields</h3>
<p>For date of birth fields do not include a calendar look-up. Always use select boxes to minimise errors.</p>
<p><img class="alignnone size-medium wp-image-1144" title="designing-web-form-8" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-8-300x52.png" alt="" width="300" height="52" /></p>
<p>With standard date fields launch the calendar on focus on any of the form fields.</p>
<p><img class="alignnone size-medium wp-image-1145" title="designing-web-form-9" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-9-300x257.png" alt="" width="300" height="257" /></p>
<p>Adding select boxes for month and year aids look-up and a Select today link resets the calendar. Use a highlight colour to indicate Public Holidays if needed.</p>
<p>UK calendars begin on a Monday (many off-the-shelf JS calendars are American where calendars begin on a Sunday, the JQuery calendar offers it as a setting).<br />
<a href="#top">[back to top]</a></p>
<h3><a name="buttons"></a>Buttons</h3>
<p>Where possible there should be 2 kinds of button on the page.</p>
<ul>
<li>Support buttons such as postcode look-up, refresh, back etc.</li>
<li>Primary button. There should be only one of these and it should be larger and with a different design. Primary button should include chevrons.</li>
</ul>
<p>Having only 1 primary button clearly indicates to the user the most important action on the page. If more than 1 primary button is needed consider splitting form over 2 pages.</p>
<p><img class="alignnone size-medium wp-image-1147" title="designing-web-form-10" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-10-300x58.png" alt="" width="300" height="58" /></p>
<p>Where possible add a description to the primary button to indicate what the next screen will contain.</p>
<p>The final payment button should include a tick and some explanation text to give confidence to the user to click.</p>
<p><img class="alignnone size-medium wp-image-1148" title="designing-web-form-11" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-11-300x92.png" alt="" width="300" height="92" /><br />
<a href="#top">[back to top]</a></p>
<h3><a name="inline-validation"></a>Inline validation</h3>
<p>Where possible all form fields should validate following cursor focus leaving that field.</p>
<p><img class="alignnone size-medium wp-image-1149" title="designing-web-form-12" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-12-300x285.png" alt="" width="300" height="285" /></p>
<p>Where possible indicate why the form content is not correct. Do not use words such as error, problem or issue. Be positive.</p>
<p><img class="alignnone size-medium wp-image-1151" title="designing-web-form-13" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-13-300x186.png" alt="" width="300" height="186" /></p>
<p>Preselect the first option in the list.<br />
<a href="#top">[back to top]</a></p>
<h3><a name="postcode-look-up"></a>Postcode look-up</h3>
<p>Postcodes have on average 15 properties associated with them. Each of these properties may be broken up into flats. Therefore a large possible list of properties may result. Note positioning of<br />
button under the field &#8211; buttons to the right can easily be missed.</p>
<p><a href="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-14.png"><img class="alignnone size-full wp-image-1152" title="designing-web-form-14" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-14.png" alt="" width="310" height="555" /></a></p>
<p>If the user cannot see their address offer a link. On click this will display the manual address entry fields.<br />
<a href="#top">[back to top]</a></p>
<h3><a name="entering-currency-values"></a>Entering currency values</h3>
<p>Users enter currencies and monetary values into forms in a number of different ways. Where possible the system should accept the following options:</p>
<p><img class="alignnone size-medium wp-image-1156" title="designing-web-form-15" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-15-300x149.png" alt="" width="300" height="149" /><br />
<a href="#top">[back to top]</a></p>
<h3><a name="password-strength"></a>Password strength</h3>
<p>Where possible use plain text rather than images to aid accessibility:</p>
<p><img class="alignnone size-medium wp-image-1157" title="designing-web-form-16" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-16-300x121.png" alt="" width="300" height="121" /><br />
<a href="#top">[back to top]</a></p>
<h3><a name="adding-more-than-one"></a>Adding more than 1 email/phone</h3>
<p>Many users, especially those under 25, may not have a landline number or indeed consider this their main phone number. Allow users to select which phone it is they want to offer as a primary number.</p>
<p><img class="alignnone size-medium wp-image-1158" title="designing-web-form-17" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-17-300x69.png" alt="" width="300" height="69" /><br />
<a href="#top">[back to top]</a></p>
<h3><a name="layout-and-examples"></a>Layout and examples</h3>
<p>Group related form fields together into smaller chunks. This makes the form feel easier to complete and less intimidating.</p>
<p><a href="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-18.png"><img class="alignnone size-medium wp-image-1160" title="designing-web-form-18" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-18-281x300.png" alt="" width="281" height="300" /></a><br />
<a href="#top">[back to top]</a></p>
<h3><a name="page-level-error-handling"></a>Page level error handling</h3>
<p>There may be situations where errors can only be managed at the form submit level. Offer a direct link to each error (to a maximum of three). Clicking on the &#8216;And 3 more&#8217; link will show the full list of hyperlinked errors. Linking to errors in this way offers greater accessibility to users of screen readers.</p>
<p><a href="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-19.png"><img class="alignnone size-medium wp-image-1162" title="designing-web-form-19" src="http://littlehandytips.com/wp-content/uploads/2011/10/designing-web-form-19-240x300.png" alt="" width="240" height="300" /></a><br />
<a href="#top">[back to top]</a></p>
<h3><a name="some-no-nos"></a>Some no-nos</h3>
<ul>
<li>Do not place form fields side by side in columns. Users often do not see the form fields in the right column.</li>
<li>Only use 1 field for telephone numbers (i.e. no area code box) as many users will try and put the full number in the area code box.</li>
<li>Avoid long, complex, text based explanations at the top of forms &#8211; nobody ever reads them.</li>
</ul>
<p><a href="#top">[back to top]</a></p>
<h3><a name="download-cheat-sheet"></a>Download cheat sheet as PDF</h3>
<p><a href="http://littlehandytips.com/wp-content/uploads/2011/10/v1-Form-design-crib-sheet.pdf">v1-Form-design-crib-sheet.pdf [252kb]</a><br />
<a href="#top">[back to top]</a></p>
<blockquote><p><img class="alignleft" src="http://0.gravatar.com/avatar/05c6c29bb5d2eda1e7d5651d5fda4ba4?s=78&amp;d=http%3A%2F%2F0.gravatar.com%2Favatar%2Fad516503a11cd5ca435acc9bb6523536%3Fs%3D78&amp;r=G" alt="" align="right/" /></p>
<h1 style="font-size: 20px;">Joe Leech</h1>
<p>Joe has been working in UX for 7 years. Joe has worked with clients such as Marriott, eBay, Nokia, theTrainline, Microsoft, TUI Travel, Peugeot, Virgin and the Co-operative Bank helping them to be more strategic in their customer focus and make the digital stuff they do measurably better.</p></blockquote>
<div class="shr-publisher-1134"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic -->
<p><a href="http://feedads.g.doubleclick.net/~a/-SoiQ--J1BTF52aHjAHQPz_R7Wo/0/da"><img src="http://feedads.g.doubleclick.net/~a/-SoiQ--J1BTF52aHjAHQPz_R7Wo/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/-SoiQ--J1BTF52aHjAHQPz_R7Wo/1/da"><img src="http://feedads.g.doubleclick.net/~a/-SoiQ--J1BTF52aHjAHQPz_R7Wo/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=7nO3Xfn4QOU:wxWMQB_6WbU:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=7nO3Xfn4QOU:wxWMQB_6WbU:-BTjWOF_DHI"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=7nO3Xfn4QOU:wxWMQB_6WbU:-BTjWOF_DHI" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=7nO3Xfn4QOU:wxWMQB_6WbU:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=7nO3Xfn4QOU:wxWMQB_6WbU:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=7nO3Xfn4QOU:wxWMQB_6WbU:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=7nO3Xfn4QOU:wxWMQB_6WbU:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=7nO3Xfn4QOU:wxWMQB_6WbU:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=7nO3Xfn4QOU:wxWMQB_6WbU:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=7nO3Xfn4QOU:wxWMQB_6WbU:F7zBnMyn0Lo" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/LittleHandyTips/~4/7nO3Xfn4QOU" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://littlehandytips.com/cheat-sheet-for-designing-web-forms/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://littlehandytips.com/cheat-sheet-for-designing-web-forms/</feedburner:origLink></item>
		<item>
		<title>Steps to Unblock your Hotmail Account</title>
		<link>http://feedproxy.google.com/~r/LittleHandyTips/~3/z66CKD6Kk9g/</link>
		<comments>http://littlehandytips.com/steps-to-unblock-your-hotmail-account/#comments</comments>
		<pubDate>Sat, 08 Oct 2011 12:21:50 +0000</pubDate>
		<dc:creator>Edwin Kwan</dc:creator>
				<category><![CDATA[Computers]]></category>
		<category><![CDATA[General]]></category>

		<guid isPermaLink="false">http://littlehandytips.com/?p=1126</guid>
		<description><![CDATA[I've been getting a lot of request from people asking me to help unblock their hotmail account in the Ways To Unblock Your Hotmail Account article. So here is more information on the steps to take to unblock your hotmail account.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>I&#8217;ve been getting a lot of request from people asking me to help unblock their hotmail account in the <a title="Ways To Unblock Your Hotmail Account" href="http://littlehandytips.com/ways-to-unblock-your-hotmail-account/">Ways To Unblock Your Hotmail Account</a> article. So here is more information on the steps to take to unblock your hotmail account.</p>
<p>There is no other way to recover your account other than to contact Hormail.</p>
<p>You saw the following error message when logging into a Windows Live product:<br />
<strong>&#8220;Your account has been temporarily blocked&#8221;</strong></p>
<p><img class="alignnone size-medium wp-image-1127" title="suspended" src="http://littlehandytips.com/wp-content/uploads/2011/10/suspended-300x139.jpg" alt="" width="300" height="139" /></p>
<h2>Why are you seeing this?</h2>
<p>Hotmail use systems to help detect spammers on Windows Live Services. These systems place a variety of restrictions on accounts, one of them is blocking users from accessing the Windows Live Services. Occasionally, suspicious activity causes their technology to block legitimate accounts.</p>
<h2>What do these messages mean?</h2>
<p>When an account is sending a lot of e-mail, friend invitations, or posting lots of comments, there is a good chance that it is a spammer. In some cases, spammers actually create accounts to use, but sometimes they break in to real accounts. Hotmail block accounts so that the spammers can’t send out any more junk and so that real people can get their accounts back. Blocked accounts have very limited access to Hotmail and Windows Live. Hotmail&#8217;s goal is to help the real account owner get their account back.</p>
<h2>What should you do?</h2>
<p>Verify your account with a mobile number (only available in limited markets at this time): <a href="https://sms.live.com">https://sms.live.com</a></p>
<p>If you are unable to verify using the SMS validation, please submit your request <a href="https://windowslivehelp.com/vi.aspx?id=2f034e2e-938a-4a1c-a754-21878d2c6209">here</a> (Select &#8220;Hotmail&#8221; from the product dropdown list, click “Continue” and select: Error: &#8220;Your account has been temporarily blocked&#8221;) and one of their moderators will help you.</p>
<h3>Here are some steps that you can take to avoid getting this error:</h3>
<ul>
<li>Do not give out your passwords to people. Hotmail, Windows Live, and Microsoft will never ask for your password in e-mail</li>
<li>Make sure that you have an anti-virus program installed and run it regularly. Many spammers get a hold of passwords through viruses and spyware. Microsoft Security Essentials offers free anti-virus protection.</li>
<li>If you use Windows, turning on Windows Update will help keep your computer up-to-date and make it less vulnerable to viruses.</li>
<ul>
<li><strong>Windows 7</strong> &#8211; Learn how to turn on automatic updating.</li>
<li><strong>Windows Vista</strong> &#8211; Learn how to turn on automatic updating.</li>
<li><strong>Windows XP</strong> &#8211; To learn how to turn on automatic updates, click the Start button, click Help and Support, type Windows update in the search box, and then, in the list of results, click Turn on automatic updates. Follow the instructions.</li>
</ul>
<li>Check to make sure that you only send messages to people who want to receive them.</li>
<li>Reduce the number of messages that you send to large groups of people so that they are less likely to think your messages are unwanted mail.</li>
<li>Limit the number of chain letters, e-mail jokes and other messages that you send to help people recognize your mail as wanted and to make it more likely that your message will be allowed past your recipients&#8217; junk mail filters.</li>
<li>Limit the number of friend invitations you send or send them only to people that know you.</li>
<li>Check all the contacts in your address book to make sure that the accounts are still active.</li>
</ul>
<p>Somebody stole your password to send spam. Hotmail temporarily block the accounts compromised to help you you and your contacts, and then let Hotmail help you to recover your account.</p>
<p>The fastest means to recover your account is to change your password. Then you will want certainly to ensure you that the person at the origin of this incident did not change the data of your account, which would enable him to take again at once the control of your account.</p>
<h3>Here the steps which you should follow:</h3>
<p>1. Can you always connect? If you can,change your password. For this follow Hotmail&#8217;s steps to modify your password.</p>
<p><a href="http://windowslivehelp.com">http://windowslivehelp.com</a></p>
<p>2. Were asked to give your cell phone number after connected? At the time of connection, it is possible indeed that Hotmail ask for a telephone number in order to send you a message text containing to you a secret code. This is intended to prevent the spammers from using your account.</p>
<p>3. If you do not manage to connect on your account, try to redefine your password. <a href="http://windowslivehelp.com">http://windowslivehelp.com</a></p>
<p>During the process of validation, you will be asked key information on your account Windows Live that you only you will be able to provide us. This enables Hotmail to check that you are the rightful owner of the account. The criteria of requirement intended to protect you are very strict, consequently you must give them as much information as possible and details for each question. It is possible that you need to request from some your friends and contacts to ask for confirmation of subject of received emails or addresses email of contacts. The more information, the more Hotmail will be able to validate your account and thus to help you to recover the access on your account.</p>
<p>If for a different reason you still can&#8217;t connect to your account , see information on this subject on the page relating to connection problems of connection:</p>
<p><a href="http://windowslivehelp.com">http://windowslivehelp.com</a></p>
<div class="shr-publisher-1126"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic -->
<p><a href="http://feedads.g.doubleclick.net/~a/gB6B_cVCI6pFPLFMClngoVWfjCE/0/da"><img src="http://feedads.g.doubleclick.net/~a/gB6B_cVCI6pFPLFMClngoVWfjCE/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/gB6B_cVCI6pFPLFMClngoVWfjCE/1/da"><img src="http://feedads.g.doubleclick.net/~a/gB6B_cVCI6pFPLFMClngoVWfjCE/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=z66CKD6Kk9g:dxlcMp2GyE4:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=z66CKD6Kk9g:dxlcMp2GyE4:-BTjWOF_DHI"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=z66CKD6Kk9g:dxlcMp2GyE4:-BTjWOF_DHI" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=z66CKD6Kk9g:dxlcMp2GyE4:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=z66CKD6Kk9g:dxlcMp2GyE4:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=z66CKD6Kk9g:dxlcMp2GyE4:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=z66CKD6Kk9g:dxlcMp2GyE4:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=z66CKD6Kk9g:dxlcMp2GyE4:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=z66CKD6Kk9g:dxlcMp2GyE4:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=z66CKD6Kk9g:dxlcMp2GyE4:F7zBnMyn0Lo" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/LittleHandyTips/~4/z66CKD6Kk9g" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://littlehandytips.com/steps-to-unblock-your-hotmail-account/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://littlehandytips.com/steps-to-unblock-your-hotmail-account/</feedburner:origLink></item>
		<item>
		<title>3 Easy Steps to Diagnose WordPress Plugin Problems</title>
		<link>http://feedproxy.google.com/~r/LittleHandyTips/~3/CrnldhRktjQ/</link>
		<comments>http://littlehandytips.com/3-easy-steps-to-diagnose-wordpress-plugin-problems/#comments</comments>
		<pubDate>Thu, 06 Oct 2011 01:24:40 +0000</pubDate>
		<dc:creator>Edwin Kwan</dc:creator>
				<category><![CDATA[Featured]]></category>
		<category><![CDATA[General]]></category>
		<category><![CDATA[Tools and Productivity]]></category>
		<category><![CDATA[Web Design and Development]]></category>
		<category><![CDATA[Blogging]]></category>
		<category><![CDATA[Computers]]></category>
		<category><![CDATA[Wordpress]]></category>

		<guid isPermaLink="false">http://littlehandytips.com/?p=1097</guid>
		<description><![CDATA[It's frustrating when you can't get a wordpress plugin to work, especially when it had been working before. Chances are, it could be because the wordpress plugins are conflicting. We'll look at common reasons why plugins stop working, 3 easy steps to determine the wordpress plugin problems and what to do once the problem has been identified.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>As a wordpress plugin developer for the<a title="Google Custom Search WordPress Plugin" href="http://littlehandytips.com/plugins/google-custom-search/"> Google Custom Search plugin</a>, I get a lot of queries from users having problems with the plugin. The most common query I get is &#8220;I&#8217;ve installed your plugin last year, but recently it stopped working. Can you help me?&#8221;. I normally take a 3 step approach to diagnosing wordpress plugin problem, but before we get to that, let&#8217;s look at why a plugin might have stopped working.</p>
<p>There are there reasons why a wordpress plugin has stopped working:</p>
<ol>
<li><strong>It is incompatible with your current version of wordpress</strong><br />
You might have upgraded your wordpress installation to a newer release. WordPress releases fix/updates and upgrades regularly and the new version might not be compatible with the plugin.</li>
<li><strong>Conflict with other plugins</strong><br />
This is usually the of  most plugin problems where the code in one of your other plugins conflicts with the code in the plugin in question. JQuery conflicts is common cause.</li>
<li><strong>The new version of the plugin is Broken!<br />
</strong>While very uncommon, it can happen. The developer writing the plugin made some changes which has broken the plugin. This might be the case if you have recently updated the plugin. Normally for this situation, you can expect a new update to be available relatively soon with the fixes.<strong><br />
</strong></li>
</ol>
<h2>3 Steps to Diagnosing WordPress Plugin Problems</h2>
<h3>Step 1: Determine if there is a plugin conflict</h3>
<ol>
<li>Disable all plugins except for the one which is broken and check that the plugin now works (if it doesn&#8217;t proceed to the Step 2).</li>
<li>Next activate the plugins one at a time until the plugin in question stops working.</li>
<li>The last plugin which was activated is having a conflict with the plugin which you are diagnosing.</li>
</ol>
<div id="attachment_1104" class="wp-caption alignnone" style="width: 310px"><a href="http://littlehandytips.com/wp-content/uploads/2011/10/disable-all-other-plugins.png"><img class="size-medium wp-image-1104 " title="disable-all-other-plugins" src="http://littlehandytips.com/wp-content/uploads/2011/10/disable-all-other-plugins-300x148.png" alt="" width="300" height="148" /></a><p class="wp-caption-text">Disable all plugins except the one which you are investigating</p></div>
<h3>Step 2: Determine if the current WordPress theme has a conflict</h3>
<p>WordPress themes can contain code which conflicts with the plugin. The easiest way to determine this is to:</p>
<ol>
<li>Switch wordpress theme to the default &#8220;<a href="http://theme.wordpress.com/themes/twentyeleven/">Twenty Eleven</a>&#8221; Theme. Check if the plugin in question now works. If it does, then the theme which you have is in conflict with the plugin.</li>
</ol>
<p><img src="http://littlehandytips.com/wp-content/themes/twentyeleven/screenshot.png" alt="" /></p>
<h3>Step 3: Determine Error Using Firefox Error Console</h3>
<p>If the first two steps did not diagnose the problem, then you need to use <a href="http://www.mozilla.org/en-US/firefox/fx/">Firefox</a>&#8216;s Error Console to see what the plugin error is.</p>
<ol>
<li>Open the Error Console in a <a href="http://www.mozilla.org/en-US/firefox/fx/">Firefox</a> browser using the shortcut key Cltr-Shift-J.</li>
<li>Then visit your website in Firefox, you should see the error messages in the Error Console</li>
</ol>
<p><a href="http://littlehandytips.com/wp-content/uploads/2011/10/firefox-error-console.png"><img class="alignnone size-medium wp-image-1109" title="firefox-error-console" src="http://littlehandytips.com/wp-content/uploads/2011/10/firefox-error-console-300x224.png" alt="" width="300" height="224" /></a></p>
<p>From there you might be able to identify what the error is which is causing the plugin to not work.</p>
<h2>What to Do Once the Problem has been Determined</h2>
<p>Once you have found the problem, what can you do to fix it?</p>
<p>If it is a conflict with another plugin or theme, then you might want to contact the developer of that plugin or theme to get them to put a fix in. If you did Step 3 and have the error message from Firefox Error Console, sending the error messages to the developers will help them with providing a fix. What I find is that you get a faster response from the developer when you include the error message.</p>
<p>If you&#8217;re familiar with a little PHP or javascript coding, you might even be able to go into the code and fix the problem.</p>
<p>The other alternative, is now that you have identified the culprit, you can choose to not use that plugin or theme and find an alternative. Often times, there are multiple plugins providing similar functionality. You just need to search for them at <a href="http://wordpress.org/extend/plugins/">http://wordpress.org/extend/plugins/</a>.</p>
<div class="shr-publisher-1097"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic -->
<p><a href="http://feedads.g.doubleclick.net/~a/pl1b4aLowtGzPhjviX_SDDPPf_4/0/da"><img src="http://feedads.g.doubleclick.net/~a/pl1b4aLowtGzPhjviX_SDDPPf_4/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/pl1b4aLowtGzPhjviX_SDDPPf_4/1/da"><img src="http://feedads.g.doubleclick.net/~a/pl1b4aLowtGzPhjviX_SDDPPf_4/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=CrnldhRktjQ:FWy5FFBN_s8:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=CrnldhRktjQ:FWy5FFBN_s8:-BTjWOF_DHI"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=CrnldhRktjQ:FWy5FFBN_s8:-BTjWOF_DHI" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=CrnldhRktjQ:FWy5FFBN_s8:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=CrnldhRktjQ:FWy5FFBN_s8:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=CrnldhRktjQ:FWy5FFBN_s8:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=CrnldhRktjQ:FWy5FFBN_s8:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=CrnldhRktjQ:FWy5FFBN_s8:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=CrnldhRktjQ:FWy5FFBN_s8:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=CrnldhRktjQ:FWy5FFBN_s8:F7zBnMyn0Lo" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/LittleHandyTips/~4/CrnldhRktjQ" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://littlehandytips.com/3-easy-steps-to-diagnose-wordpress-plugin-problems/feed/</wfw:commentRss>
		<slash:comments>2</slash:comments>
		<feedburner:origLink>http://littlehandytips.com/3-easy-steps-to-diagnose-wordpress-plugin-problems/</feedburner:origLink></item>
		<item>
		<title>New Facebook Changes: Timeline, Subscribe to User and Twitter</title>
		<link>http://feedproxy.google.com/~r/LittleHandyTips/~3/ysdV0NEQufk/</link>
		<comments>http://littlehandytips.com/new-facebook-changes-timeline-subscribe-to-user-and-twitter/#comments</comments>
		<pubDate>Mon, 26 Sep 2011 01:07:14 +0000</pubDate>
		<dc:creator>Edwin Kwan</dc:creator>
				<category><![CDATA[General]]></category>
		<category><![CDATA[Facebook]]></category>

		<guid isPermaLink="false">http://littlehandytips.com/?p=1089</guid>
		<description><![CDATA[Facebook had it's F8 conference last week and it had announced quite a few changes, most notably Timelines.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>Facebook had it&#8217;s F8 conference last week and it had announced <a href="http://grahamcreative.wordpress.com/2011/09/23/handy-summary-of-facebooks-f8-conference/">quite a few changes</a>, most notably <a href="http://www.facebook.com/about/timeline">Timelines</a>.</p>
<p>Below is a screenshot of how timelines work.</p>
<p><img class="size-full wp-image-1090 alignnone" title="grahamcreative-facebook-timeline-open-graph-preview-beta" src="http://littlehandytips.com/wp-content/uploads/2011/09/grahamcreative-facebook-timeline-open-graph-preview-beta.png" alt="" width="460" height="523" /></p>
<p><a href="http://mashable.com/2011/09/22/how-to-facebook-timeline/#27125Step-1" target="_blank"> Here are instructions on how to setup timeline for your facebook page.</a></p>
<p>Some another noteworthy features are:</p>
<ul>
<li><a href="http://www.facebook.com/about/subscribe" target="_blank">Subscribe button</a> which allows anyone to subscribe to people&#8217;s post in facebook, even if they are not friends. (this need to enable <a href="http://www.facebook.com/about/subscribe" target="_blank">here</a>)</li>
<li><a href="https://www.facebook.com/twitter" target="_blank">Linking of facebook page to twitter</a>. Where you status updates on facebook pages get automatically published to twitter.</li>
<li>Symbiotic sharing: where you&#8217;ll now be able to listen along, and watch stuff with your friends in real time! All without having to leave Facebook.</li>
</ul>
<p>&nbsp;</p>
<div class="shr-publisher-1089"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic -->
<p><a href="http://feedads.g.doubleclick.net/~a/MTOSWIEwmQpJL_KGeYPNcpX24hA/0/da"><img src="http://feedads.g.doubleclick.net/~a/MTOSWIEwmQpJL_KGeYPNcpX24hA/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/MTOSWIEwmQpJL_KGeYPNcpX24hA/1/da"><img src="http://feedads.g.doubleclick.net/~a/MTOSWIEwmQpJL_KGeYPNcpX24hA/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=ysdV0NEQufk:3gworRNuQPI:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=ysdV0NEQufk:3gworRNuQPI:-BTjWOF_DHI"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=ysdV0NEQufk:3gworRNuQPI:-BTjWOF_DHI" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=ysdV0NEQufk:3gworRNuQPI:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=ysdV0NEQufk:3gworRNuQPI:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=ysdV0NEQufk:3gworRNuQPI:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=ysdV0NEQufk:3gworRNuQPI:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=ysdV0NEQufk:3gworRNuQPI:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=ysdV0NEQufk:3gworRNuQPI:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=ysdV0NEQufk:3gworRNuQPI:F7zBnMyn0Lo" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/LittleHandyTips/~4/ysdV0NEQufk" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://littlehandytips.com/new-facebook-changes-timeline-subscribe-to-user-and-twitter/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://littlehandytips.com/new-facebook-changes-timeline-subscribe-to-user-and-twitter/</feedburner:origLink></item>
		<item>
		<title>Create a Desktop Background Slideshow for Windows 7</title>
		<link>http://feedproxy.google.com/~r/LittleHandyTips/~3/iMpjtZ1Hgww/</link>
		<comments>http://littlehandytips.com/create-a-desktop-background-slideshow-for-windows-7/#comments</comments>
		<pubDate>Fri, 23 Sep 2011 00:21:11 +0000</pubDate>
		<dc:creator>guest</dc:creator>
				<category><![CDATA[Computers]]></category>
		<category><![CDATA[General]]></category>
		<category><![CDATA[Windows]]></category>

		<guid isPermaLink="false">http://littlehandytips.com/?p=1082</guid>
		<description><![CDATA[Ever wondered how you can create a slide show (a rotating series of pictures) as your desktop background. 
You can use your own pictures or pictures that Windows provides as part of a theme.

Watch this video to learn how to create a desktop background slide show (1:48)]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>Ever wondered how you can create a slide show (a rotating series of pictures) as your desktop background.<br />
You can use your own pictures or pictures that Windows provides as part of a theme.</p>
<p>Watch this video to learn how to create a desktop background slide show (1:48)<br />
<object width="500" height="440" classid="clsid:dfeaf541-f3e1-4c24-acac-99c30715084a"><param name="source" value="http://res2.windows.microsoft.com/Resources/3.2/shared/silverlight/videoplayer.xap" /><param name="minRuntimeVersion" value="4.0.50401.0" /><param name="autoUpgrade" value="true" /><param name="windowless" value="true" /><param name="enablehtmlaccess" value="true" /><param name="enableGPUAcceleration" value="true" /><param name="InitParams" value="mediaurl=http://res1.windows.microsoft.com/resbox/en/Windows 7/main/5c8d8f5d-2fcf-4214-a563-31a8e40a8755_0.wmv,ScriptableName=p95f7956cc1784c3aa4d2622beb4f2384,mimeType=video/x-ms-wmv,ThumbnailUrl=http://res2.windows.microsoft.com/resbox/en/Windows 7/main/44e2b103-f138-468e-8703-2c95b9835112_0.jpg,silverlightVideoClosedCaptionOff=CC+Off,silverlightVideoClosedCaptionOn=CC+On,silverlightVideoExitFullscreen=Exit+Full+Screen,silverlightVideoFullscreen=Full+Screen,silverlightVideoMute=Mute,silverlightVideoUnMute=Unmute,silverlightVideoPause=Pause,silverlightVideoPlay=Play,silverlightVideoPoster=Click+to+watch+the+video" /><param name="src" value="data:application/x-silverlight-2," /><param name="minruntimeversion" value="4.0.50401.0" /><param name="autoupgrade" value="true" /><param name="enablegpuacceleration" value="true" /><param name="initparams" value="mediaurl=http://res1.windows.microsoft.com/resbox/en/Windows 7/main/5c8d8f5d-2fcf-4214-a563-31a8e40a8755_0.wmv,ScriptableName=p95f7956cc1784c3aa4d2622beb4f2384,mimeType=video/x-ms-wmv,ThumbnailUrl=http://res2.windows.microsoft.com/resbox/en/Windows 7/main/44e2b103-f138-468e-8703-2c95b9835112_0.jpg,silverlightVideoClosedCaptionOff=CC+Off,silverlightVideoClosedCaptionOn=CC+On,silverlightVideoExitFullscreen=Exit+Full+Screen,silverlightVideoFullscreen=Full+Screen,silverlightVideoMute=Mute,silverlightVideoUnMute=Unmute,silverlightVideoPause=Pause,silverlightVideoPlay=Play,silverlightVideoPoster=Click+to+watch+the+video" /><embed width="500" height="440" type="application/x-silverlight-2" src="data:application/x-silverlight-2," source="http://res2.windows.microsoft.com/Resources/3.2/shared/silverlight/videoplayer.xap" minRuntimeVersion="4.0.50401.0" autoUpgrade="true" windowless="true" enablehtmlaccess="true" enableGPUAcceleration="true" InitParams="mediaurl=http://res1.windows.microsoft.com/resbox/en/Windows 7/main/5c8d8f5d-2fcf-4214-a563-31a8e40a8755_0.wmv,ScriptableName=p95f7956cc1784c3aa4d2622beb4f2384,mimeType=video/x-ms-wmv,ThumbnailUrl=http://res2.windows.microsoft.com/resbox/en/Windows 7/main/44e2b103-f138-468e-8703-2c95b9835112_0.jpg,silverlightVideoClosedCaptionOff=CC+Off,silverlightVideoClosedCaptionOn=CC+On,silverlightVideoExitFullscreen=Exit+Full+Screen,silverlightVideoFullscreen=Full+Screen,silverlightVideoMute=Mute,silverlightVideoUnMute=Unmute,silverlightVideoPause=Pause,silverlightVideoPlay=Play,silverlightVideoPoster=Click+to+watch+the+video" minruntimeversion="4.0.50401.0" autoupgrade="true" enablegpuacceleration="true" initparams="mediaurl=http://res1.windows.microsoft.com/resbox/en/Windows 7/main/5c8d8f5d-2fcf-4214-a563-31a8e40a8755_0.wmv,ScriptableName=p95f7956cc1784c3aa4d2622beb4f2384,mimeType=video/x-ms-wmv,ThumbnailUrl=http://res2.windows.microsoft.com/resbox/en/Windows 7/main/44e2b103-f138-468e-8703-2c95b9835112_0.jpg,silverlightVideoClosedCaptionOff=CC+Off,silverlightVideoClosedCaptionOn=CC+On,silverlightVideoExitFullscreen=Exit+Full+Screen,silverlightVideoFullscreen=Full+Screen,silverlightVideoMute=Mute,silverlightVideoUnMute=Unmute,silverlightVideoPause=Pause,silverlightVideoPlay=Play,silverlightVideoPoster=Click+to+watch+the+video" /></object></p>
<div class="shr-publisher-1082"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic -->
<p><a href="http://feedads.g.doubleclick.net/~a/QNEgmXsBxEICDacsZQC05s_GIkc/0/da"><img src="http://feedads.g.doubleclick.net/~a/QNEgmXsBxEICDacsZQC05s_GIkc/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/QNEgmXsBxEICDacsZQC05s_GIkc/1/da"><img src="http://feedads.g.doubleclick.net/~a/QNEgmXsBxEICDacsZQC05s_GIkc/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=iMpjtZ1Hgww:L0Rzy11qVuk:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=iMpjtZ1Hgww:L0Rzy11qVuk:-BTjWOF_DHI"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=iMpjtZ1Hgww:L0Rzy11qVuk:-BTjWOF_DHI" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=iMpjtZ1Hgww:L0Rzy11qVuk:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=iMpjtZ1Hgww:L0Rzy11qVuk:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=iMpjtZ1Hgww:L0Rzy11qVuk:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=iMpjtZ1Hgww:L0Rzy11qVuk:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=iMpjtZ1Hgww:L0Rzy11qVuk:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=iMpjtZ1Hgww:L0Rzy11qVuk:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=iMpjtZ1Hgww:L0Rzy11qVuk:F7zBnMyn0Lo" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/LittleHandyTips/~4/iMpjtZ1Hgww" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://littlehandytips.com/create-a-desktop-background-slideshow-for-windows-7/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://littlehandytips.com/create-a-desktop-background-slideshow-for-windows-7/</feedburner:origLink></item>
		<item>
		<title>Promote YouTube Channel on Your Website</title>
		<link>http://feedproxy.google.com/~r/LittleHandyTips/~3/MyA1Wu7RfHM/</link>
		<comments>http://littlehandytips.com/promote-youtube-channel-on-your-website/#comments</comments>
		<pubDate>Thu, 08 Sep 2011 12:55:16 +0000</pubDate>
		<dc:creator>Edwin Kwan</dc:creator>
				<category><![CDATA[Computers]]></category>
		<category><![CDATA[General]]></category>
		<category><![CDATA[YouTube]]></category>

		<guid isPermaLink="false">http://littlehandytips.com/?p=1073</guid>
		<description><![CDATA[There are two ways to promote a youTube channel on your website. You can embed the channel on the website or add a subscribe to channel button. Here are the code to do so.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>Here are two ways which you can promote a YouTube channel on your website.</p>
<h2>Embedding YouTube Channel on website</h2>
<p>Want to embed a YouTube channel in another web-page or blog? In order to embed your channel, all you need to do is copy then paste the following code in another web-page.</p>
<blockquote><p><code>&lt;script src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/youtube.xml&amp;up_channel=<strong><span style="color: blue;">YourChannelName</span></strong>&amp;synd=open&amp;w=320&amp;h=390&amp;title=&amp;border=%23ffffff%7C3px%2C1px+solid+%23999999&amp;output=js"&gt;&lt;/script&gt;</code></p></blockquote>
<p>Make sure to replace the <span style="color: blue;">YourChannelName</span> with your actual channel name.</p>
<p>For example: if your channel name were <span style="color: blue;">CaliChick94066</span> your channel embed code would be:</p>
<blockquote><p><code>&lt;script src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/youtube.xml&amp;up_channel=<strong><span style="color: blue;">CaliChick94066</span></strong>&amp;synd=open&amp;w=320&amp;h=390&amp;title=&amp;border=%23ffffff%7C3px%2C1px+solid+%23999999&amp;output=js"&gt;&lt;/script&gt;</code></p></blockquote>
<p>Here&#8217;s an example of how it looks like</p>
<h2><script type="text/javascript" src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/youtube.xml&amp;up_channel=edwinguan&amp;synd=open&amp;w=320&amp;h=390&amp;title=&amp;border=%23ffffff%7C3px%2C1px+solid+%23999999&amp;output=js"></script><br />
Adding a Subscribe button on your website</h2>
<blockquote>
<pre> &lt;iframe src="http://www.youtube.com/subscribe_widget?p=<strong><span style="color: blue;">YourChannelName</span></strong>"
       style="overflow: hidden; height: 105px; width: 300px; border: 0;"
       scrolling="no" frameBorder="0"&gt;
    &lt;/iframe&gt;</pre>
</blockquote>
<p>Here&#8217;s an example of how it looks<br />
<iframe style="overflow: hidden; height: 105px; width: 300px; border: 0pt none;" src="http://www.youtube.com/subscribe_widget?p=edwinguan" frameborder="0" scrolling="no" width="320" height="240"></iframe></p>
<div class="shr-publisher-1073"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic -->
<p><a href="http://feedads.g.doubleclick.net/~a/8Pzy712V7PB3UfQkO7f4yLe-Kb8/0/da"><img src="http://feedads.g.doubleclick.net/~a/8Pzy712V7PB3UfQkO7f4yLe-Kb8/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/8Pzy712V7PB3UfQkO7f4yLe-Kb8/1/da"><img src="http://feedads.g.doubleclick.net/~a/8Pzy712V7PB3UfQkO7f4yLe-Kb8/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=MyA1Wu7RfHM:1Weak8yCmbI:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=MyA1Wu7RfHM:1Weak8yCmbI:-BTjWOF_DHI"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=MyA1Wu7RfHM:1Weak8yCmbI:-BTjWOF_DHI" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=MyA1Wu7RfHM:1Weak8yCmbI:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=MyA1Wu7RfHM:1Weak8yCmbI:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=MyA1Wu7RfHM:1Weak8yCmbI:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=MyA1Wu7RfHM:1Weak8yCmbI:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=MyA1Wu7RfHM:1Weak8yCmbI:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=MyA1Wu7RfHM:1Weak8yCmbI:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=MyA1Wu7RfHM:1Weak8yCmbI:F7zBnMyn0Lo" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/LittleHandyTips/~4/MyA1Wu7RfHM" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://littlehandytips.com/promote-youtube-channel-on-your-website/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://littlehandytips.com/promote-youtube-channel-on-your-website/</feedburner:origLink></item>
		<item>
		<title>SQL: Difference between DELETE and TRUNCATE</title>
		<link>http://feedproxy.google.com/~r/LittleHandyTips/~3/kuraamloOXc/</link>
		<comments>http://littlehandytips.com/sql-difference-between-delete-and-truncate/#comments</comments>
		<pubDate>Fri, 02 Sep 2011 02:09:39 +0000</pubDate>
		<dc:creator>Edwin Kwan</dc:creator>
				<category><![CDATA[Computers]]></category>
		<category><![CDATA[General]]></category>
		<category><![CDATA[Tools and Productivity]]></category>
		<category><![CDATA[Computer]]></category>
		<category><![CDATA[Database]]></category>
		<category><![CDATA[MySQL]]></category>
		<category><![CDATA[Oracle]]></category>
		<category><![CDATA[Postgres]]></category>

		<guid isPermaLink="false">http://littlehandytips.com/?p=1068</guid>
		<description><![CDATA[One of the questions I got asked today is what the difference is between the SQL commands DELETE and TRUNCATE. So here we're looking at the differences between DELETE and TRUNCATE.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p>One of the questions I got asked today is what the difference is between the SQL commands DELETE and TRUNCATE.</p>
<p>They both are used to empty out a table, which is different from DROP (which deletes the table)</p>
<p>&nbsp;</p>
<h2>DELETE</h2>
<p>DELETE FROM &lt;table_name&gt;<br />
DELETE FROM &lt;table_name&gt; &lt;where_clause&gt;</p>
<p>Delete is used to remove rows from a table, it can remove all rows or you can specify a where clause to delete only certain rows. A COMMIT needs to be done after a delete and all delete triggers in the table will be fired.</p>
<blockquote><p>DELETE FROM table1 WHERE column1=&#8217;value1&#8242;;<br />
<em>10 rows delete</em>.</p>
<p>COMMIT;<br />
<em>commit complete.</em></p></blockquote>
<h2></h2>
<h2>TRUNCATE</h2>
<p>TRUNCATE TABLE &lt;table_name&gt;</p>
<p>Truncate is used to delete all rows from a table. It does not fire any triggers and there is no rollback. A truncate is therefore much faster than a delete</p>
<blockquote><p>TRUNCATE TABLE table1;<br />
<em>table truncated.</em></p></blockquote>
<p>&nbsp;</p>
<div class="shr-publisher-1068"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic -->
<p><a href="http://feedads.g.doubleclick.net/~a/AmZanwi-uZP3_dOLqB5G0rrka-I/0/da"><img src="http://feedads.g.doubleclick.net/~a/AmZanwi-uZP3_dOLqB5G0rrka-I/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/AmZanwi-uZP3_dOLqB5G0rrka-I/1/da"><img src="http://feedads.g.doubleclick.net/~a/AmZanwi-uZP3_dOLqB5G0rrka-I/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=kuraamloOXc:c-5jZuqkfVo:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=kuraamloOXc:c-5jZuqkfVo:-BTjWOF_DHI"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=kuraamloOXc:c-5jZuqkfVo:-BTjWOF_DHI" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=kuraamloOXc:c-5jZuqkfVo:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=kuraamloOXc:c-5jZuqkfVo:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=kuraamloOXc:c-5jZuqkfVo:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=kuraamloOXc:c-5jZuqkfVo:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=kuraamloOXc:c-5jZuqkfVo:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=kuraamloOXc:c-5jZuqkfVo:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=kuraamloOXc:c-5jZuqkfVo:F7zBnMyn0Lo" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/LittleHandyTips/~4/kuraamloOXc" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://littlehandytips.com/sql-difference-between-delete-and-truncate/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://littlehandytips.com/sql-difference-between-delete-and-truncate/</feedburner:origLink></item>
		<item>
		<title>Postgres/MySQL – How to Show A Specific Range of Rows</title>
		<link>http://feedproxy.google.com/~r/LittleHandyTips/~3/pSVpmU1C2zQ/</link>
		<comments>http://littlehandytips.com/postgres-how-to-show-a-specific-range-of-rows/#comments</comments>
		<pubDate>Wed, 17 Aug 2011 02:02:16 +0000</pubDate>
		<dc:creator>Edwin Kwan</dc:creator>
				<category><![CDATA[Computers]]></category>
		<category><![CDATA[General]]></category>
		<category><![CDATA[Database]]></category>
		<category><![CDATA[MySQL]]></category>
		<category><![CDATA[Postgres]]></category>

		<guid isPermaLink="false">http://littlehandytips.com/?p=1056</guid>
		<description><![CDATA[In Postgres and MySQL database, there is a neat functionality which returns results from a specific range of rows. This is done using LIMIT and OFFSET. The examples in this article demonstrate how they work.]]></description>
			<content:encoded><![CDATA[<!-- Start Shareaholic LikeButtonSetTop Automatic --><!-- End Shareaholic LikeButtonSetTop Automatic --><p><a href="http://littlehandytips.com/wp-content/uploads/2011/08/postgres-logo.png"><img class="alignleft size-full wp-image-1057" style="border-style: initial; border-color: initial; float: left; border-width: 0px;" title="postgres-logo" src="http://littlehandytips.com/wp-content/uploads/2011/08/postgres-logo.png" alt="" width="200" height="206" /></a></p>
<p>In Postgres and MySQL database, there is a neat functionality which returns results from a specific range of rows.</p>
<p>This is very useful if  you have a database with a large number of rows and have an interface which displays only x numbers of rows in a view with the functionality to view the &#8216;second&#8217;, &#8216;third&#8217; page of results and so forth. Rather than having to write code to parse through the entire result set and determine which to display, you can have postgres or SQL do that work for you.</p>
<p>This is done using <strong>LIMIT</strong> and <strong>OFFSET</strong>.</p>
<p>The examples below demonstrate how they works.</p>
<p>Get the top 10 rows of the results.</p>
<blockquote><p>SELECT * FROM TABLE_NAME <strong>LIMIT 10;</strong></p></blockquote>
<p>Get rows 20 to 30 of the results.</p>
<blockquote><p>SELECT * FROM TABLE_NAME <strong>LIMIT 10 OFFSET 20;</strong></p></blockquote>
<div class="shr-publisher-1056"></div><!-- Start Shareaholic LikeButtonSetBottom Automatic --><!-- End Shareaholic LikeButtonSetBottom Automatic -->
<p><a href="http://feedads.g.doubleclick.net/~a/Jw8bWu2rFv3xLsK8OtYHWn2KegM/0/da"><img src="http://feedads.g.doubleclick.net/~a/Jw8bWu2rFv3xLsK8OtYHWn2KegM/0/di" border="0" ismap="true"></img></a><br/>
<a href="http://feedads.g.doubleclick.net/~a/Jw8bWu2rFv3xLsK8OtYHWn2KegM/1/da"><img src="http://feedads.g.doubleclick.net/~a/Jw8bWu2rFv3xLsK8OtYHWn2KegM/1/di" border="0" ismap="true"></img></a></p><div class="feedflare">
<a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=pSVpmU1C2zQ:phaL2p5lOe4:yIl2AUoC8zA"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=yIl2AUoC8zA" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=pSVpmU1C2zQ:phaL2p5lOe4:-BTjWOF_DHI"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=pSVpmU1C2zQ:phaL2p5lOe4:-BTjWOF_DHI" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=pSVpmU1C2zQ:phaL2p5lOe4:V_sGLiPBpWU"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=pSVpmU1C2zQ:phaL2p5lOe4:V_sGLiPBpWU" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=pSVpmU1C2zQ:phaL2p5lOe4:qj6IDK7rITs"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?d=qj6IDK7rITs" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=pSVpmU1C2zQ:phaL2p5lOe4:gIN9vFwOqvQ"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=pSVpmU1C2zQ:phaL2p5lOe4:gIN9vFwOqvQ" border="0"></img></a> <a href="http://feeds.feedburner.com/~ff/LittleHandyTips?a=pSVpmU1C2zQ:phaL2p5lOe4:F7zBnMyn0Lo"><img src="http://feeds.feedburner.com/~ff/LittleHandyTips?i=pSVpmU1C2zQ:phaL2p5lOe4:F7zBnMyn0Lo" border="0"></img></a>
</div><img src="http://feeds.feedburner.com/~r/LittleHandyTips/~4/pSVpmU1C2zQ" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://littlehandytips.com/postgres-how-to-show-a-specific-range-of-rows/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		<feedburner:origLink>http://littlehandytips.com/postgres-how-to-show-a-specific-range-of-rows/</feedburner:origLink></item>
	</channel>
</rss><!-- Performance optimized by W3 Total Cache. Learn more: http://www.w3-edge.com/wordpress-plugins/

Minified using disk: basic
Page Caching using disk: enhanced
Object Caching 1034/1162 objects using disk: basic

Served from: littlehandytips.com @ 2012-04-19 20:54:36 -->

