Tutorial by Examples: at

/** * Save the results from the saved search as .csv and store in file cabinet * Get the file's internal id when loading the file * Use \n to process each row * Get the internal id and whatever columns that need updating * Create a filtered search and pass the internal id * If the passe...

Here, "table" is meant broadly (covering data.frame, table, Printing to plain text Printing (as seen in the console) might suffice for a plain-text document to be viewed in monospaced font: Note: Before making the example data below, make sure you're in an empty folder you can write to....

Sweave from the utils package allows for formatting code, prose, graphs and tables together in a LaTeX document. Further Resources Knitr and RMarkdown

This converts valid json strings to MySQL JSON type: SELECT CAST('[1,2,3]' as JSON) ; SELECT CAST('{"opening":"Sicilian","variations":["pelikan","dragon","najdorf"]}' as JSON);

JSON_OBJECT creates JSON Objects: SELECT JSON_OBJECT('key1',col1 , 'key2',col2 , 'key3','col3') as myobj; JSON_ARRAY creates JSON Array as well: SELECT JSON_ARRAY(col1,col2,'col3') as myarray; Note: myobj.key3 and myarray[2] are "col3" as fixed string. Also mixed JSON data: S...

Extract path by -> or ->> Operators, while ->> is UNQUOTED value: SELECT myjson_col->>'$[1]' , myjson_col->'$[1]' , myjson_col->>'$[*].label' , myjson_col->>'$[1].*' , myjson_col->>'$[2].*' FROM tablename ; -- visuall: B, "B...

You can view more information about a remote repository by git remote show <remote repository alias> git remote show origin result: remote origin Fetch URL: https://localserver/develop/myrepo.git Push URL: https://localserver/develop/myrepo.git HEAD branch: master Remote branches: ...

Description of the installation process : Debian jessie -- Installation Guide Each architecture has his own installation guide : amd64 i386 armel s390x powerpc armhf mips AArch64 POWER. Download an iso image of the Debian distribution (stable release): Debian installer Use ...

XHTML Relation to HTML XHTML is simply the serialized version of HTML. XHTML was originally intended to clean up HTML markup to better improve standards support. Unfortunately the W3C's work on XHTML 2.0 was not intuitive and detracted from where the industry as a whole was headed with HTML5. XHTML...

HTML5 defines some HTML attributes as boolean; a boolean can only be true or false. The specification simply states that the presence of a boolean attribute implies that the attribute is set to true. In example using a disabled attribute in the following example disables the button input element: &...

Using XHTML you should avoid methods such as document.write and innerHTML as they treat XML as text and do not properly serialize code; an id attribute in HTML is essentially dumped in to the DOM and the id attribute is not serialized which means when trying to reference to it with something such as...

Consider following directory structure to comply with best practices: [ProjectRoot] |---[app] | |---[resources] | routes.php |---[web] | |---[resources] | | |---[css] | | |---[img] | | |---[js] | .htaccess | index.ph...

This example shows a simple global definition of a complexType. The definition is considered global as it is a child of the xs:schema. Globally defined types can be used elsewhere in the schema. This is the most common form for declaring a global xs:complexType, it defines the child elements using ...

In this example we are creating a new xs:complexType (EmployeeType) based on an existing xs:complexType (PersonType). The construction of this is slightly more complicated. Because the base xs:complexType (PersonType) is considered to be complex (more about this below) we add the <xs:complexCon...

This is where things get a little tricky. We are now restricting an existing xs:complexType. Our SolidStateDriveType derives from HardDiskType but removes the spinUpTime attribute and the RotationSpeed element. Notice the approach for dealing with attributes and elements is different. To remove an ...

After installing the SDK, atlas-run-standalone starts a JIRA instance with the latest released version. atlas-run-standalone --product jira The instance is available http://localhost:2990/jira The created instance is for testing only. It provides an other directory structure as production insta...

By convention elementFormDefault is always set to qualified, but lets look at what it actually does. First with elementFormDefault set to qualified. <?xml version="1.0" encoding="utf-8" ?> <!--Created with Liquid Studio 2017 (https://www.liquid-technologies.com)--&g...

The builder pattern is an object creation software design pattern. Unlike the abstract factory pattern and the factory method pattern whose intention is to enable polymorphism, the intention of the builder pattern is to find a solution to the telescoping constructor anti-pattern. The telescopi...

Any declaration (variable, const, function, class, etc.) can be exported from module to be imported in other module. Typescript offer two export types: named and default. Named export // adams.ts export function hello(name: string){ console.log(`Hello ${name}!`); } export const answerToLi...

Generate a random letter between a and z by using the Next() overload for a given range of numbers, then converting the resulting int to a char Random rnd = new Random(); char randomChar = (char)rnd.Next('a','z'); //'a' and 'z' are interpreted as ints for parameters for Next()