Windows Keyboard Shotcuts

Keyboard Shorcuts (Microsoft Windows) 

1. CTRL+C (Copy) 
2. CTRL+X (Cut) 
3. CTRL+V (Paste) 
4. CTRL+Z (Undo) 
5. DELETE (Delete) 
6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin) 
7. CTRL while dragging an item (Copy the selected item) 
8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item) 
9. F2 key (Rename the selected item) 
10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) 
11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) 
12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) 
13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) 
14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text) SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document) 
15. CTRL+A (Select all) 
16. F3 key (Search for a file or a folder) 
17. ALT+ENTER (View the properties for the selected item) 
18. ALT+F4 (Close the active item, or quit the active program) 
19. ALT+ENTER (Display the properties of the selected object) 
20. ALT+SPACEBAR (Open the shortcut menu for the active window) 
21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneou sly) 
22. ALT+TAB (Switch between the open items) 
23. ALT+ESC (Cycle through items in the order that they had been opened)
24. F6 key (Cycle through the screen elements in a window or on the desktop) 
25. F4 key (Display the Address bar list in My Computer or Windows Explorer) 
26. SHIFT+F10 (Display the shortcut menu for the selected item) 27. ALT+SPACEBAR (Display the System menu for the active window) 
28. CTRL+ESC (Display the Start menu) 
29. ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command) 
30. F10 key (Activate the menu bar in the active program) 
31. RIGHT ARROW (Open the next menu to the right, or open a submenu) 
32. LEFT ARROW (Open the next menu to the left, or close a submenu) 
33. F5 key (Update the active window) 
34. BACKSPACE (View the folder onelevel up in My Computer or Windows Explorer) 
35. ESC (Cancel the current task) 
36. SHIFT when you insert a CD- ROMinto the CD-ROM drive (Prevent the CD-ROM from automatically playing) 

Dialog Box - Keyboard Shortcuts 

1. CTRL+TAB (Move forward through the tabs) 
2. CTRL+SHIFT+TAB (Move backward through the tabs) 
3. TAB (Move forward through the options) 
4. SHIFT+TAB (Move backward through the options) 
5. ALT+Underlined letter (Perform the corresponding command or select the corresponding option) 
6. ENTER (Perform the command for the active option or button) 
7. SPACEBAR (Select or clear the check box if the active option is a check box) 
8. Arrow keys (Select a button if the active option is a group of option buttons) 
9. F1 key (Display Help) 
10. F4 key (Display the items in the active list) 
11. BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box) 

Microsoft Natural Keyboard Shortcuts 
1. Windows Logo (Display or hide the Start menu) 
2. Windows Logo+BREAK (Display the System Properties dialog box) 
3. Windows Logo+D (Display the desktop) 
4. Windows Logo+M (Minimize all of the windows) 
5. Windows Logo+SHIFT+M (Restorethe minimized windows) 
6. Windows Logo+E (Open My Computer) 
7. Windows Logo+F (Search for a file or a folder) 
8. CTRL+Windows Logo+F (Search for computers) 
9. Windows Logo+F1 (Display Windows Help) 
10. Windows Logo+ L (Lock the keyboard) 
11. Windows Logo+R (Open the Run dialog box) 
12. Windows Logo+U (Open Utility Manager) 
13. Accessibility Keyboard Shortcuts 
14. Right SHIFT for eight seconds (Switch FilterKeys either on or off) 
15. Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off) 
16. Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
17. SHIFT five times (Switch the StickyKeys either on or off) 
18. NUM LOCK for five seconds (Switch the ToggleKeys either on or off) 
19. Windows Logo +U (Open Utility Manager) 
20. Windows Explorer Keyboard Shortcuts 
21. END (Display the bottom of the active window) 
22. HOME (Display the top of the active window) 
23. NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder) 
24. NUM LOCK+Plus sign (+) (Display the contents of the selected folder) 

MMC COnsole Windows Shortcut keys 
1. SHIFT+F10 (Display the Action shortcut menu for the selected item) 
2. F1 key (Open the Help topic, if any, for the selected item) 
3. F5 key (Update the content of all console windows) 
4. CTRL+F10 (Maximize the active console window) 
5. CTRL+F5 (Restore the active console window) 
6. ALT+ENTER (Display the Properties dialog box, if any, for theselected item) 
7. F2 key (Rename the selected item) 
8. CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console) 

Remote Desktop Connection Navigation 
1. CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box) 
2. ALT+PAGE UP (Switch between programs from left to right) 
3. ALT+PAGE DOWN (Switch between programs from right to left) 4. ALT+INSERT (Cycle through the programs in most recently used order) 
5. ALT+HOME (Display the Start menu) 
6. CTRL+ALT+BREAK (Switch the client computer between a window and a full screen) 
7. ALT+DELETE (Display the Windows menu) 
8. CTRL+ALT+Minus sign (-) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.) 
9. CTRL+ALT+Plus sign (+) (Place asnapshot of the entire client window area on the Terminal server clipboardand provide the same functionality aspressing ALT+PRINT SCREEN on a local computer.) 

Microsoft Internet Explorer Keyboard Shortcuts 
1. CTRL+B (Open the Organize Favorites dialog box) 
2. CTRL+E (Open the Search bar) 
3. CTRL+F (Start the Find utility) 
4. CTRL+H (Open the History bar) 
5. CTRL+I (Open the Favorites bar) 
6. CTRL+L (Open the Open dialog box) 
7. CTRL+N (Start another instance of the browser with the same Web address) 
8. CTRL+O (Open the Open dialog box,the same as CTRL+L) 
9. CTRL+P (Open the Print dialog box) 
10. CTRL+R (Update the current Web )

Read More

Cara Instalasi Extension Bootstrap di Yii

Download Bootstrap  disini

Extract files dan tempatkan folder 'extensions' di dalam folder web aplikasi.

Pada file "\protected\config\main.php" lakukan konfigurasi berikut :

Define path alias 
Yii::setPathOfAlias('bootstrap',dirname(__FILE__).'/../extensions/bootstrap');

Define Theme
'theme'=>'bootstrap',

dan Module
'generatorPaths'=>array(
            'bootstrap.gii',

Define app component
'bootstrap'=>array(
        'class'=>'bootstrap.components.Bootstrap',
        ),

Pada file "\protected\views\layouts\main.php" lakukan konfigurasi berikut :
Register CSS
bootstrap->registerAllCss(); 

Read More

Membuat Web Aplikasi pada Yii dengan full path script

Path PHP dan Yii sudah didaftarkan pada system tapi belum juga berhasil ??

Gunakan cara dengan menjalankan script ful path untuk membuat Web Application.

Masuk ke dalam folder web appliasi terlebih dahulu, misal C:\xampp\htdocs\

C:\xampp\php\php.exe c:\xampp\htdocs\yii\framework\yiic webapp testdrive

Read More

7 reasons why Yii framework is better than CodeIgniter

I guess this will not be the first nor the last text comparing those two frameworks, but I got so amazed with Yii that I have to write it.

Let’s be clear, CodeIgniter is just a little bit more of a simple MVC framework. Yii is a complete web-development framework used for rapid web application development. Let’s compare them in detail…

CodeIgniter is great for beginners. If you barely have a clue what MVC stands for, I highly recommend it. It features great tutorials and is super-easy to learn. If you want to learn what MVC is and how to use it, take a look at CodeIgniter video tutorials. CodeIgniter enables you to go into coding really fast and create basic stuff quickly. But, that’s all. It’s great to learn MVC, and it works fine even for large websites. However, you have to do a lot of things by hand. If you’re experienced PHP developer you might even be used to that and you won’t see anything missing in CodeIgniter.

I built a couple of websites using CodeIgniter, most visited on is slagalica.tv with about 30k visits/day.

From 2009 on I was testing Yii, but I only got to use it for the real project last month. Be prepared, if you are not experienced with MVC frameworks, you might find the learning curve really steep. Yii is very powerful, but to harness the power you need to learn all the features and the way stuff is done in yii. Instead of just going in and coding, take some time to read the docs, wiki and create some simple small project to learn it. Whenever you are doing something that seems like too much manual work, look for ready-made yii-way solution.

So, what makes Yii so much better? I don’t know where to start, so I’ll just enumerate:

1. Gii code generator. Gii can create template models, views, controllers and forms. The special case CRUD really makes it stand out. You simply give it the database table name, and it creates model with all the attributes. You just define data type (numeric, etc.) whether field is required, and those rules get applied ALWAYS when you try to save/update the data. In CodeIgniter, you need to validate it on each action. The difference is that CodeIgniter is form-oriented while Yii is data-oriented
2. Form handling. Gii generated forms use “active” fields. This means that when some field is not validated, yii would display the same form to fix the problem with all the data filled in
3. HTML Grid component. Enables to display data in tabular way with automatic sorting, paging, coloring of even and odd rows, etc.
4. jQuery integration. This means that stuff like date-picker or auto-complete input boxes are usually one line of PHP code and Yii spits out all the required Javascript, HTML and CSS code.
5. Translations. Creating multilingual websites in Yii is really easy. With CodeIgniter you would have to create your own way of doing it.
6. Database relations. Yii supports lazy loading. This means that you don’t have to write JOINs each time you need to get a value of related table (for example: name of author of a blog post). If you have a ActiveRecord instance of blog post as $post, you simply refer to author’s name like this: $post->author->name. Yii would execute the needed SQL to get it.
7. Consistency. Yii is much better choice if you have multiple developers working on the project. Yii introduces rules how stuff should be done, and there is no reinventing the whell. This means that all developers create the code that others can pick up easily.

Example of site I’m building using Yii: setlopta.com. There’s a link to English version in top-right corner.

source : http://www.backwardcompatible.net/123-7-reasons-why-yii-framework-is-better-than-codeigniter

Read More

SQL Server - Date Formats

SQL Server Date Formats

One of the most frequently asked questions in SQL Server forums is how to format a datetime value or column into a specific date format.  Here's a summary of the different date formats that come standard in SQL Server as part of the CONVERT function.  Following the standard date formats are some extended date formats that are often asked by SQL Server developers.

It is worth to note that the output of these date formats are of VARCHAR data types already and not of DATETIME data type.  With this in mind, any date comparisons performed after the datetime value has been formatted are using the VARCHAR value of the date and time and not its original DATETIME value.

Standard Date Formats Date Format Standard SQL Statement Sample Output Mon DD YYYY 1 HH:MIAM (or PM) Default SELECT CONVERT(VARCHAR(20), GETDATE(), 100) Jan 1 2005 1:29PM 1 MM/DD/YY USA SELECT CONVERT(VARCHAR(8), GETDATE(), 1) AS [MM/DD/YY] 11/23/98 MM/DD/YYYY USA SELECT CONVERT(VARCHAR(10), GETDATE(), 101) AS [MM/DD/YYYY] 11/23/1998 YY.MM.DD ANSI SELECT CONVERT(VARCHAR(8), GETDATE(), 2) AS [YY.MM.DD] 72.01.01 YYYY.MM.DD ANSI SELECT CONVERT(VARCHAR(10), GETDATE(), 102) AS [YYYY.MM.DD] 1972.01.01 DD/MM/YY British/French SELECT CONVERT(VARCHAR(8), GETDATE(), 3) AS [DD/MM/YY] 19/02/72 DD/MM/YYYY British/French SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY] 19/02/1972 DD.MM.YY German SELECT CONVERT(VARCHAR(8), GETDATE(), 4) AS [DD.MM.YY] 25.12.05 DD.MM.YYYY German SELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [DD.MM.YYYY] 25.12.2005 DD-MM-YY Italian SELECT CONVERT(VARCHAR(8), GETDATE(), 5) AS [DD-MM-YY] 24-01-98 DD-MM-YYYY Italian SELECT CONVERT(VARCHAR(10), GETDATE(), 105) AS [DD-MM-YYYY] 24-01-1998 DD Mon YY 1 - SELECT CONVERT(VARCHAR(9), GETDATE(), 6) AS [DD MON YY] 04 Jul 06 1 DD Mon YYYY 1 - SELECT CONVERT(VARCHAR(11), GETDATE(), 106) AS [DD MON YYYY] 04 Jul 2006 1 Mon DD, YY 1 - SELECT CONVERT(VARCHAR(10), GETDATE(), 7) AS [Mon DD, YY] Jan 24, 98 1 Mon DD, YYYY 1 - SELECT CONVERT(VARCHAR(12), GETDATE(), 107) AS [Mon DD, YYYY] Jan 24, 1998 1 HH:MM:SS - SELECT CONVERT(VARCHAR(8), GETDATE(), 108) 03:24:53 Mon DD YYYY HH:MI:SS:MMMAM (or PM) 1 Default + milliseconds SELECT CONVERT(VARCHAR(26), GETDATE(), 109) Apr 28 2006 12:32:29:253PM 1 MM-DD-YY USA SELECT CONVERT(VARCHAR(8), GETDATE(), 10) AS [MM-DD-YY] 01-01-06 MM-DD-YYYY USA SELECT CONVERT(VARCHAR(10), GETDATE(), 110) AS [MM-DD-YYYY] 01-01-2006 YY/MM/DD - SELECT CONVERT(VARCHAR(8), GETDATE(), 11) AS [YY/MM/DD] 98/11/23 YYYY/MM/DD - SELECT CONVERT(VARCHAR(10), GETDATE(), 111) AS [YYYY/MM/DD] 1998/11/23 YYMMDD ISO SELECT CONVERT(VARCHAR(6), GETDATE(), 12) AS [YYMMDD] 980124 YYYYMMDD ISO SELECT CONVERT(VARCHAR(8), GETDATE(), 112) AS [YYYYMMDD] 19980124 DD Mon YYYY HH:MM:SS:MMM(24h) 1 Europe default + milliseconds SELECT CONVERT(VARCHAR(24), GETDATE(), 113) 28 Apr 2006 00:34:55:190 1 HH:MI:SS:MMM(24H) - SELECT CONVERT(VARCHAR(12), GETDATE(), 114) AS [HH:MI:SS:MMM(24H)] 11:34:23:013 YYYY-MM-DD HH:MI:SS(24h) ODBC Canonical SELECT CONVERT(VARCHAR(19), GETDATE(), 120) 1972-01-01 13:42:24 YYYY-MM-DD HH:MI:SS.MMM(24h) ODBC Canonical (with milliseconds) SELECT CONVERT(VARCHAR(23), GETDATE(), 121) 1972-02-19 06:35:24.489 YYYY-MM-DDTHH:MM:SS:MMM ISO8601 SELECT CONVERT(VARCHAR(23), GETDATE(), 126) 1998-11-23T11:25:43:250 DD Mon YYYY HH:MI:SS:MMMAM 1 Kuwaiti SELECT CONVERT(VARCHAR(26), GETDATE(), 130) 28 Apr 2006 12:39:32:429AM 1 DD/MM/YYYY HH:MI:SS:MMMAM Kuwaiti SELECT CONVERT(VARCHAR(25), GETDATE(), 131) 28/04/2006 12:39:32:429AM

Here are some more date formats that does not come standard in SQL Server as part of the CONVERT function. Extended Date Formats Date Format SQL Statement Sample Output YY-MM-DD SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 8) AS [YY-MM-DD] SELECT REPLACE(CONVERT(VARCHAR(8), GETDATE(), 11), '/', '-') AS [YY-MM-DD] 99-01-24 YYYY-MM-DD SELECT CONVERT(VARCHAR(10), GETDATE(), 120) AS [YYYY-MM-DD] SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 111), '/', '-') AS [YYYY-MM-DD] 1999-01-24 MM/YY SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 3), 5) AS [MM/YY] SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 3), 4, 5) AS [MM/YY] 08/99 MM/YYYY SELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 103), 7) AS [MM/YYYY] 12/2005 YY/MM SELECT CONVERT(VARCHAR(5), GETDATE(), 11) AS [YY/MM] 99/08 YYYY/MM SELECT CONVERT(VARCHAR(7), GETDATE(), 111) AS [YYYY/MM] 2005/12 Month DD, YYYY 1 SELECT DATENAME(MM, GETDATE()) + RIGHT(CONVERT(VARCHAR(12), GETDATE(), 107), 9) AS [Month DD, YYYY] July 04, 20061 Mon YYYY1 SELECT SUBSTRING(CONVERT(VARCHAR(11), GETDATE(), 113), 4, 8) AS [Mon YYYY] Apr 2006 1 Month YYYY 1 SELECT DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [Month YYYY] February 2006 1 DD Month1 SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) AS [DD Month] 11 September 1 Month DD1 SELECT DATENAME(MM, GETDATE()) + ' ' + CAST(DAY(GETDATE()) AS VARCHAR(2)) AS [Month DD] September 11 1 DD Month YY 1 SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + RIGHT(CAST(YEAR(GETDATE()) AS VARCHAR(4)), 2) AS [DD Month YY] 19 February 72 1 DD Month YYYY 1 SELECT CAST(DAY(GETDATE()) AS VARCHAR(2)) + ' ' + DATENAME(MM, GETDATE()) + ' ' + CAST(YEAR(GETDATE()) AS VARCHAR(4)) AS [DD Month YYYY] 11 September 2002 1 MM-YY SELECT RIGHT(CONVERT(VARCHAR(8), GETDATE(), 5), 5) AS [MM-YY] SELECT SUBSTRING(CONVERT(VARCHAR(8), GETDATE(), 5), 4, 5) AS [MM-YY] 12/92 MM-YYYY SELECT RIGHT(CONVERT(VARCHAR(10), GETDATE(), 105), 7) AS [MM-YYYY] 05-2006 YY-MM SELECT RIGHT(CONVERT(VARCHAR(7), GETDATE(), 120), 5) AS [YY-MM] SELECT SUBSTRING(CONVERT(VARCHAR(10), GETDATE(), 120), 3, 5) AS [YY-MM] 92/12 YYYY-MM SELECT CONVERT(VARCHAR(7), GETDATE(), 120) AS [YYYY-MM] 2006-05 MMDDYY SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 1), '/', '') AS [MMDDYY] 122506 MMDDYYYY SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 101), '/', '') AS [MMDDYYYY] 12252006 DDMMYY SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 3), '/', '') AS [DDMMYY] 240702 DDMMYYYY SELECT REPLACE(CONVERT(VARCHAR(10), GETDATE(), 103), '/', '') AS [DDMMYYYY] 24072002 Mon-YY 1 SELECT REPLACE(RIGHT(CONVERT(VARCHAR(9), GETDATE(), 6), 6), ' ', '-') AS [Mon-YY] Sep-02 1 Mon-YYYY1 SELECT REPLACE(RIGHT(CONVERT(VARCHAR(11), GETDATE(), 106), 8), ' ', '-') AS [Mon-YYYY] Sep-2002 1 DD-Mon-YY 1 SELECT REPLACE(CONVERT(VARCHAR(9), GETDATE(), 6), ' ', '-') AS [DD-Mon-YY] 25-Dec-05 1 DD-Mon-YYYY 1 SELECT REPLACE(CONVERT(VARCHAR(11), GETDATE(), 106), ' ', '-') AS [DD-Mon-YYYY] 25-Dec-20051 1 To make the month name in upper case, simply use the UPPER string function.

source: http://www.sql-server-helper.com/tips/date-formats.aspx

Read More

Displays a list of files and subdirectories in a directory

Example : DIR  /C /O:N > filename.txt
->get list of files with file size and put into text file

enjoy IT.

DIR [drive:][path][filename] [/A[[:]attributes]] [/B] [/C] [/D] [/L] [/N]
  [/O[[:]sortorder]] [/P] [/Q] [/R] [/S] [/T[[:]timefield]] [/W] [/X] [/4]

  [drive:][path][filename]
              Specifies drive, directory, and/or files to list.

  /A          Displays files with specified attributes.
  attributes   D  Directories                R  Read-only files
               H  Hidden files               A  Files ready for archiving
               S  System files               I  Not content indexed files
               L  Reparse Points             -  Prefix meaning not
  /B          Uses bare format (no heading information or summary).
  /C          Display the thousand separator in file sizes.  This is the
              default.  Use /-C to disable display of separator.
  /D          Same as wide but files are list sorted by column.
  /L          Uses lowercase.
  /N          New long list format where filenames are on the far right.
  /O          List by files in sorted order.
  sortorder    N  By name (alphabetic)       S  By size (smallest first)
               E  By extension (alphabetic)  D  By date/time (oldest first)
               G  Group directories first    -  Prefix to reverse order
  /P          Pauses after each screenful of information.
  /Q          Display the owner of the file.
  /R          Display alternate data streams of the file.
  /S          Displays files in specified directory and all subdirectories.
  /T          Controls which time field displayed or used for sorting
  timefield   C  Creation
              A  Last Access
              W  Last Written
  /W          Uses wide list format.
  /X          This displays the short names generated for non-8dot3 file
              names.  The format is that of /N with the short name inserted
              before the long name. If no short name is present, blanks are
              displayed in its place.
  /4          Displays four-digit years

Switches may be preset in the DIRCMD environment variable.  Override
preset switches by prefixing any switch with - (hyphen)--for example, /-W.

Read More

Get Latitude and Longitude values from Google Maps

Google Maps do not display latitude and longitude values, but there is an easy trick to get these numbers. This technique will provide the latitude and longitude coordinates of the center of the map displayed by Google Maps.

Looking up an address in Google Maps will center the map on that address if it was found. Because this trick provides the latitude and longitude of the center of the map, moving the map around manually after that will change the center position and this technique will not work accurately.

When the location you want is in the center of the map, copy and paste this code into the location bar of your browser and press enter:

javascript:void(prompt('',gApplication.getMap().getCenter()));

A little dialog box will pop up displaying the coordinates which can be copied and pasted for use elsewhere. This code can be bookmarked and then used in the future by selecting the bookmark.

If you don’t like using javascript, you can use the easy way to find latitude and longitude

source

Read More