Tutorial by Examples: el

First we need to set up two basic channels, one for the main queue, and one for the delay queue. In my example at the end, I include a couple of additional flags that are not required, but makes the code more reliable; such as confirm delivery, delivery_mode and durable. You can find more informatio...

If you want to delete rows (or columns) in a loop, you should always loop starting from the end of range and move back in every step. In case of using the code: Dim i As Long With Workbooks("Book1").Worksheets("Sheet1") For i = 1 To 4 If IsEmpty(.Cells(i, 1)) Then...

#Modules to use use Cwd 'abs_path'; use Win32::OLE; use Win32::OLE qw(in with); use Win32::OLE::Const "Microsoft Excel"; $Win32::OLE::Warn = 3; #Need to use absolute path for Excel files my $excel_file = abs_path("$Excel_path") or die "Error: the file $Excel_path ha...

#Edit the value of a cell (2 methods) $Sheet->Range("A1")->{Value} = 1234; $Sheet->Cells(1,1)->{Value} = 1234; #Edit the values in a range of cells $Sheet->Range("A8:C9")->{Value} = [[ undef, 'Xyzzy', 'Plugh' ], [ 42, 'Pe...

Setting a field to NULL works exactly like with any other value: UPDATE Employees SET ManagerId = NULL WHERE Id = 4

For example inserting an employee with no phone number and no manager into the Employees example table: INSERT INTO Employees (Id, FName, LName, PhoneNumber, ManagerId, DepartmentId, Salary, HireDate) VALUES (5, 'Jane', 'Doe', NULL, NULL, 2, 800, '2016-07-22') ;

Another common use of HTTP APIs is to delete an existing resource. This should usually be done using DELETE requests. If the deletion was successful, the server should return 200 OK; an appropriate error code if it was not. If our employee Charlie Smith has left the company and we now want to dele...

1.6.5 git clone <url> --recursive Clones the repository and also clones all submodules. If the submodules themselves contain additional submodules, Git will also clone those.

Guice is a Java library. To use it you have to add a JAR file into the classpath of your Java project. Sample classes Below are several classes for a "Hello, world!" example. An interface of a hello "service": public interface HelloWorldService { public void sayHello(); ...

apologies: since I don't know of a channel for discussing/providing feedback on requests for improvement, I'm going to put my question here. Please feel free to point out a better place for this! @DataTx states that this is "completely unclear, incomplete, or has severe formatting problems&quot...

$user = User::find(1); $user->name = 'abc'; $user->save(); You can also update multiple attributes at once using update, which does not require using save afterwards: $user = User::find(1); $user->update(['name' => 'abc', 'location' => 'xyz']); You can also update a model(s)...

Comments are programmer-readable annotations that are ignored at runtime. Their purpose is to make source code easier to understand. Single line comments The # character is used to add single line comments. #!/usr/bin/ruby -w # This is a single line comment. puts "Hello World!" Whe...

Assuming we have a Vue.js instance defined as: var vm = new Vue({ el: '#example', data: { a: true, b: false } }); You can conditionally render any html element by including the v-if directive; the element that contains v-if will only render if the condition eval...

As a root user: sudo nginx -s reload Ubuntu 14.04 example sudo service nginx reload Ubuntu 16.04 example sudo systemctl reload nginx Before reloading, it is a good idea to check config for syntax errors: sudo nginx -t Or sudo service nginx configtest

Const baseString As String = "Foo Bar" Dim containsBar As Boolean 'Find the position of the last "B" Dim posX As Long 'Note the different number and order of the paramters for InStrRev posX = InStrRev(baseString, "X", -1, vbBinaryCompare) 'posX = 0

Const baseString As String = "Foo Bar" Dim leftText As String leftText = Left$(baseString, 3) 'leftText = "Foo"

Used by awk to separate fields output by the print statement. For example: echo "a b c d e f" | awk 'BEGIN {OFS="-"} {print $2, $3}' produces: b-c e-f The default value is , a string consisting of a single space.

Strict-Transport-Security: max-age=31536000; includeSubDomains; preload HSTS is activated only after a successful HTTPS request to the server with a valid certificate. There is still a risk of a first-time user accessing the site, at which point a Man-in-the-Middle attack is possible. To make th...

Strings Array When selecting a value in the select dropdown and providing an array of strings, the selected value will be bound to the select element's value property as a string that we can display using string interpolation. export class MyViewModel { animals = []; favouriteAnimal = nu...

When using show.bind the element remains in the page and is either hidden or visible through the use of display:none or display:block behind the scenes. export class MyViewModel { isVisible = false; } <template> <div show.bind="isVisible"><strong>I can be b...