SET @searchTerm= 'Database Programming -Java';
SELECT MATCH (Title) AGAINST (@searchTerm IN BOOLEAN MODE) Score,
ISBN, Author, Title
FROM book
WHERE MATCH (Title) AGAINST (@searchTerm IN BOOLEAN MODE)
ORDER BY MATCH (Title) AGAINST (@searchTerm IN BOOLEAN MODE) DESC;
Giv...
With pip:
pip install pygame
With conda:
conda install -c tlatorre pygame=1.9.2
Direct download from website :
http://www.pygame.org/download.shtml
You can find the suitable installers fro windows and other operating systems.
Projects can also be found at http://www.pygame.org/
$ cut -d, -f1,3 <<<"a,,b,c,d,e"
a,b
is rather obvious, but with space-delimited strings it might be less obvious to some
$ cut -d ' ' -f1,3 <<<"a b c d e"
a b
cut cannot be used to parse arguments as the shell and other programs do.
You can only extract portions of lines, not reorder or repeat fields.
$ cut -d, -f2,1 <<<'John,Smith,USA' ## Just like -f1,2
John,Smith
$ cut -d, -f2,2 <<<'John,Smith,USA' ## Just like -f2
Smith
SWIFT:
Step 1:
In your Info.plist add the following attribute:
View controller-based status bar appearance
and set its value to
NO
as described in the image below:
Step 2:
In your AppDelegate.swift file, in didFinishLaunchingWithOptions method, add this code:
UIApplication.shared.st...
In order to create an use a custome tag,we need to follow couple of steps:
Create a tag file,defining the attributes used by it and any variables which will be used by the tag
a. The attributes need to have a name,their type and and required field with a boolean value
b. The variables will be...
Sometimes it is useful to print a current binding directly from markup. A neat trick which allows that is to use an additional DOM element with a non-existing binding (KO < 3.0), custom binding or a binding that is not relevant such as uniqueName.
Consider this example:
<tbody data-bind=&quo...
In previous versions, setting up provisioning profiles was done manually. You generate distribution profile, download it and then distribute your app. This had to be done for every development machine which was extremely time consuming. However, in most situations nowadays, Xcode 8 will do most of t...
Once it's done, you can find your archive in the Xcode organizer. This is where all your previous versions and archive builds are saved and organized in case you do not delete them. You will immediately notice a large blue button saying "Upload to App Store..." however in 9/10 cases this w...
Once the IPA file is generated, open Xcode, navigate to developer tools and open Application Loader.
If you have multiple accounts in your Xcode, you will be asked to choose. Naturally pick the one you used for code signing in the first step. Pick "Deliver your app" and upload the code....
Structs may be used to implement code in an object oriented manner. A struct is similar to a class, but is missing the functions which normally also form part of a class, we can add these as function pointer member variables. To stay with our coordinates example:
/* coordinates.h */
typedef stru...
//create a new ExcelPackage
using (ExcelPackage excelPackage = new ExcelPackage())
{
//create 2 WorkSheets. One for the source data and one for the Pivot table
ExcelWorksheet worksheetPivot = excelPackage.Workbook.Worksheets.Add("Pivot");
ExcelWorksheet worksheetData = exc...
Typically when loading plugins, make sure to always include the plugin after jQuery.
<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
<script src="some-plugin.min.js"></script>
If you must use more than one version of jQuery, then m...
One to Many
Lets say that each Post may have one or many comments and each comment belongs to just a single Post.
so the comments table will be having post_id. In this case the relationships will be as follows.
Post Model
public function comments()
{
return $this->belongsTo(Post::class...
Note: This only works for the built-in keyboard provided by iOS
SWIFT:
In order for the view of a UIViewController to increase the origin of the frame when it is presented and decrease it when it is hidden, add the following functions to your class:
func keyboardWillShow(notification: NSNotificat...
Using an Atomic Group
Atomic groups have the format (?>...) with a ?> after the open paren.
Consider the following sample text:
ABC
The regex will attempt to match starting at position 0 of the text, which is before the A in ABC.
If a case-insensitive expression (?>a*)abc were used, ...
The break instruction:
Using break we can leave a loop even if the condition for its end is not fulfilled. It can be used to end an infinite loop, or to force it to end before its natural end
The syntax is
break;
Example:
we often use break in switch cases,ie once a case i switch is satisfied...
I'll start with a really short explanation what is and why use Model-View-ViewModel (MVVM) design pattern in your iOS apps.
When iOS first appeared, Apple suggested to use MVC (Model-View-Controller) as a design pattern. They showed it in all of their examples and all first developers were happy us...
