20/06/2013 If you want to toggle a value from 1 to 0 or 0 to 1 depending on the current value then you are at the right place. (i.e. change the value to 0 only if it’s 1 now and change it to 1 only if it is 0 at the moment) You can useContinue reading “ILT – Simple technique to toggle between true and false or one and zero”
Category Archives: General Computing
XSD validation for integer – How to allow empty values for integer while limiting value range (ILT)
19-06-2013 How to write XSD to validate an integer field so that only a range of values and empty tags are allowed. Example: I wanted to allow any value between -1 and 999 and also had to allow empty tags for my XML tag. Use of nillable=”true” is not what you want for this. This howContinue reading “XSD validation for integer – How to allow empty values for integer while limiting value range (ILT)”
ILT – How to find if two time frames overlap or collide?
14/06/2013 Let’s assume that time frame 1 starts from Start1 and ends on End1 (Time Frame 1 = Start1 – End1) Similarly Time frame 2 = Start2 – End 2 Time Frame 1 and Frame 2 Over Lap IF: Start1 <= End2 AND End1 >= Start2 Time Frames do not overlap IF: End2 < Start1Continue reading “ILT – How to find if two time frames overlap or collide?”
How to force your website to download a file (rather than opening)
07/05/2013 I wanted to add a download link to one of my products. The file was an Windows Installer Package (*.msi). However, FireFox started to open the file on the browser rather than downloading it so when my visitors tried to download the installer they would rather see some gibberish on the browser because FireFoxContinue reading “How to force your website to download a file (rather than opening)”
ILT – Command to lock a windows computer
19/03/2013 How to program your custom keyboard key to lock your computer? How to programmatically lock your computer? How to lock your computer from the run dialog box? How to lock your computer form DOS? Answer: Just use following command rundll32.exe user32.dll, LockWorkStation You can use this on the command prompt, the run dialog orContinue reading “ILT – Command to lock a windows computer”
Replace Function Doesn’t Replace Double Quotation in VBA
13-11-2012 I had to remove all double quotation marks from a string using VBA. I tried to do this by using the Replace function as shown below. Also Note that two double quotation marks are used to represent the quotation mark. This is because the quotation mark is a special character in VBA and weContinue reading “Replace Function Doesn’t Replace Double Quotation in VBA”
Virtual Laser Keyboard – How it works.
20-02-2009 Computer is the electronic device that has been evolved in the most rapid phase over the time. All parts that all together compose the computer now have come a very long journey when compared with their ancestors. The keyboard, our topic, the most widely used input device in the world, has no exception forContinue reading “Virtual Laser Keyboard – How it works.”
How to Search for UnRead Emails On Gmail?
26-09-2012 How to find un-read emails that are hidden under stacks and stacks of read emails? Simple, just add is:unread to your search then Gmail will bring all unread emails relevant to your search. For example, if you want to see all unread emails from your Friends circle: Usually you would use circle:friends in theContinue reading “How to Search for UnRead Emails On Gmail?”
How To Write A DOS Bat (Batch) File To Check And Delete A Folder With Contents And Then Self-Destruct?
05-09-2012 How to write a simple bat file (DOS command batch file) to find if a directory exists and delete it with all items in it (all files and sub folders). Simple DOS command explanation: IF EXIST will check the existence of the path you provide and execute the command you provide after that (toContinue reading “How To Write A DOS Bat (Batch) File To Check And Delete A Folder With Contents And Then Self-Destruct?”