Tutorial by Examples: p

Multiple ResultSets

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!)

MySQL • Stored routines (procedures and functions)

Setting variables from an input

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

batch-file • Variables in Batch Files

Add a Managed Library Dependency

libraryDependency is the SettingKey that handles 'managed' library dependencies, which are dependencies that are automatically downloaded, matching the supplied versions. To add a single dependency: libraryDependencies += "com.typesafe.slick" %% "slick" % "3.2.0-M1" ...

sbt • Dependencies

Add a Repository

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

sbt • Dependencies

Pin Library to Project Version of Scala

If your project has this: scalaVersion := 2.11 // Replace '2.11' with the version of Scala your project is running on Then you can use %% to automatically get the version of the library compiled against the version of Scala the project is using: libraryDependencies += "com.typesafe.slick&...

sbt • Dependencies

Pin Library to Specific Version of Scala

A library can be 'pinned' to a specific version of Scala using the % operator between the groupId and the artifactId (the first two strings in a library dependency). In this example, we pin the library with the artifactId of slick to Scala version 2.10: libraryDependencies += "com.typesafe.sl...

sbt • Dependencies

Inspect HTML Structure

On a desktop version of Chrome, the contents of the page can be inspected. This shows the document object model (DOM) of the HTML, the Cascading Style Sheet styles (CSS), and much more. Enter inspection by one of many options: Right click on a web page, and select Inspect From the Chrome Menu, ...

google-chrome • Chrome DevTools

Product Collection

$ProductCollection=Mage::getModel('catalog/product')->getCollection(); Selecting the specific Attribute $ProductCollection->addAttributeToSelect(array('name', 'product_url', 'small_image')); Selecting the All Attribute $ProductCollection->addAttributeToSelect('*'); Add Filter on ...

magento • Collections

Why we need compilation, Flow of events compilation and example?

Q. Why we need compilation? Ans. We need compilation for achieving higher level of efficiency of our Angular applications. Take a look at the following example, // ... compile: function (el, scope) { var dirs = this._getElDirectives(el); var dir; var scopeCreated; dirs.forEach(functi...

Angular 2 • Ahead-of-time (AOT) compilation with Angular 2

Declare dependencies for build types

Dependencies can be added for specific Build types: android { ... buildTypes { release { //... } debug { //.... } } } dependencies { debugCompile 'com.android.support:appcompat-v7:24.1.1' releaseCompile ...

android-gradle • Declare Dependencies

Custom Styled Map

<!DOCTYPE html> <html> <head> <title>Styled Maps</title> <meta charset="utf-8"> <style> #map { height: 100%; } </style> </head> <body> <div id="map"></div> <script type="t...

google-maps-api-3 • Google Maps JavaScript API v3 - Advanced

Compiling on Linux

To compile a PHP extension in a typical Linux environment, there are a few pre-requisites: Basic Unix skills (being able to operate "make" and a C compiler) An ANSI C compiler The source code for the PHP extension you want to compile Generally there are two ways to compile a PHP ex...

PHP • Compile PHP Extensions

Producers

A Producer is some monadic action that can yield values for downstream consumption: type Producer b = Proxy X () () b yield :: Monad m => a -> Producer a m () For example: naturals :: Monad m => Producer Int m () naturals = each [1..] -- each is a utility function exported by Pipes ...

Haskell Language • Pipes

Pipes

Pipes can both await and yield. type Pipe a b = Proxy () a () b This Pipe awaits an Int and converts it to a String: intToStr :: Monad m => Pipe Int String m () intToStr = forever $ await >>= (yield . show)

Haskell Language • Pipes

Running Pipes with runEffect

We use runEffect to run our Pipe: main :: IO () main = do runEffect $ naturalsUntil 10 >-> intToStr >-> fancyPrint Note that runEffect requires an Effect, which is a self-contained Proxy with no inputs or outputs: runEffect :: Monad m => Effect m r -> m r type Effect = Pr...

Haskell Language • Pipes

Run script in debug mode

To run script in debug mode you should add -d option in the command line: $perl -d script.pl If t is specified, it indicates to the debugger that threads will be used in the code being debugged: $perl -dt script.pl Additional info at perldocperlrun

Perl Language • Perl script debugging

Connecting Pipes

Use >-> to connect Producers, Consumers and Pipes to compose larger Pipe functions. printNaturals :: MonadIO m => Effect m () printNaturals = naturalsUntil 10 >-> intToStr >-> fancyPrint Producer, Consumer, Pipe, and Effect types are all defined in terms of the general Prox...

Haskell Language • Pipes

The Proxy monad transformer

pipes's core data type is the Proxy monad transformer. Pipe, Producer, Consumer and so on are defined in terms of Proxy. Since Proxy is a monad transformer, definitions of Pipes take the form of monadic scripts which await and yield values, additionally performing effects from the base monad m.

Haskell Language • Pipes

Creating User Control Instance Programmatically

If you want to instantiate an instance of user control inside ASPX code behind page, you need to write user control declaration on Page_Load event as follows: public partial class Default : System.Web.UI.Page { protected void Page_Load(Object sender, EventArgs e) { Control contr...

ASP.NET • ASP.NET - User Controls

Adding Custom Properties for User Control

Like standard ASP.NET built-in server controls, user controls can have properties (attributes) on its definition tag. Suppose you want to add color effect on UserControl.ascx file like this: <uc:UserControl ID="UserControl1" runat="server" Color="blue" /> At t...

ASP.NET • ASP.NET - User Controls