Tutorial by Examples: t

Service: angular.module('core').factory('print_service', ['$rootScope', '$compile', '$http', '$timeout','$q', function($rootScope, $compile, $http, $timeout,$q) { var printHtml = function (html) { var deferred = $q.defer(); var hiddenFrame = $('<...

To publish a crate on crates.io, you must log in with Cargo (see 'Connecting Cargo to a Crates.io Account'). You can package and publish your crate with the following commands: cargo package cargo publish Any errors in your Cargo.toml file will be highlighted during this process. You should en...

Accounts on crates.io are created by logging in with GitHub; you cannot sign up with any other method. To connect your GitHub account to crates.io, click the 'Login with GitHub' button in the top menu bar and authorise crates.io to access your account. This will then log you in to crates.io, assumi...

Although storing multiple values in a single column violates normalization rules, sometimes one has to deal with badly designed legacy tables. A recursive query can help convert comma-separated values into distinct rows. Create a sample badly designed table and insert some data: create table proje...

String macros do not come with built-in interpolation facilities. However, it is possible to manually implement this functionality. Note that it is not possible to embed without escaping string literals that have the same delimiter as the surrounding string macro; that is, although ""&quot...

Adding a Product to a Shopping Cart The following example demonstrates how to Add a product (or anything) to a Database Table asynchronously, using AJAX, and TypeScript. declare var document; declare var xhr: XMLHttpRequest; window.onLoad = () => { Start(); }; function Start() { ...

To give an alert close functionality, all we need is to add data-dismiss="alert" to our close button. <div class="alert alert-info alert-dismissible" role="alert"> <button type="button" class="close" data-dismiss="alert" aria...

Detailed instructions on getting swt set up or installed.

Detailed instructions on getting encoding set up or installed.

Outer joins return all the rows from one or both tables, plus matching rows. Table People PersonID FirstName 1 Alice 2 Bob 3 Eve Table Scores PersonID Subject Score 1 Math 100 2 Math 54 2 Science 98 Left joining the tables: Select * f...

This simple function will execute the specified Select SQL command and return the result as data set. Public Function ReadFromDatabase(ByVal DBConnectionString As String, ByVal SQL As String) As DataTable Dim dtReturn As New DataTable Try 'Open the connection using the connection...

This example uses the Thread Class, but multithreaded applications can also be made using BackgroundWorker. The AddNumber, SubstractNumber, and DivideNumber functions will be executed by separate threads: Edit: Now the UI thread waits for the child threads to finish and shows the result. Module Mo...

Unlike a SELECT statement, a Stored Procedure returns multiple result sets. The requires different code to be used for gathering the results of a CALL in Perl, PHP, etc. (Need specific code here or elsewhere!)

Using the /p switch with the SET command you can define variables from an Input. This input can be a user Input (keyboard) : echo Enter your name : set /p name= echo Your name is %name% Which can be simplified like this : set /p name=Enter your name : echo Your name is %name% Or you can...

IS NULL / IS NOT NULL -- = NULL does not work like you expect. x <=> y is a "null-safe" comparison. In a LEFT JOIN tests for rows of a for which there is not a corresponding row in b. SELECT ... FROM a LEFT JOIN b ON ... WHERE b.id IS NULL

int fakeMalloc(__local int * addrCounter,int size) { // lock addrCounter // adds size to addrCounter's pointed cell value // unlock // return old value of addrCounter's pointed cell // serial between all threads visiting -> slow ret...

GSON does not support inheritance our of the box. Let's say we have the following class hierarchy: public class BaseClass { int a; public int getInt() { return a; } } public class DerivedClass1 extends BaseClass { int b; @Override public int getIn...

The Android Account Authenticator system can be used to make the client authenticate with a remote server. Three pieces of information are required: A service, triggered by the android.accounts.AccountAuthenticator. Its onBind method should return a subclass of AbstractAccountAuthenticator. An a...

A repository is a place that SBT looks for libraryDependencies. If the build complains about not finding a dependency, it can be lacking the correct repository. Within SBT, the repositories are listed in the resolvers SettingKey: resolvers += "Flyway" at "https://flywaydb.org/repo&qu...

The standard structure for a project built by SBT is: projectName/ build.sbt project/ <SBT sub-build information> src/ main/ scala/ <Scala source files> java/ <Java source files> resources/ ...