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
(

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