<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:georss='http://www.georss.org/georss' xmlns:gd='http://schemas.google.com/g/2005' xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-5962713316192810545</id><updated>2011-09-07T14:53:17.708+01:00</updated><category term='Dotnetnuke'/><category term='Menu'/><category term='Service Pack 2'/><category term='Dedicated'/><category term='301 redirect'/><category term='CSS'/><category term='Case Statements'/><category term='Stylesheet'/><category term='SQL Server'/><category term='Library'/><category term='SBS2003'/><category term='Login control'/><category term='SQL Inline Statements'/><category term='IIS'/><category term='MAC'/><category term='Media Player'/><category term='Inline'/><category term='ASP.NET'/><category term='redirect to www address'/><category term='download'/><category term='Hosting'/><category term='Rebuild'/><category term='IE8'/><category term='Sharepoint'/><category term='Install skins in DNN'/><category term='cannot create file'/><category term='Search Error'/><category term='Response Times'/><category term='Skins'/><category term='DNN'/><category term='Install Error'/><category term='safari'/><title type='text'>Blacksnow Web Design</title><subtitle type='html'>We are a web design and software development agency based near Totnes in Devon. We create user friendly and content rich sites for clients nationwide.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default?max-results=100'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>12</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>100</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-7533613128651646227</id><published>2011-01-17T14:21:00.002Z</published><updated>2011-01-17T14:25:06.833Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='Search Error'/><category scheme='http://www.blogger.com/atom/ns#' term='Sharepoint'/><category scheme='http://www.blogger.com/atom/ns#' term='SBS2003'/><title type='text'>Sharepoint Search Error</title><content type='html'>Came across a problem today with Sharepoint on SBS2003. There were records in the log that content could not be searched. The answer was to create 2 new users specifically for these roles. Details can be found at &lt;a href="http://msmvps.com/blogs/cgross/archive/2009/03/29/sharepoint-search-amp-event-id-2436-errors-in-sbs-2008.aspx"&gt;msmvps.com&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-7533613128651646227?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/7533613128651646227/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2011/01/sharepoint-search-error.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/7533613128651646227'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/7533613128651646227'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2011/01/sharepoint-search-error.html' title='Sharepoint Search Error'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-953260898661820861</id><published>2010-12-11T09:40:00.002Z</published><updated>2010-12-11T09:47:15.697Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='Library'/><category scheme='http://www.blogger.com/atom/ns#' term='Rebuild'/><category scheme='http://www.blogger.com/atom/ns#' term='Media Player'/><title type='text'>Media Player Library Details</title><content type='html'>When starting media player for the first time if you have an existing library collection I would advise to uncheck the option where media player tries to update the music files information. Generally I have found it just makes a mess of things.&lt;br /&gt;&lt;br /&gt;This can be found in WMP12 in Organise --&gt; Options and then on the 'Library' tab. Uncheck 'Retrieve information from the internet'&lt;br /&gt;&lt;br /&gt;If you forget to do this then you can delete the current library and start again.&lt;br /&gt;&lt;br /&gt;Just delete all the files in the root of the following folder on Windows 7&lt;br /&gt;&lt;br /&gt;C:\Users\YOUR USERNAME\AppData\Local\Microsoft\Media Player&lt;br /&gt;&lt;br /&gt;media player will then rebuild them.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-953260898661820861?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/953260898661820861/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2010/12/media-player-library-details.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/953260898661820861'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/953260898661820861'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2010/12/media-player-library-details.html' title='Media Player Library Details'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-1428569458920636909</id><published>2010-11-25T06:49:00.003Z</published><updated>2010-11-25T06:53:28.359Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='Install Error'/><category scheme='http://www.blogger.com/atom/ns#' term='SQL Server'/><category scheme='http://www.blogger.com/atom/ns#' term='Service Pack 2'/><title type='text'>SQL Server 2008 Service Pack 2 Install Error</title><content type='html'>If you get Error Code 84C40007 while trying to install Microsoft SQL Server Service Pack 2 then you will need to install the Mircosoft Dot Net Framework 4 first. Get it at &lt;a href="http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&amp;amp;FamilyID=0a391abd-25c1-4fc0-919f-b21f31ab88b7" target="_blank"&gt;http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&amp;amp;FamilyID=0a391abd-25c1-4fc0-919f-b21f31ab88b7&lt;/a&gt;&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-1428569458920636909?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/1428569458920636909/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2010/11/sql-server-2008-service-pack-2-install.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/1428569458920636909'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/1428569458920636909'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2010/11/sql-server-2008-service-pack-2-install.html' title='SQL Server 2008 Service Pack 2 Install Error'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-1435593097455897100</id><published>2010-03-09T14:10:00.003Z</published><updated>2010-03-09T14:17:32.828Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='Hosting'/><category scheme='http://www.blogger.com/atom/ns#' term='Response Times'/><category scheme='http://www.blogger.com/atom/ns#' term='Dedicated'/><title type='text'>Hosting performance</title><content type='html'>It seems difficult to find any accurate data on hosting. I am looking at another dedicated server at the moment for a client. There are forums and hosting comparison sites with peoples opinions, usually negative, as who actively goes on to &lt;span style="BACKGROUND-COLOR: #ffff00"&gt;publicise&lt;/span&gt; the great host they are with, so it is hard to find an true picture.&lt;br /&gt;One site I did find useful and interesting was &lt;a href="http://host-tracker.com/"&gt;http://host-tracker.com&lt;/a&gt; which provides response times on your website.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-1435593097455897100?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/1435593097455897100/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2010/03/hosting-performance.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/1435593097455897100'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/1435593097455897100'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2010/03/hosting-performance.html' title='Hosting performance'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-2280952155944953223</id><published>2010-01-07T19:14:00.002Z</published><updated>2010-01-07T19:20:01.339Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='IE8'/><category scheme='http://www.blogger.com/atom/ns#' term='ASP.NET'/><category scheme='http://www.blogger.com/atom/ns#' term='CSS'/><category scheme='http://www.blogger.com/atom/ns#' term='Login control'/><title type='text'>Asp.Net Login control in IE8</title><content type='html'>The asp.net login control in IE8 doesn't look great. The spacing between the username and password boxes is no existant. Two ways of sorting it:&lt;br /&gt;1. Convert it to a template and insert your own css&lt;br /&gt;2. Using the following in the code behind&lt;br /&gt;&lt;br /&gt;Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init&lt;br /&gt;&lt;br /&gt;CType(aspnet_login.FindControl("UserName"), TextBox).Attributes.Add("style", "margin-bottom: 6px; margin-left: 2px;")&lt;br /&gt;CType(aspnet_login.FindControl("Password"), TextBox).Attributes.Add("style", "margin-left: 2px;")&lt;br /&gt;&lt;br /&gt;End Sub&lt;br /&gt;&lt;br /&gt;Alternatively Microsoft could update the .net framework?!?&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-2280952155944953223?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/2280952155944953223/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2010/01/aspnet-login-control-in-ie8.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/2280952155944953223'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/2280952155944953223'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2010/01/aspnet-login-control-in-ie8.html' title='Asp.Net Login control in IE8'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-5097285367193752014</id><published>2010-01-06T14:45:00.004Z</published><updated>2010-01-06T14:48:30.215Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='download'/><category scheme='http://www.blogger.com/atom/ns#' term='MAC'/><category scheme='http://www.blogger.com/atom/ns#' term='safari'/><category scheme='http://www.blogger.com/atom/ns#' term='cannot create file'/><title type='text'>'cannot create file' download error in safari on MAC</title><content type='html'>When you download in safari on the MAC you can get an error message 'cannot create file'. Many posts mention permissions on the folder you are downloading to but the problem I had was that the harddrive didn't have enough space for the file being downloaded. When I made some space the error went away and the file downloaded. Good error message Apple!&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-5097285367193752014?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/5097285367193752014/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2010/01/cannot-create-file-download-error-in.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/5097285367193752014'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/5097285367193752014'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2010/01/cannot-create-file-download-error-in.html' title='&apos;cannot create file&apos; download error in safari on MAC'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-9056495233115394373</id><published>2009-06-12T16:08:00.001+01:00</published><updated>2009-06-12T16:10:57.996+01:00</updated><title type='text'>Fix the web server port in Visual Studio</title><content type='html'>You can fix the port the web server uses in VS 2008 by clicking F4 or From the menu 'View' --&gt; 'Properties Window'. The change 'Use dynamic ports' to false and this will allow you to change the port number (which is disabled when you first come in to the window). I use port 50000 fyi.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-9056495233115394373?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/9056495233115394373/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/06/fix-web-server-port-in-visual-studio.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/9056495233115394373'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/9056495233115394373'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/06/fix-web-server-port-in-visual-studio.html' title='Fix the web server port in Visual Studio'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-5115491215484041712</id><published>2009-04-08T11:49:00.004+01:00</published><updated>2009-04-08T16:00:10.717+01:00</updated><category scheme='http://www.blogger.com/atom/ns#' term='IIS'/><category scheme='http://www.blogger.com/atom/ns#' term='redirect to www address'/><category scheme='http://www.blogger.com/atom/ns#' term='301 redirect'/><title type='text'>Redirects with IIS</title><content type='html'>Moving a website from one domain to another or from a sub domain to a new domain can be nervous at the best of times without the worry of your search engine ranking. The best way of overcoming this is to use 301 redirect (even google rcommends it under its &lt;a href="http://www.google.com/support/webmasters/bin/topic.py?topic=8522"&gt;Google-friendly sites&lt;/a&gt;). In &lt;span class="blsp-spelling-error" id="SPELLING_ERROR_0"&gt;IIS&lt;/span&gt; this is done on the 'Home directory' tab in the properties of the website. Check the 'A redirection to a URL' &lt;span class="blsp-spelling-error" id="SPELLING_ERROR_1"&gt;radiobutton&lt;/span&gt; and then complete the web address below and check 'A &lt;span class="blsp-spelling-corrected" id="SPELLING_ERROR_2"&gt;permanent&lt;/span&gt; redirection for this resource'. You will find that when you visit the old domain you will automatically we send to the new one you have just specified.&lt;br /&gt;This is also useful if you have code based on a certain web address or licenses for components that work off a certain web address and you want people arriving at &lt;a href="http://blacksnow.co.uk/"&gt;http://blacksnow.co.uk/&lt;/a&gt; to go to &lt;a href="http://www.blacksnow.co.uk/"&gt;http://www.blacksnow.co.uk/&lt;/a&gt; instead.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-5115491215484041712?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/5115491215484041712/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/04/redirects-with-iis.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/5115491215484041712'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/5115491215484041712'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/04/redirects-with-iis.html' title='Redirects with IIS'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-2904955344934861984</id><published>2009-03-09T17:05:00.003Z</published><updated>2009-03-09T17:09:52.176Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='Dotnetnuke'/><category scheme='http://www.blogger.com/atom/ns#' term='Install skins in DNN'/><category scheme='http://www.blogger.com/atom/ns#' term='Skins'/><title type='text'></title><content type='html'>Quite often it is not very clear on how to install your new skin in Dotnetnuke. DNN needs you to login with the host account. Then in DNN 4.9 click 'skins' on the host menu and then 'upload skin' from the dropdown menu next to the skin header. You need to point the 'browse' button to the zip file that contains your skin. This is often inside a number of zip files if you have purchased the skin from a vendor, so you will have to extract them first.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-2904955344934861984?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/2904955344934861984/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/03/quite-often-it-is-not-very-clear-on-how.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/2904955344934861984'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/2904955344934861984'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/03/quite-often-it-is-not-very-clear-on-how.html' title=''/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-2035835250419431710</id><published>2009-03-02T16:21:00.002Z</published><updated>2009-03-02T16:26:57.468Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='SQL Inline Statements'/><category scheme='http://www.blogger.com/atom/ns#' term='Case Statements'/><category scheme='http://www.blogger.com/atom/ns#' term='SQL Server'/><category scheme='http://www.blogger.com/atom/ns#' term='Inline'/><title type='text'>SQL Inline statements</title><content type='html'>Thought I'd post a quicky on SQL inline statements. Before I would create a variable and then assign a value depending on a CASE statement. But after a brief try I solved a problem with dates using an inline case statement. Converting the minute datepart to a string means that 5 past the hour becomes just 5 and doesn't look write in date strings. So i wanted any single numbers to be prefixed with zero. Here it is:&lt;br /&gt;&lt;br /&gt;CONVERT(nVARCHAR,CreatedDate,103) + ' @ ' + CONVERT(nVARCHAR,DATEPART(Hh, CreatedDate)) + ':' + CASE WHEN LEN(CONVERT(nVARCHAR,DATEPART(Mi, CreatedDate))) = 1 THEN '0' + CONVERT(nVARCHAR,DATEPART(Mi, CreatedDate)) ELSE CONVERT(nVARCHAR,DATEPART(Mi, CreatedDate)) END AS CreatedDate&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-2035835250419431710?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/2035835250419431710/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/03/sql-inline-statements.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/2035835250419431710'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/2035835250419431710'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/03/sql-inline-statements.html' title='SQL Inline statements'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-5216212632690152569</id><published>2009-02-27T16:48:00.002Z</published><updated>2009-02-27T16:54:52.548Z</updated><title type='text'>Silverlight, the beginnings</title><content type='html'>I have been playing with silverlight this afternoon. Nice touches, learnt loads but some annoying things.&lt;br /&gt;The error message 'AG_E_PARSER_BAD_PROPERTY_VALUE' means you have a referenced a method in your xaml code without it existing in your xaml.vb code, really helpful error message!&lt;br /&gt;Also why does Microsoft feel the need to mess with certain properties? The listbox for example is now not .enabled but .isenabled. Maybe someone can shed some light on this?&lt;br /&gt;So with the first application built and being beta tested we can now explore this technology a little more.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-5216212632690152569?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/5216212632690152569/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/02/silverlight-beginnings.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/5216212632690152569'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/5216212632690152569'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/02/silverlight-beginnings.html' title='Silverlight, the beginnings'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5962713316192810545.post-3266745301973030151</id><published>2009-02-23T14:09:00.000Z</published><updated>2009-02-23T14:18:35.862Z</updated><category scheme='http://www.blogger.com/atom/ns#' term='Stylesheet'/><category scheme='http://www.blogger.com/atom/ns#' term='Menu'/><category scheme='http://www.blogger.com/atom/ns#' term='DNN'/><title type='text'>DNN menus in 4.9</title><content type='html'>The dnn top menus in 4.9 are in my opinion a little large and only allows about 5 headings to be added before 'admin' and 'host' headers disappear behind the search bar when you login. The easiest way around this is to reduce the font size from the standard 13px to whatever you want (I think 11px works best, which is also the size of the submenu items). To do this go to Portals\_default\Skins\MinimalExtropy_SmallMenu\css and alter the font size of .main_dnnmenu_rootitem and .main_dnnmenu_rootitem_hover and .main_dnnmenu_rootitem_selected. To make the menu items closer together reduce the left and right padding elements to 7px on the same style classes.&lt;div class="blogger-post-footer"&gt;&lt;img width='1' height='1' src='https://blogger.googleusercontent.com/tracker/5962713316192810545-3266745301973030151?l=blacksnowwebdesign.blogspot.com' alt='' /&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://blacksnowwebdesign.blogspot.com/feeds/3266745301973030151/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/02/dnn-menus-in-49.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/3266745301973030151'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5962713316192810545/posts/default/3266745301973030151'/><link rel='alternate' type='text/html' href='http://blacksnowwebdesign.blogspot.com/2009/02/dnn-menus-in-49.html' title='DNN menus in 4.9'/><author><name>Blacksnow Web Design</name><uri>http://www.blogger.com/profile/13588416919590582264</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='http://img2.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>
