Tutorial by Examples: st

Declare a variable-width string variable

Dim surname As String 'surname can accept strings of variable length surname = "Smith" surname = "Johnson"

VBA • Declaring and assigning strings

Declare and assign a fixed-width string

'Declare and assign a 1-character fixed-width string Dim middleInitial As String * 1 'middleInitial must be 1 character in length middleInitial = "M" 'Declare and assign a 2-character fixed-width string `stateCode`, 'must be 2 characters in length Dim stateCode As String * 2 stateC...

VBA • Declaring and assigning strings

Declare and assign a string array

'Declare, dimension and assign a string array with 3 elements Dim departments(2) As String departments(0) = "Engineering" departments(1) = "Finance" departments(2) = "Marketing" 'Declare an undimensioned string array and then dynamically assign with 'the results...

VBA • Declaring and assigning strings

Assign specific characters within a string using Mid statement

VBA offers a Mid function for returning substrings within a string, but it also offers the Mid Statement which can be used to assign substrings or individual characters withing a string. The Mid function will typically appear on the right-hand-side of an assignment statement or in a condition, but ...

VBA • Declaring and assigning strings

Installation or Setup

Detailed instructions on getting jboss set up or installed.

jboss • Getting started with jboss

Custom Snack Bar

Function to customize snackbar public static Snackbar makeText(Context context, String message, int duration) { Activity activity = (Activity) context; View layout; Snackbar snackbar = Snackbar .make(activity.findViewById(android.R.id.content), message, d...

Android • Snackbar

Prepared statements in MySQLi

Please read Preventing SQL injection with Parametrized Queries for a complete discussion of why prepared statements help you secure your SQL statements from SQL Injection attacks The $conn variable here is a MySQLi object. See MySQLi connect example for more details. For both examples, we assume t...

PHP • PHP MySQLi

Getting the Constants of an Enumeration

Giving this enumeration as Example: enum Compass { NORTH(0), EAST(90), SOUTH(180), WEST(270); private int degree; Compass(int deg){ degree = deg; } public int getDegree(){ return degree; } } In Java an enum class is like any other c...

Java Language • Reflection API

Installation

Direct Download - download link CDN - get here Bower - bower install bootstrap [read] NPM - npm install bootstrap [read] Composer - composer require twbs/bootstrap [read] Customize - I you have your own config, you can customize here. Sass - For Sass related projects you may get it here. ...

twitter-bootstrap-3 • Getting started with twitter-bootstrap-3

Change primary key and timestamps

By default, Eloquent models expect for the primary key to be named 'id'. If that is not your case, you can change the name of your primary key by specifying the $primaryKey property. class Citizen extends Model { protected $primaryKey = 'socialSecurityNo'; // ... } Now, any Eloqu...

Laravel • Eloquent

Update an existing model

$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)...

Laravel • Eloquent: Model

A View Bound to Existing HTML

Assuming this HTML in the page: <body> <div id="myPage"> </div> </body> A view can be bound to it with: var MyPageView = Backbone.View.extend( { "el": "#myPage", "template": _.template( "<p>This is m...

backbone.js • View

Closing Streams

Most streams must be closed when you are done with them, otherwise you could introduce a memory leak or leave a file open. It is important that streams are closed even if an exception is thrown. Java SE 7 try(FileWriter fw = new FileWriter("outfilename"); BufferedWriter bw = new Buf...

Java Language • InputStreams and OutputStreams

Gem installation from github/filesystem

You can install a gem from github or filesystem. If the gem has been checked out from git or somehow already on the file system, you could install it using gem install --local path_to_gem/filename.gem Installing gem from github. Download the sources from github mkdir newgem cd newgem git clon...

Ruby Language • Gem Usage

Use CStr to convert a numeric type to a string

Const zipCode As Long = 10012 Dim zipCodeText As String 'Convert the zipCode number to a string of digit characters zipCodeText = CStr(zipCode) 'zipCodeText = "10012"

VBA • Converting other types to strings

Use Format to convert and format a numeric type as a string

Const zipCode As long = 10012 Dim zeroPaddedNumber As String zeroPaddedZipCode = Format(zipCode, "00000000") 'zeroPaddedNumber = "00010012"

VBA • Converting other types to strings

Use StrConv to convert a byte-array of single-byte characters to a string

'Declare an array of bytes, assign single-byte character codes, and convert to a string Dim singleByteChars(4) As Byte singleByteChars(0) = 72 singleByteChars(1) = 101 singleByteChars(2) = 108 singleByteChars(3) = 108 singleByteChars(4) = 111 Dim stringFromSingleByteChars As String stringFro...

VBA • Converting other types to strings

Implicitly convert a byte array of multi-byte-characters to a string

'Declare an array of bytes, assign multi-byte character codes, and convert to a string Dim multiByteChars(9) As Byte multiByteChars(0) = 87 multiByteChars(1) = 0 multiByteChars(2) = 111 multiByteChars(3) = 0 multiByteChars(4) = 114 multiByteChars(5) = 0 multiByteChars(6) = 108 multiByteChar...

VBA • Converting other types to strings

Restart NGINX

As a root user: nginx -s restart Ubuntu example sudo service nginx restart

nginx • Getting started with nginx

Using LocalBroadcastManager

LocalBroadcastManager is used to send Broadcast Intents within an application, without exposing them to unwanted listeners. Using LocalBroadcastManager is more efficient and safer than using context.sendBroadcast() directly, because you don't need to worry about any broadcasts faked by other Applic...

Android • BroadcastReceiver