Tutorial by Examples: pt

/* creates a database for Alfresco, on SQLServer 2008- 2014 */ use master; GO CREATE DATABASE alfresco; GO /* creates a new LOGIN and associated User use alfresco; GO CREATE LOGIN alfresco WITH PASSWORD = 'alfresco'; GO use alfresco; go CREATE USER alfresco FOR LOGIN alfresco; GO ...

This example is used in specifying options that might not be included in a database of available housing and its attendant amenities. It builds on the previous example, with some differences: Two procedures are no longer necessary for a single combo box, done by combining the code into a single ...

Working Example: https://jsfiddle.net/Twisty/4f5yh3pa/7/ Cancelling and Reverting a sortable is not strongly documented. The helps show how moving an item from one list to another connected list can be conditionally cancelled. by default, this is not animated by sortable, this example includes an a...

This code will prompt you to create the directory with :w, or just do it with :w!: augroup vimrc-auto-mkdir autocmd! autocmd BufWritePre * call s:auto_mkdir(expand('<afile>:p:h'), v:cmdbang) function! s:auto_mkdir(dir, force) if !isdirectory(a:dir) \ && (a:f...

In this example, we will try to find JavaScript data which containing backgroundColor:'#FFF'. Then, we will change value of backgroundColor '#FFF' ⇨ '#ddd'. This code uses getWholeData() and setWholeData() methods to manipulate JavaScript data. Alternatively, html() method can be used to get data of...

The interactive mode The most basic way to use R is the interactive mode. You type commands and immediately get the result from R. Using R as a calculator Start R by typing R at the command prompt of your operating system or by executing RGui on Windows. Below you can see a screenshot of an inter...

Each standard Oracle error is associated with an error number. Its important to anticipate what could go wrong in your code. Here for a connection to another database it can be: -28000 account is locked -28001 password expired -28002 grace period -1017 wrong user / password Here is a way to...

To illustrate this, here is a function that has 3 different "wrong" behaviors parameter is completely stupid: we use a user-defined expression parameter has a typo: we use Oracle standard NO_DATA_FOUND error another, but not handled case Feel free to adapt it to your standards: DE...

In modern Objective C syntax you can get values from NSArray and NSDictionary containers using container subscripting. Old way: NSObject *object1 = [array objectAtIndex:1]; NSObject *object2 = [dictionary objectForKey:@"Value"]; Modern way: NSObject *object1 = array[1]; NSObject *o...

The function takes the argument of the current node index, adjacency list (stored in vector of vectors in this example), and vector of boolean to keep track of which node has been visited. void dfs(int node, vector<vector<int>>* graph, vector<bool>* visited) { // check whethe...

Adapters are used to convert the interface of a given class, known as an Adaptee, into another interface, called the Target. Operations on the Target are called by a Client, and those operations are adapted by the Adapter and passed on to the Adaptee. In Swift, Adapters can often be formed through ...

There are variety of gsp tags available which can be used to create forms, textfield, radio buttons, check boxes, if-else, for each etc. <g:if> <g:if test="${session.role == 'admin'}"> <%-- show administrative functions --%> </g:if> <g:else> <%-...

In the JNDI declaration you may want to encrypt the username and password. You have to implement a custom datasource factory in order to be able to decrypt the credentials. In server.xml replace factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" by factory="cypher.MyCustomDataS...

Interceptors are a good tool for implementing cross-cutting concerns such as logging or authentication. Let's say we have a following service: public interface IService { string CreateOrder(NetworkCredential credentials, Order orderToCreate); string DeleteOrder(NetworkCredential credenti...

For registration like this: var container = new WindsorContainer(); container.Register( Component.For<FirstInterceptor>(), Component.For<SecondInterceptor>(), Component.For<ThirdInterceptor>(), Component.For<IService>() .ImplementedBy<Servi...

Interceptors are registered like regular components in Windsor. Like other components, they can depend on another components. With following service for validating credentials: public interface ICredentialsVerifier { bool IsAuthorizedForService(NetworkCredential credentials); } public cl...

public class BitmapTools { /// <summary> /// Gets the cropped bitmap asynchronously. /// </summary> /// <param name="originalImage">The original image.</param> /// <param name="startPoint">The start ...

<# .SYNOPSIS Reads a CSV file and filters it. .DESCRIPTION The ReadUsersCsv.ps1 script reads a CSV file and filters it on the 'UserName' column. .PARAMETER Path Specifies the path of the CSV input file. .INPUTS None. You cannot pipe objects to ReadUsersCsv.ps1. ...

The DROP TABLE command remove the table definitions and all data, indexes, triggers, constraints and related permissions. Before you drop a table, you should check if there are any object (views, stored procedures, other tables) that reference the table. You cannot drop a table referenced by anoth...

In SQL server we have 2 types of temporary tables: ##GlobalTempTable is a type of temporary table that is sheered between all user's sessions. #LocalTempTable temp tab - it is a type of temporary table that only exists in current scope (only in actual process - you can get id of your current pro...