Today's Question:  What does your personal desk look like?        GIVE A SHOUT

SEARCH KEYWORD -- End

  Inline IF and CASE statements in MySQL

There are times where running IF statements inside a query can be useful. MySQL provides a simple way to do this through the use of IF and CASE statements. The IF statement takes three arguments; the conditional, the true value and the false value. False and true values may be static values or column values. For example: SELECT IF(score > 100, 100, score) AS score FROM exam_results this will return the value in the score column limited to a maximum value of 100. IF statements can a...

   MySQK,IF,Condition,CASE,SQL     2012-04-22 10:37:01

  Stub Mixlib::ShellOut and shell_out in Ruby unit testing

Unit testing is part of software development to ensure the tiny component of a function can work as designed. Different frameworks and tools can be used to run unit testing for different programming languages. In Ruby, one popular unit testing framework is Rspec, or Chefspec if you are writing Chef recipes. While writing Chef recipes, some low level commands(DOS commands or shell commands) need to be executed on the managed resource to perform actions or gather information. For example, lis...

   RUBY,UNIT TESTING,RSPEC,CHEFSPEC,SHELL_OUT     2016-11-11 00:14:46

  Yahoo is going to recycle inactive user IDs

According to Sina Tech, Yahoo announced that it would provide users with shorter, more lovely and more memorable Yahoo IDs starting from July 15. For IDs like emily@yahoo.com, if they are in inactive status in the past 12 months, then other users will be able to get this ID. Yahoo plans to reset Yahoo ID system to help users get the ID they want in mid of July. By mid-August, users who apply for a Yahoo user ID will be informed what kind of ID they get.This means that users can apply multiple ID...

   Yahoo,ID recycle     2013-06-12 21:22:15

  How does JGSS read Windows native TGT credential?

MS LSA is a protected subsystem that authenticates and logs users onto the local system. The user credential is stored at the native credential cache of LSA on Windows. This kind of credential is often used to authenticate the user to the server, one of the authentication methods is Kerberos. JGSS has provided a native interface which can read the native TGT credential and use it to get the TGS of a service. But how does JGSS read the native TGT credential? Here is a sample code for reading nati...

   KERBEROS,JGSS,MS LSA,NATIVE CREDENTIAL,TGT,SESSION KEY TYPE     2015-03-25 03:42:32

  Surface Pro available in mainland China on April 2

According to 36Kr, the Surface Pro will available in mainland China, Australia, France, Germany, Hong Kong , New Zealand and the United Kingdom starting from the end of March. Now the confirmed news is Surface Pro will be on sale in mainland China at 9:00pm on April 2 officially. The Surface Pro price in the United States is 64GB/$899, 128GB/$999. If it's the same in China, then the cheapest Surface Pro should be nearly ¥5600,the 128 GB Surface Pro will be up to ¥6200.Surface Pro configu...

   Surface Pro,China,Sale     2013-03-28 08:51:00

  Programming Language Readability

Lets compare some Python to Haskell for solving the same problem.  The problem we’ll pick is Trie data-structure for auto-completions.  We are interested not so much in the nitty gritty of the algorithm, but in the language style itself.  Auto-complete has been in the programming news a lot recently; both a Python and a Haskell solver have turned up. (I suspect this post got flagged on Hacker News :(  It never got on the front-page despite the rapid upvoting on a n...

   Programming,Readability,Python,Haskell     2012-02-27 04:52:02

  Simple PHP paging class

Frequently in our web applications, we may have many records in the database to display. In order to imrpove loading speed and efficiency, we may need to display some records at a time, so we need to paginate the records. For example, if we have 1 million book records and when users want to view the book list, it's inefficient to display all the records on the same page, we may need to have some pagination to allow displaying a portion of the records such as 20 records per page. This is a simple...

   PHP,Paging,Class     2012-09-10 20:23:33

  Some tips for writing proper emails

Email is now becoming one necessity of working. We may receive hundreds of emails everyday, they may from our colleagues, friends or clients. We need to exchange ideas, arrange meetings , asking for help etc though email in our work. A proper email can help us achieve what we want to achieve. Here we share some tips for writing a proper email.At the beginning of an email : Thank the reader is a good way to start the email, thank the reader may make the reader feel happy, especially when you ask ...

   EMAIL,TIP,FORMAT,TEMPLATE     2012-07-02 12:26:32

  2 million iPhone 5 sold in China in 3 days

Apple announces that since it was available in China from last Friday, iPhone 5 has been sold over 2 million units in 3 days. iPhone 5 was available for sale in China starting from 14th Dec, the price is 5288RMB and up, there are two cooperated vendors in China : China Telecom and China Unicom. They start sell iPhone 5 on their own sales channels, moreover Apple starts selling iPhone in their own Apple Store and official website. According to Tim Cook, because of the high demand of Apple product...

   iPhone 5, China, Sale     2012-12-17 12:27:59

  Windows 8 will be on sale on 26th October

Microsoft announced that they would start to sell Windows 8 on 26th October. Earlier this month at the Microsoft Worldwide Partner Conference, Microsoft promised that they would release Windows 8 in this October.Steven Sinofsky, Windows department manager, announced this news in Microsoft's yearly sales conference. He mentioned that the next generation Windows operating system would be on sale on the Friday 3 months later. But he didn't mention whether Surface would be released at the same time....

   Windows 8, Release date, Sale date,Surface     2012-07-19 10:38:51

RECENT