Published my 100th Post!!!

Just realised that I published my 100th post… which for me is a great feeling.

I started this blog almost 4 years ago (in 1 month it will be 4 years)… exactly on the 13th of October 2006. At first I wanted to create a blog just to have a blog of my own… but over time, the idea of this blog changed.

I’m a software developer and find many problems regarding development and any other apps needed for everyday use which I manage to solve (ok…. I don’t solve every problem). The ones I solve, I try to post on this blog to be of help to other people finding the same problems.

Each post is concise showing immediately what needs to be done to overcome the error so it doesn’t take up much time to solve it. Anyway, hope I helped some people during these last years.

Also thanks to the WordPress guys for developing this application thus making my blog possible, like many other people!!

Thanks for all the support I received Happy Reading my Publishings!!

Robots.txt

Today my supervisor told me to search some info on the robots.txt file. This is a text file that indicates the visiting robots (web robots or web spiders) which parts of the website they are allowed to visit or not. This text file should be inserted in the root directory of the website thus that when you enter the following address www.yourdomain.com/robots.txt the file will be opened.

In this text file you should enter the following data:

User-agent: *    this means that this rule applies to any robot that tries to get information from the site

Disallow: /        this will specify the URL that is not to be visited (in this case, all the website cannot be visited by the robots)

https://www.google.com/webmasters/tools/robots?siteUrl=http%3A%2F%2Fwww.yellowpages.com.mt%2F&hl=en#results

Count Working Days

Sometimes people need to count the difference between two dates. In Sql Server 2000 and 2005 it’s not a problem. To count the difference between the days you van use the following statement:

DATEDIFF(hh, Date 1, Date 2, ) / 24

The difficulty comes when you want to count only the working days of the dates. Maybe not many developers have this problem… but i couldn’t find a solution. After searching i found this function…


CREATE FUNCTION dbo.GetWorkingDays
( Continue reading »

My First Post… Welcome to my blog!!

Dear bloggers, surfers and the rest of the world ,

Welcome to my first blog site. I know you’ll not be reading this post about me but who wants to know more you’re more than welcome… my name is clive and i live in malta. I work as an applications developer at the Yellow Pages. I work mostly with the .Net C# language and currently i am developing an intranet application to be used for reporting purposes and other services that are needed by the company’s employees and managers.

But i also use foxpro since the main application that is being used throughout the company is developed with this language, although some time or another this should be redeveloped with .Net. But since then i’ll have many other projects to do!!

If there’s any one reading my first post and want to leave any comment… just do it!! At least i’ll know that what i’m writing is being read by someone.

Regards,

Clive