Order by sequence number in ascending, positioning NULL value at last (order by id ascending)
SELECT * FROM picrure ORDER BY -sequence DESC, id ASC;
Given example: picture table
id
sequence
name
1
NULL
picture_one
2
1
picture_two
3
2
picture_three
4
NULL
...
Monday, 4 February 2019
Saturday, 19 January 2019
19
Jan
This section describe how to implement authentication in React.
First, we need to create React app using this command:
npx create-react-app my-app
We also need to install React Router DOM using command:
npm install --save react-router-dom
Create file src/AppComponent/Authentication.js
This class will handle authentication.
isAuthentication()...
Sunday, 16 December 2018
16
Dec
Lambda expression is an expression that allow to apply one or more expression to a data. Lambda expression use fat arrow (=>) token in an expression. Lambda expression will work on posts, comments, or labels.
Lambda expression pattern:
[variable name] => [expression]
Example:
label => label.name == "Technology"
In...
16
Dec
Arithmetic Operators
Blogger provides arithmetic operator to perform addition (+), subtraction (-), multiplication (*), division (/) and modulo/remainder (%). Additive operator (+) also used for string concatenation.
Operator
Description
+
Adds Left-Operand and Right-Operand, also use...
16
Dec
This section describes the control flow in blogger. Control flow is used to alter the flow of statement execution with decision making and looping that will enabling execute particular blocks of code/show content conditionally.
Decision Making
b:if, b:elseif, & b:else Statement
We can use the b:if, b:elseif and b:else...
Sunday, 28 October 2018
28
Oct
This section show example how to calling API using HttpClient in C#.
ApiCallerHelper.cs
using System.Collections.Generic;
using System.Linq;
using System.Net.Http;
using System.Net.Http.Headers;
namespace WebApplicationMvcApi.Helper
{
public class ApiCallerHelper
{
private static string endpointName =...
Thursday, 17 March 2016
This post shows how to break simple captcha using Tesseract in C#. Challenges in the captcha solving is how to train or make a good algorithm so that the computer more better in recognizing the text, such as a human can read the captcha...
