Programs & Examples On #Bonecp

BoneCP is a fast, free, open-source, Java database connection pool (JDBC Pool) library. It should now be considered deprecated in favour of HikariCP.

java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

I did below modifications and I am able to start the Hive Shell without any errors:

1. ~/.bashrc

Inside bashrc file add the below environment variables at End Of File : sudo gedit ~/.bashrc

#Java Home directory configuration
export JAVA_HOME="/usr/lib/jvm/java-9-oracle"
export PATH="$PATH:$JAVA_HOME/bin"

# Hadoop home directory configuration
export HADOOP_HOME=/usr/local/hadoop
export PATH=$PATH:$HADOOP_HOME/bin
export PATH=$PATH:$HADOOP_HOME/sbin

export HIVE_HOME=/usr/lib/hive
export PATH=$PATH:$HIVE_HOME/bin

2. hive-site.xml

You have to create this file(hive-site.xml) in conf directory of Hive and add the below details

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true</value>
</property>


<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>root</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>root</value>
</property>

<property>
  <name>datanucleus.autoCreateSchema</name>
  <value>true</value>
</property>

<property>
  <name>datanucleus.fixedDatastore</name>
  <value>true</value>
</property>

<property>
 <name>datanucleus.autoCreateTables</name>
 <value>True</value>
 </property>

</configuration>

3. You also need to put the jar file(mysql-connector-java-5.1.28.jar) in the lib directory of Hive

4. Below installations required on your Ubuntu to Start the Hive Shell:

  1. MySql
  2. Hadoop
  3. Hive
  4. Java

5. Execution Part:

  1. Start all services of Hadoop: start-all.sh

  2. Enter the jps command to check whether all Hadoop services are up and running: jps

  3. Enter the hive command to enter into hive shell: hive

Java NoSuchAlgorithmException - SunJSSE, sun.security.ssl.SSLContextImpl$DefaultSSLContext

I've had a similar issue with this error. In my case, I was entering the incorrect password for the Keystore.

I changed the password for the Keystore to match what I was entering (I didn't want to change the password I was entering), but it still gave the same error.

keytool -storepasswd -keystore keystore.jks

Problem was that I also needed to change the Key's password within the Keystore.

When I initially created the Keystore, the Key was created with the same password as the Keystore (I accepted this default option). So I had to also change the Key's password as follows:

keytool -keypasswd  -alias my.alias -keystore keystore.jks

How to convert milliseconds to seconds with precision

Surely you just need:

double seconds = milliseconds / 1000.0;

There's no need to manually do the two parts separately - you just need floating point arithmetic, which the use of 1000.0 (as a double literal) forces. (I'm assuming your milliseconds value is an integer of some form.)

Note that as usual with double, you may not be able to represent the result exactly. Consider using BigDecimal if you want to represent 100ms as 0.1 seconds exactly. (Given that it's a physical quantity, and the 100ms wouldn't be exact in the first place, a double is probably appropriate, but...)

Is there an equivalent to e.PageX position for 'touchstart' event as there is for click event?

I tried some of the other answers here, but originalEvent was also undefined. Upon inspection, found a TouchList classed property (as suggested by another poster) and managed to get to pageX/Y this way:

var x = e.changedTouches[0].pageX;

T-SQL Format integer to 2-digit string

Convert the value to a string, add a zero in front of it (so that it's two or tree characters), and get the last to characters:

right('0'+convert(varchar(2),Sort_Export_CSV),2)

How do I get a UTC Timestamp in JavaScript?

I think this what you are expecting...

var currTimestamp = Date.now(), //1482905176396
    utcDateString = (new Date(currTimestamp)).toUTCString(); //"Wed, 28 Dec 2016 06:06:50 GMT"

Now,

new Date(utcDateString).getTime(); //This will give you UTC Timestamp in JavaScript

Using C# to check if string contains a string in string array

You can also do the same thing as Anton Gogolev suggests to check if any item in stringArray1 matches any item in stringArray2:

if(stringArray1.Any(stringArray2.Contains))

And likewise all items in stringArray1 match all items in stringArray2:

if(stringArray1.All(stringArray2.Contains))

Posting form to different MVC post action depending on the clicked submit button

You can choose the url where the form must be posted (and thus, the invoked action) in different ways, depending on the browser support:

In this way you don't need to do anything special on the server side.

Of course, you can use Url extensions methods in your Razor to specify the form action.

For browsers supporting HMTL5: simply define your submit buttons like this:

<input type='submit' value='...' formaction='@Url.Action(...)' />

For older browsers I recommend using an unobtrusive script like this (include it in your "master layout"):

$(document).on('click', '[type="submit"][data-form-action]', function (event) {
  var $this = $(this);
  var formAction = $this.attr('data-form-action');
  $this.closest('form').attr('action', formAction);
});

NOTE: This script will handle the click for any element in the page that has type=submit and data-form-action attributes. When this happens, it takes the value of data-form-action attribute and set the containing form's action to the value of this attribute. As it's a delegated event, it will work even for HTML loaded using AJAX, without taking extra steps.

Then you simply have to add a data-form-action attribute with the desired action URL to your button, like this:

<input type='submit' data-form-action='@Url.Action(...)' value='...'/>

Note that clicking the button changes the form's action, and, right after that, the browser posts the form to the desired action.

As you can see, this requires no custom routing, you can use the standard Url extension methods, and you have nothing special to do in modern browsers.

How create a new deep copy (clone) of a List<T>?

If the Array class meets your needs, you could also use the List.ToArray method, which copies elements to a new array.

Reference: http://msdn.microsoft.com/en-us/library/x303t819(v=vs.110).aspx

Should URL be case sensitive?

Old question but I stumbled here so why not take a shot at it since the question is seeking various perspective and not a definitive answer.

w3c may have its recommendations - which I care a lot - but want to rethink since the question is here.

Why does w3c consider domain names be case insensitive and leaves anything afterwards case insensitive ?

I am thinking that the rationale is that the domain part of the URL is hand typed by a user. Everything after being hyper text will be resolved by the machine (browser and server in the back).

Machines can handle case insensitivity better than humans (not the technical kind:)).

But the question is just because the machines CAN handle that should it be done that way ?

I mean what are the benefits of naming and accessing a resource sitting at hereIsTheResource vs hereistheresource ?

The lateral is very unreadable than the camel case one which is more readable. Readable to Humans (including the technical kind.)

So here are my points:-

Resource Path falls in the somewhere in the middle of programming structure and being close to an end user behind the browser sometimes.

Your URL (excluding the domain name) should be case insensitive if your users are expected to touch it or type it etc. You should develop your application to AVOID having users type the path as much as possible.

Your URL (excluding the domain name) should be case sensitive if your users would never type it by hand.

Conclusion

Path should be case sensitive. My points are weighing towards the case sensitive paths.

What is the function of FormulaR1C1?

I find the most valuable feature of .FormulaR1C1 is sheer speed. Versus eg a couple of very large loops filling some data into a sheet, If you can convert what you are doing into a .FormulaR1C1 form. Then a single operation eg myrange.FormulaR1C1 = "my particular formuala" is blindingly fast (can be a thousand times faster). No looping and counting - just fill the range at high speed.

Embed youtube videos that play in fullscreen automatically

This was pretty well answered over here: How to make a YouTube embedded video a full page width one?

If you add '?rel=0&autoplay=1' to the end of the url in the embed code (like this)

<iframe id="video" src="//www.youtube.com/embed/5iiPC-VGFLU?rel=0&autoplay=1" frameborder="0" allowfullscreen></iframe>

of the video it should play on load. Here's a demo over at jsfiddle.

Connect to SQL Server database from Node.js

//start the program
var express = require('express');
var app = express();

app.get('/', function (req, res) {

    var sql = require("mssql");

    // config for your database
    var config = {
        user: 'datapullman',
        password: 'system',
        server: 'localhost', 
        database: 'chat6' 
    };

    // connect to your database
    sql.connect(config, function (err) {

        if (err) console.log(err);

        // create Request object
        var request = new sql.Request();

        // query to the database and get the records

        request.query("select * From emp", function (err, recordset) {            
            if  (err) console.log(err)

            // send records as a response
            res.send(recordset);

        });
    });
});

var server = app.listen(5000, function () {
    console.log('Server is running..');
});

//create a table as emp in a database (i have created as chat6)

// programs ends here

//save it as app.js and run as node app.js //open in you browser as localhost:5000

how to instanceof List<MyType>?

    if (list instanceof List && ((List) list).stream()
                                             .noneMatch((o -> !(o instanceof MyType)))) {}

Python Pandas : group by in group by and average?

I would simply do this, which literally follows what your desired logic was:

df.groupby(['org']).mean().groupby(['cluster']).mean()

C# how to change data in DataTable?

You should probably set the property dt.Columns["columnName"].ReadOnly = false; before.

OSError: [WinError 193] %1 is not a valid Win32 application

All above solution are logical and I think covers the root cause, but for me, none of the above worked. Hence putting it here as may be helpful for others.

My environment was messed up. As you can see from the traceback, there are two python environments involved here:

  1. C:\Users\example\AppData\Roaming\Python\Python37
  2. C:\Users\example\Anaconda3

I cleaned up the path and just deleted all the files from C:\Users\example\AppData\Roaming\Python\Python37.

Then it worked like the charm.

I hope others may find this helpful.

This link helped me to found the solution.

js 'types' can only be used in a .ts file - Visual Studio Code using @ts-check

Use "javascript.validate.enable": false in your VS Code settings, It doesn't disable ESLINT. I use both ESLINT & Flow. Simply follow the instructions Flow For Vs Code Setup

Adding this line in settings.json. Helps "javascript.validate.enable": false

Unable to verify leaf signature

You can also try by setting strictSSL to false, like this:

{  
   url: "https://...",
   method: "POST",
   headers: {
        "Content-Type": "application/json"},
   strictSSL: false
}

How to enable cURL in PHP / XAMPP

Since XAMPP went through some modifications, the file is now at xampp/php/php.ini.

Use jquery to set value of div tag

use as below:

<div id="getSessionStorage"></div>

For this to append anything use below code for reference:

$(document).ready(function () {
        var storageVal = sessionStorage.getItem("UserName");
        alert(storageVal);
        $("#getSessionStorage").append(storageVal);
     });

This will appear as below in html (assuming storageVal="Rishabh")

<div id="getSessionStorage">Rishabh</div>

recursively use scp but excluding some folders

You can use extended globbing as in the example below:

#Enable extglob
shopt -s extglob

cp -rv !(./excludeme/*.jpg) /var/destination

jQuery selectors on custom data attributes using HTML5

Pure/vanilla JS solution (working example here)

// All elements with data-company="Microsoft" below "Companies"
let a = document.querySelectorAll("[data-group='Companies'] [data-company='Microsoft']"); 

// All elements with data-company!="Microsoft" below "Companies"
let b = document.querySelectorAll("[data-group='Companies'] :not([data-company='Microsoft'])"); 

In querySelectorAll you must use valid CSS selector (currently Level3)

SPEED TEST (2018.06.29) for jQuery and Pure JS: test was performed on MacOs High Sierra 10.13.3 on Chrome 67.0.3396.99 (64-bit), Safari 11.0.3 (13604.5.6), Firefox 59.0.2 (64-bit). Below screenshot shows results for fastest browser (Safari):

enter image description here

PureJS was faster than jQuery about 12% on Chrome, 21% on Firefox and 25% on Safari. Interestingly speed for Chrome was 18.9M operation per second, Firefox 26M, Safari 160.9M (!).

So winner is PureJS and fastest browser is Safari (more than 8x faster than Chrome!)

Here you can perform test on your machine: https://jsperf.com/js-selectors-x

How do I implement Toastr JS?

Add CDN Files of toastr.css and toastr.js

<link href="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/2.0.1/css/toastr.css" rel="stylesheet"/>
<script src="https://cdnjs.cloudflare.com/ajax/libs/toastr.js/2.0.1/js/toastr.js"></script>

function toasterOptions() {
    toastr.options = {
        "closeButton": false,
        "debug": false,
        "newestOnTop": false,
        "progressBar": true,
        "positionClass": "toast-top-center",
        "preventDuplicates": true,
        "onclick": null,
        "showDuration": "100",
        "hideDuration": "1000",
        "timeOut": "5000",
        "extendedTimeOut": "1000",
        "showEasing": "swing",
        "hideEasing": "linear",
        "showMethod": "show",
        "hideMethod": "hide"
    };
};


toasterOptions();
toastr.error("Error Message from toastr");

Grep for beginning and end of line?

It should be noted that not only will the caret (^) behave differently within the brackets, it will have the opposite result of placing it outside of the brackets. Placing the caret where you have it will search for all strings NOT beginning with the content you placed within the brackets. You also would want to place a period before the asterisk in between your brackets as with grep, it also acts as a "wildcard".

grep ^[.rwx].*[0-9]$

This should work for you, I noticed that some posters used a character class in their expressions which is an effective method as well, but you were not using any in your original expression so I am trying to get one as close to yours as possible explaining every minor change along the way so that it is better understood. How can we learn otherwise?

Remove background drawable programmatically in Android

Try this code:

imgView.setImageResource(android.R.color.transparent); 

also this one works:

imgView.setImageResource(0); 

but be careful this one doesn't work:

imgView.setImageResource(null); 

Mysql select distinct

You can use group by instead of distinct. Because when you use distinct, you'll get struggle to select all values from table. Unlike when you use group by, you can get distinct values and also all fields in table.

Java current machine name and logged in user?

To get the currently logged in user:

System.getProperty("user.name");

To get the host name of the machine:

InetAddress.getLocalHost().getHostName();

To answer the last part of your question, the Java API says that getHostName() will return

the host name for this IP address, or if the operation is not allowed by the security check, the textual representation of the IP address.

How do you print in a Go test using the "testing" package?

The structs testing.T and testing.B both have a .Log and .Logf method that sound to be what you are looking for. .Log and .Logf are similar to fmt.Print and fmt.Printf respectively.

See more details here: http://golang.org/pkg/testing/#pkg-index

fmt.X print statements do work inside tests, but you will find their output is probably not on screen where you expect to find it and, hence, why you should use the logging methods in testing.

If, as in your case, you want to see the logs for tests that are not failing, you have to provide go test the -v flag (v for verbosity). More details on testing flags can be found here: https://golang.org/cmd/go/#hdr-Testing_flags

How to submit an HTML form on loading the page?

You can do it by using simple one line JavaScript code and also be careful that if JavaScript is turned off it will not work. The below code will do it's job if JavaScript is turned off.

Turn off JavaScript and run the code on you own file to know it's full function.(If you turn off JavaScript here, the below Code Snippet will not work)

_x000D_
_x000D_
.noscript-error {_x000D_
  color: red;_x000D_
}
_x000D_
<body onload="document.getElementById('payment-form').submit();">_x000D_
_x000D_
  <div align="center">_x000D_
    <h1>_x000D_
      Please Waite... You Will be Redirected Shortly<br/>_x000D_
      Don't Refresh or Press Back _x000D_
    </h1>_x000D_
  </div>_x000D_
_x000D_
  <form method='post' action='acction.php' id='payment-form'>_x000D_
    <input type='hidden' name='field-name' value='field-value'>_x000D_
     <input type='hidden' name='field-name2' value='field-value2'>_x000D_
    <noscript>_x000D_
      <div align="center" class="noscript-error">Sorry, your browser does not support JavaScript!._x000D_
        <br>Kindly submit it manually_x000D_
        <input type='submit' value='Submit Now' />_x000D_
      </div>_x000D_
    </noscript>_x000D_
  </form>_x000D_
_x000D_
</body>
_x000D_
_x000D_
_x000D_

Rounding to two decimal places in Python 2.7?

You can use str.format(), too:

>>> print "financial return of outcome 1 = {:.2f}".format(1.23456)
financial return of outcome 1 = 1.23

Converting Epoch time into the datetime

This is what you need

In [1]: time.time()
Out[1]: 1347517739.44904

In [2]: time.strftime("%Y-%m-%d %H:%M:%S", time.gmtime(time.time()))
Out[2]: '2012-09-13 06:31:43'

Please input a float instead of an int and that other TypeError should go away.

mend = time.gmtime(float(getbbb_class.end_time)).tm_hour

<strong> vs. font-weight:bold & <em> vs. font-style:italic

The <em> element - from W3C (HTML5 reference)

YES! There is a clear difference.

The <em> element represents stress emphasis of its contents. The level of emphasis that a particular piece of content has is given by its number of ancestor <em> elements.

<strong>  =  important content
<em>      =  stress emphasis of its contents

The placement of emphasis changes the meaning of the sentence. The element thus forms an integral part of the content. The precise way in which emphasis is used in this way depends on the language.

Note!

  1. The <em> element also isnt intended to convey importance; for that purpose, the <strong> element is more appropriate.

  2. The <em> element isn't a generic "italics" element. Sometimes, text is intended to stand out from the rest of the paragraph, as if it was in a different mood or voice. For this, the i element is more appropriate.

Reference (examples): See W3C Reference

Skip Git commit hooks

From man githooks:

pre-commit
This hook is invoked by git commit, and can be bypassed with --no-verify option. It takes no parameter, and is invoked before obtaining the proposed commit log message and making a commit. Exiting with non-zero status from this script causes the git commit to abort.

Get output parameter value in ADO.NET

Create the SqlParamObject which would give you control to access methods on the parameters

:

SqlParameter param = new SqlParameter();

SET the Name for your paramter (it should b same as you would have declared a variable to hold the value in your DataBase)

: param.ParameterName = "@yourParamterName";

Clear the value holder to hold you output data

: param.Value = 0;

Set the Direction of your Choice (In your case it should be Output)

: param.Direction = System.Data.ParameterDirection.Output;

What is Bootstrap?

Bootstrap is Open source HTML Framework. which compatible at almost every Browser. Basically Large Screen Browser width is >992px and extra Large 1200px. so by using Bootstrap defined classes we can adjust screen resolution for displaying contents at every screen from small mobiles to Larger Screen. I tried to explain very short. for Example :

<div class="col-sm-3">....</div>
<div class="col-sm-9">....</div>

- java.lang.NullPointerException - setText on null object reference

The problem is the tv.setText(text). The variable tv is probably null and you call the setText method on that null, which you can't. My guess that the problem is on the findViewById method, but it's not here, so I can't tell more, without the code.

Terminating a Java Program

So return; does not really terminate your java program, it only terminates your java function (void). Because in your case the function is the main function of your application, return; will also terminate the application. But the return; in your example is useless, because the function will terminate directly after this return anyway...

The System.exit() will completly terminate your program and it will close any open window.

Linq filter List<string> where it contains a string value from another List<string>

you can do that

var filteredFileList = fileList.Where(fl => filterList.Contains(fl.ToString()));

Trigger insert old values- values that was updated

In SQL Server 2008 you can use Change Data Capture for this. Details of how to set it up on a table are here http://msdn.microsoft.com/en-us/library/cc627369.aspx

Spark RDD to DataFrame python

I liked Arun's answer better but there is a tiny problem and I could not comment or edit the answer. sparkContext does not have createDeataFrame, sqlContext does (as Thiago mentioned). So:

from pyspark.sql import SQLContext

# assuming the spark environemnt is set and sc is spark.sparkContext 
sqlContext = SQLContext(sc)
schemaPeople = sqlContext.createDataFrame(RDDName)
schemaPeople.createOrReplaceTempView("RDDName")

How do you install and run Mocha, the Node.js testing module? Getting "mocha: command not found" after install

since npm 5.2.0, there's a new command "npx" included with npm that makes this much simpler, if you run:

npx mocha <args>

Note: the optional args are forwarded to the command being executed (mocha in this case)

this will automatically pick the executable "mocha" command from your locally installed mocha (always add it as a dev dependency to ensure the correct one is always used by you and everyone else).

Be careful though that if you didn't install mocha, this command will automatically fetch and use latest version, which is great for some tools (like scaffolders for example), but might not be the most recommendable for certain dependencies where you might want to pin to a specific version.

You can read more on npx here


Now, if instead of invoking mocha directly, you want to define a custom npm script, an alias that might invoke other npm binaries...

you don't want your library tests to fail depending on the machine setup (mocha as global, global mocha version, etc), the way to use the local mocha that works cross-platform is:

node node_modules/.bin/mocha

npm puts aliases to all the binaries in your dependencies on that special folder. Finally, npm will add node_modules/.bin to the PATH automatically when running an npm script, so in your package.json you can do just:

"scripts": {
  "test": "mocha"
}

and invoke it with

npm test

HTML5 pattern for formatting input box to take date mm/dd/yyyy?

I use this website and this pattern do leap year validation as well.

<input type="text" pattern="(?:19|20)[0-9]{2}-(?:(?:0[1-9]|1[0-2])-(?:0[1-9]|1[0-9]|2[0-9])|(?:(?!02)(?:0[1-9]|1[0-2])-(?:30))|(?:(?:0[13578]|1[02])-31))" required />

How to set HTTP headers (for cache-control)?

The page at http://www.askapache.com/htaccess/apache-speed-cache-control.html suggests using something like this:

Add Cache-Control Headers

This goes in your root .htaccess file but if you have access to httpd.conf that is better.

This code uses the FilesMatch directive and the Header directive to add Cache-Control Headers to certain files.

# 480 weeks
<FilesMatch "\.(ico|pdf|flv|jpg|jpeg|png|gif|js|css|swf)$">
Header set Cache-Control "max-age=290304000, public"
</FilesMatch>

Add Class to Object on Page Load

This should work:

window.onload = function() {
  document.getElementById('about').className = 'expand';
};

Or if you're using jQuery:

$(function() {
  $('#about').addClass('expand');
});

Why does IE9 switch to compatibility mode on my website?

As an aside on more modern websites, if you are using conditional statements on your html tag as per boilerplate, this will for some reason cause ie9 to default to compatibility mode. The fix here is to move your conditional statements off the html tag and add them to the body tag, in other words out of the head section. That way you can still use those classes in your style sheet to target older browsers.

Make code in LaTeX look *nice*

For simple document, I sometimes use verbatim, but listing is nice for big chunk of code.

Regex to check whether a string contains only numbers

As you said, you want hash to contain only numbers.

var reg = new RegExp('^[0-9]+$');

or

var reg = new RegExp('^\\d+$');

\d and [0-9] both mean the same thing. The + used means that search for one or more occurring of [0-9].

Find object by its property in array of objects with AngularJS way

How about plain JavaScript? More about Array.prototype.filter().

_x000D_
_x000D_
var myArray = [{'id': '73', 'name': 'john'}, {'id': '45', 'name': 'Jass'}]_x000D_
_x000D_
var item73 = myArray.filter(function(item) {_x000D_
  return item.id === '73';_x000D_
})[0];_x000D_
_x000D_
// even nicer with ES6 arrow functions:_x000D_
// var item73 = myArray.filter(i => i.id === '73')[0];_x000D_
_x000D_
console.log(item73); // {"id": "73", "name": "john"}
_x000D_
_x000D_
_x000D_

php timeout - set_time_limit(0); - don't work

I usually use set_time_limit(30) within the main loop (so each loop iteration is limited to 30 seconds rather than the whole script).

I do this in multiple database update scripts, which routinely take several minutes to complete but less than a second for each iteration - keeping the 30 second limit means the script won't get stuck in an infinite loop if I am stupid enough to create one.

I must admit that my choice of 30 seconds for the limit is somewhat arbitrary - my scripts could actually get away with 2 seconds instead, but I feel more comfortable with 30 seconds given the actual application - of course you could use whatever value you feel is suitable.

Hope this helps!

Update one MySQL table with values from another

It depends what is a use of those tables, but you might consider putting trigger on original table on insert and update. When insert or update is done, update the second table based on only one item from the original table. It will be quicker.

Java parsing XML document gives "Content not allowed in prolog." error

Please check the xml file whether it has any junk character like this ?.If exists,please use the following syntax to remove that.

String XString = writer.toString();
XString = XString.replaceAll("[^\\x20-\\x7e]", "");

Java Refuses to Start - Could not reserve enough space for object heap

Given that none of the other suggestions have worked (including many things I'd have suggested myself), to help troubleshoot further, could you try running:

sysctl -a

On both the SuSE and RedHat machines to see if there are any differences? I'm guessing the default configurations are different between these two distributions that's causing this.

Remove git mapping in Visual Studio 2015

The above answer did not work for me. The registry entries would just be automatically re-added when I opened the solution in Visual Studio. I found the resolution in one of the links in Matthews answer though so credit still goes to him for the correct answer.

Remove Git binding from Visual Studio 2013 solution?

Remove the hidden .git folder in your solutionfolder.

I also removed the .gitattributes and .gitignore files just to keep my folder clean.

Use cell's color as condition in if statement (function)

Although this does not directly address your question, you can actually sort your data by cell colour in Excel (which then makes it pretty easy to label all records with a particular colour in the same way and, hence, condition upon this label).

In Excel 2010, you can do this by going to Data -> Sort -> Sort On "Cell Colour".

How to insert current_timestamp into Postgres via python

from datetime import datetime as dt

then use this in your code:

cur.execute('INSERT INTO my_table (dt_col) VALUES (%s)', (dt.now(),))

Set default time in bootstrap-datetimepicker

This Works for me. I have to use specially date format like this 'YY-MM-dd hh:mm' or 'YYYY-MM-dd hh:mm'

$('#datetimepicker1').datetimepicker({
            format: 'YYYY-MM-dd hh:mm',
            defaultDate: new Date()
        });

ProgressDialog is deprecated.What is the alternate one to use?

You can use SpotDialog by using the library wasabeef you can find the complete tutorial from the following link:

SpotsDialog Example in Android

REST API error return good practices

As others have pointed, having a response entity in an error code is perfectly allowable.

Do remember that 5xx errors are server-side, aka the client cannot change anything to its request to make the request pass. If the client's quota is exceeded, that's definitly not a server error, so 5xx should be avoided.

What Are Some Good .NET Profilers?

I've been working with JetBrains dotTrace for WinForms and Console Apps (not tested on ASP.net yet), and it works quite well:

They recently also added a "Personal License" that is significantly cheaper than the corporate one. Still, if anyone else knows some cheaper or even free ones, I'd like to hear as well :-)

Wait on the Database Engine recovery handle failed. Check the SQL server error log for potential causes

Simple Steps

  1. 1 Open SQL Server Configuration Manager
  2. Under SQL Server Services Select Your Server
  3. Right Click and Select Properties
  4. Log on Tab Change Built-in-account tick
  5. in the drop down list select Network Service
  6. Apply and start The service

Assigning a function to a variable

lambda should be useful for this case. For example,

  1. create function y=x+1 y=lambda x:x+1

  2. call the function y(1) then return 2.

Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:2.3.2:compile (default-compile)

I had this problem once, and this is how i resolved it:

  • Step-1 Clean your
    .m2/repository

  • Step-2 execute the maven command(for example mvn clean verify) from the terminal at the current project location(where your project's pom.xml file exist) instead of running maven from eclipse.
  • vim line numbers - how to have them on by default?

    Add set number to your .vimrc file in your home directory.
    If the .vimrc file is not in your home directory create one with vim .vimrc and add the commands you want at open.

    Here's a site that explains the vimrc and how to use it.

    Create mysql table directly from CSV file using the CSV Storage engine?

    In addition to the other solutions mentioned Mac users may want to note that SQL Pro has a CSV import option which works fairly well and is flexible - you can change column names, and field types on import. Choose new table otherwise the initial dialogue can appear somewhat disheartening.

    Sequel Pro - database management application for working with MySQL databases.

    The target ... overrides the `OTHER_LDFLAGS` build setting defined in `Pods/Pods.xcconfig

    If Xcode complains when linking, e.g. Library not found for -lPods, it doesn't detect the implicit dependencies:

    Go to Product > Edit Scheme Click on Build Add the Pods static library Clean and build again

    Token based authentication in Web API without any user interface

    ASP.Net Web API has Authorization Server build-in already. You can see it inside Startup.cs when you create a new ASP.Net Web Application with Web API template.

    OAuthOptions = new OAuthAuthorizationServerOptions
    {
        TokenEndpointPath = new PathString("/Token"),
        Provider = new ApplicationOAuthProvider(PublicClientId),
        AuthorizeEndpointPath = new PathString("/api/Account/ExternalLogin"),
        AccessTokenExpireTimeSpan = TimeSpan.FromDays(14),
        // In production mode set AllowInsecureHttp = false
        AllowInsecureHttp = true
    };
    

    All you have to do is to post URL encoded username and password inside query string.

    /Token/userName=johndoe%40example.com&password=1234&grant_type=password
    

    If you want to know more detail, you can watch User Registration and Login - Angular Front to Back with Web API by Deborah Kurata.

    How to add facebook share button on my website?

    For Facebook share with an image without an API and using a # to deep link into a sub page, the trick was to share the image as picture=

    The variable mainUrl would be http://yoururl.com/

    var d1 = $('.targ .t1').text();
    var d2 = $('.targ .t2').text();
    var d3 = $('.targ .t3').text();
    var d4 = $('.targ .t4').text();
    var descript_ = d1 + ' ' + d2 + ' ' + d3 + ' ' + d4;
    var descript = encodeURIComponent(descript_);
    
    var imgUrl_ = 'path/to/mypic_'+id+'.jpg';
    var imgUrl = mainUrl + encodeURIComponent(imgUrl_);
    
    var shareLink = mainUrl + encodeURIComponent('mypage.html#' + id);
    
    var fbShareLink = shareLink + '&picture=' + imgUrl + '&description=' + descript;
    var twShareLink = 'text=' + descript + '&url=' + shareLink;
    
    // facebook
    $(".my-btn .facebook").off("tap click").on("tap click",function(){
      var fbpopup = window.open("https://www.facebook.com/sharer/sharer.php?u=" + fbShareLink, "pop", "width=600, height=400, scrollbars=no");
      return false;
    });
    
    // twitter
    $(".my-btn .twitter").off("tap click").on("tap click",function(){
      var twpopup = window.open("http://twitter.com/intent/tweet?" + twShareLink , "pop", "width=600, height=400, scrollbars=no");
      return false;
    });
    

    How to remove underline from a link in HTML?

    <style="text-decoration: none">
    

    The above code will be enough.Just paste this into the link you want to remove underline from.

    vertical-align image in div

    If you have a fixed height in your container, you can set line-height to be the same as height, and it will center vertically. Then just add text-align to center horizontally.

    Here's an example: http://jsfiddle.net/Cthulhu/QHEnL/1/

    EDIT

    Your code should look like this:

    .img_thumb {
        float: left;
        height: 120px;
        margin-bottom: 5px;
        margin-left: 9px;
        position: relative;
        width: 147px;
        background-color: rgba(0, 0, 0, 0.5);
        border-radius: 3px;
        line-height:120px;
        text-align:center;
    }
    
    .img_thumb img {
        vertical-align: middle;
    }
    

    The images will always be centered horizontally and vertically, no matter what their size is. Here's 2 more examples with images with different dimensions:

    http://jsfiddle.net/Cthulhu/QHEnL/6/

    http://jsfiddle.net/Cthulhu/QHEnL/7/

    UPDATE

    It's now 2016 (the future!) and looks like a few things are changing (finally!!).

    Back in 2014, Microsoft announced that it will stop supporting IE8 in all versions of Windows and will encourage all users to update to IE11 or Edge. Well, this is supposed to happen next Tuesday (12th January).

    Why does this matter? With the announced death of IE8, we can finally start using CSS3 magic.

    With that being said, here's an updated way of aligning elements, both horizontally and vertically:

    .container {
        position: relative;
    }
    
    .container .element {
       position: absolute;
       left: 50%;
       top: 50%;
       transform: translate(-50%, -50%);
    }
    

    Using this transform: translate(); method, you don't even need to have a fixed height in your container, it's fully dynamic. Your element has fixed height or width? Your container as well? No? It doesn't matter, it will always be centered because all centering properties are fixed on the child, it's independent from the parent. Thank you CSS3.

    If you only need to center in one dimension, you can use translateY or translateX. Just try it for a while and you'll see how it works. Also, try to change the values of the translate, you will find it useful for a bunch of different situations.

    Here, have a new fiddle: https://jsfiddle.net/Cthulhu/1xjbhsr4/

    For more information on transform, here's a good resource.

    Happy coding.

    Matrix multiplication using arrays

    Java. Matrix multiplication.

    Tested with matrices of different size.

    public class Matrix {
    
    /**
     * Matrix multiplication method.
     * @param m1 Multiplicand
     * @param m2 Multiplier
     * @return Product
     */
        public static double[][] multiplyByMatrix(double[][] m1, double[][] m2) {
            int m1ColLength = m1[0].length; // m1 columns length
            int m2RowLength = m2.length;    // m2 rows length
            if(m1ColLength != m2RowLength) return null; // matrix multiplication is not possible
            int mRRowLength = m1.length;    // m result rows length
            int mRColLength = m2[0].length; // m result columns length
            double[][] mResult = new double[mRRowLength][mRColLength];
            for(int i = 0; i < mRRowLength; i++) {         // rows from m1
                for(int j = 0; j < mRColLength; j++) {     // columns from m2
                    for(int k = 0; k < m1ColLength; k++) { // columns from m1
                        mResult[i][j] += m1[i][k] * m2[k][j];
                    }
                }
            }
            return mResult;
        }
    
        public static String toString(double[][] m) {
            String result = "";
            for(int i = 0; i < m.length; i++) {
                for(int j = 0; j < m[i].length; j++) {
                    result += String.format("%11.2f", m[i][j]);
                }
                result += "\n";
            }
            return result;
        }
    
        public static void main(String[] args) {
            // #1
            double[][] multiplicand = new double[][] {
                    {3, -1, 2},
                    {2,  0, 1},
                    {1,  2, 1}
            };
            double[][] multiplier = new double[][] {
                    {2, -1, 1},
                    {0, -2, 3},
                    {3,  0, 1}
            };
            System.out.println("#1\n" + toString(multiplyByMatrix(multiplicand, multiplier)));
            // #2
            multiplicand = new double[][] {
                    {1, 2, 0},
                    {-1, 3, 1},
                    {2, -2, 1}
            };
            multiplier = new double[][] {
                    {2},
                    {-1},
                    {1}
            };
            System.out.println("#2\n" + toString(multiplyByMatrix(multiplicand, multiplier)));
            // #3
            multiplicand = new double[][] {
                    {1, 2, -1},
                    {0,  1, 0}
            };
            multiplier = new double[][] {
                    {1, 1, 0, 0},
                    {0, 2, 1, 1},
                    {1, 1, 2, 2}
            };
            System.out.println("#3\n" + toString(multiplyByMatrix(multiplicand, multiplier)));
        }
    }
    

    Output:

    #1
          12.00      -1.00       2.00
           7.00      -2.00       3.00
           5.00      -5.00       8.00
    
    #2
           0.00
          -4.00
           7.00
    
    #3
           0.00       4.00       0.00       0.00
           0.00       2.00       1.00       1.00
    

    Create SQLite database in android

    Here is code

    DatabaseMyHandler.class

    public class DatabaseMyHandler extends SQLiteOpenHelper {
    
        private SQLiteDatabase myDataBase;
        private Context context = null;
        private static String TABLE_NAME = "customer";
        public static final String DATABASE_NAME = "Student.db";
        public final static String DATABASE_PATH = "/data/data/com.pkgname/databases/";
        public static final int DATABASE_VERSION = 2;
    
        public DatabaseMyHandler(Context context) {
            super(context, DATABASE_NAME, null, DATABASE_VERSION);
            this.context = context;
            try {
                createDatabase();
            } catch (IOException e) {
                e.printStackTrace();
            }
        }
    
    
        @Override
        public void onCreate(SQLiteDatabase sqLiteDatabase) {
            myDataBase = sqLiteDatabase;
    
        }
    
        @Override
        public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
    
        }
    
        //Check database already exists or not
    
        private boolean checkDatabaseExists() {
            boolean checkDB = false;
            try {
                String PATH = DATABASE_PATH + DATABASE_NAME;
                File dbFile = new File(PATH);
                checkDB = dbFile.exists();
    
            } catch (SQLiteException e) {
    
            }
            return checkDB;
        }
    
    
        //Create a empty database on the system
        public void createDatabase() throws IOException {
            boolean dbExist = checkDatabaseExists();
    
            if (dbExist) {
                Log.v("DB Exists", "db exists");
            }
    
            boolean dbExist1 = checkDatabaseExists();
            if (!dbExist1) {
                this.getWritableDatabase();
                try {
                    this.close();
                    copyDataBase();
                } catch (IOException e) {
                    throw new Error("Error copying database");
                }
            }
        }
    
        //Copies your database from your local assets-folder to the just created empty database in the system folder
        private void copyDataBase() throws IOException {
            String outFileName = DATABASE_PATH + DATABASE_NAME;
            OutputStream myOutput = new FileOutputStream(outFileName);
            InputStream myInput = context.getAssets().open(DATABASE_NAME);
    
            byte[] buffer = new byte[1024];
            int length;
            while ((length = myInput.read(buffer)) > 0) {
                myOutput.write(buffer, 0, length);
            }
            myInput.close();
            myOutput.flush();
            myOutput.close();
        }
    
    
        //Open Database
        public void openDatabase() throws SQLException {
            String PATH = DATABASE_PATH + DATABASE_NAME;
            myDataBase = SQLiteDatabase.openDatabase(PATH, null, SQLiteDatabase.OPEN_READWRITE);
        }
    
        //for insert data into database
    
    
        public void insertCustomer(String customer_id, String email_id, String password, String description, int balance_amount) {
            try {
                openDatabase();
                SQLiteDatabase db = this.getWritableDatabase();
                ContentValues contentValues = new ContentValues();
                contentValues.put("customer_id", customer_id);
                contentValues.put("email_id", email_id);
                contentValues.put("password", password);
                contentValues.put("description", description);
                contentValues.put("balance_amount", balance_amount);
                db.insert(TABLE_NAME, null, contentValues);
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    
    
        public ArrayList<ModelCreateCustomer> getLoginIdDetail(String email_id, String password) {
    
            ArrayList<ModelCreateCustomer> result = new ArrayList<ModelCreateCustomer>();
            //boolean flag = false;
            String selectQuery = "SELECT * FROM " + TABLE_NAME + " WHERE email_id='" + email_id + "' AND password='" + password + "'";
    
            try {
                openDatabase();
                Cursor cursor = myDataBase.rawQuery(selectQuery, null);
                //cursor.moveToFirst();
    
    
                if (cursor.getCount() > 0) {
                    if (cursor.moveToFirst()) {
                        do {
                            ModelCreateCustomer model = new ModelCreateCustomer();
                            model.setId(cursor.getInt(cursor.getColumnIndex("id")));
                            model.setCustomerId(cursor.getString(cursor.getColumnIndex("customer_id")));
                            model.setCustomerEmailId(cursor.getString(cursor.getColumnIndex("email_id")));
                            model.setCustomerPassword(cursor.getString(cursor.getColumnIndex("password")));
                            model.setCustomerDesription(cursor.getString(cursor.getColumnIndex("description")));
                            model.setCustomerBalanceAmount(cursor.getInt(cursor.getColumnIndex("balance_amount")));
    
                            result.add(model);
                        }
                        while (cursor.moveToNext());
                    }
                    Toast.makeText(context, "Login Successfully", Toast.LENGTH_SHORT).show();
                }
    
    //            Log.e("Count", "" + cursor.getCount());
                cursor.close();
                myDataBase.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
    
    
            return result;
        }
    
        public void updateCustomer(String id, String email_id, String description, int balance_amount) {
    
            try {
                openDatabase();
                SQLiteDatabase db = this.getWritableDatabase();
                ContentValues contentValues = new ContentValues();
                contentValues.put("email_id", email_id);
                contentValues.put("description", description);
                contentValues.put("balance_amount", balance_amount);
    
                db.update(TABLE_NAME, contentValues, "id=" + id, null);
    
            } catch (SQLException e) {
                e.printStackTrace();
            }
    
        }
    }
    

    Customer.class

    public class Customer extends AppCompatActivity{
      private DatabaseMyHandler mydb;
      @Override
        protected void onCreate(Bundle savedInstanceState) {
            super.onCreate(savedInstanceState);
            setContentView(R.layout.activity_customer);
    
            mydb = new DatabaseMyHandler(CreateCustomerActivity.this);
     mydb.insertCustomer("1", "[email protected]", "123", "test", 100);
    
        }
    
    }
    

    How to trigger an event in input text after I stop typing/writing?

    Use the attribute onkeyup="myFunction()" in the <input> of your html.

    How do I alter the position of a column in a PostgreSQL database table?

    Open the table in PGAdmin and in the SQL pane at the bottom copy the SQL Create Table statement. Then open the Query Tool and paste. If the table has data, change the table name to 'new_name', if not, delete the comment "--" in the Drop Table line. Edit the column sequence as required. Mind the missing/superfluous comma in the last column in case you have moved it. Execute the new SQL Create Table command. Refresh and ... voilà.

    For empty tables in the design stage this method is quite practical.

    In case the table has data, we need to rearrange the column sequence of the data as well. This is easy: use INSERT to import the old table into its new version with:

    INSERT INTO new ( c2, c3, c1 ) SELECT * from old;
    

    ... where c2, c3, c1 are the columns c1, c2, c3 of the old table in their new positions. Please note that in this case you must use a 'new' name for the edited 'old' table, or you will lose your data. In case the column names are many, long and/or complex use the same method as above to copy the new table structure into a text editor, and create the new column list there before copying it into the INSERT statement.

    After checking that all is well, DROP the old table and change the the 'new' name to 'old' using ALTER TABLE new RENAME TO old; and you are done.

    Sending XML data using HTTP POST with PHP

    you can use cURL library for posting data: http://www.php.net/curl

    $ch = curl_init();
    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
    curl_setopt($ch, CURLOPT_URL, "http://websiteURL");
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, "XML=".$xmlcontent."&password=".$password."&etc=etc");
    $content=curl_exec($ch);
    

    where postfield contains XML you need to send - you will need to name the postfield the API service (Clickatell I guess) expects

    Collapse all methods in Visual Studio Code

    • Fold All:

      • Windows: Ctrl + K + 0
      • Mac: ? + K + 0
    • Unfold All:

      • Windows: Ctrl + K + J
      • Mac: ? + K + J

    To see all available shortcuts in the editor:

    • Windows: Ctrl + K + S
    • Mac: ? + K + S

    Screenshot of Visual Studio keyboard shortcuts

    All shortcuts kept up to date by the Visual Studio Code team: Visual Studio Code Shortcuts

    Unable to allocate array with shape and data type

    Sometimes, this error pops up because of the kernel has reached its limit. Try to restart the kernel redo the necessary steps.

    Swift apply .uppercaseString to only the first letter of a string

    I'm getting the first character duplicated with Kirsteins' solution. This will capitalise the first character, without seeing double:

    var s: String = "hello world"
    s = prefix(s, 1).capitalizedString + suffix(s, countElements(s) - 1)
    

    I don't know whether it's more or less efficient, I just know that it gives me the desired result.

    How to create an empty array in Swift?

    Swift 5

    There are three (3) ways to create a empty array in Swift and shorthand syntax way is always preferred.

    Method 1: Shorthand Syntax

    var arr = [Int]()
    

    Method 2: Array Initializer

    var arr = Array<Int>()
    

    Method 3: Array with an Array Literal

    var arr:[Int] = []
    

    Method 4: Credit goes to @BallpointBen

    var arr:Array<Int> = []
    

    SSIS Connection Manager Not Storing SQL Password

    It happened with me as well and fixed in following way:

    Created expression based connection string and saved password in a variable and used it.

    How can I show and hide elements based on selected option with jQuery?

    To show the div while selecting one value and hide while selecting another value from dropdown box: -

     $('#yourselectorid').bind('change', function(event) {
    
               var i= $('#yourselectorid').val();
    
                if(i=="sometext") // equal to a selection option
                 {
                     $('#divid').show();
                 }
               elseif(i=="othertext")
                 {
                   $('#divid').hide(); // hide the first one
                   $('#divid2').show(); // show the other one
    
                  }
    });
    

    Convert integers to strings to create output filenames at run time

    Here is my subroutine approach to this problem. it transforms an integer in the range 0 : 9999 as a character. For example, the INTEGER 123 is transformed into the character 0123. hope it helps.

    P.S. - sorry for the comments; they make sense in Romanian :P

     subroutine nume_fisier (i,filename_tot)
    
       implicit none
       integer :: i
    
       integer :: integer_zeci,rest_zeci,integer_sute,rest_sute,integer_mii,rest_mii
       character(1) :: filename1,filename2,filename3,filename4
       character(4) :: filename_tot
    
    ! Subrutina ce transforma un INTEGER de la 0 la 9999 in o serie de CARACTERE cu acelasi numar
    
    ! pentru a fi folosite in numerotarea si denumirea fisierelor de rezultate.
    
     if(i<=9) then
    
      filename1=char(48+0)
      filename2=char(48+0)
      filename3=char(48+0)
      filename4=char(48+i)  
    
     elseif(i>=10.and.i<=99) then
    
      integer_zeci=int(i/10)
      rest_zeci=mod(i,10)
      filename1=char(48+0)
      filename2=char(48+0)
      filename3=char(48+integer_zeci)
      filename4=char(48+rest_zeci)
    
     elseif(i>=100.and.i<=999) then
    
      integer_sute=int(i/100)
      rest_sute=mod(i,100)
      integer_zeci=int(rest_sute/10)
      rest_zeci=mod(rest_sute,10)
      filename1=char(48+0)
      filename2=char(48+integer_sute)
      filename3=char(48+integer_zeci)
      filename4=char(48+rest_zeci)
    
     elseif(i>=1000.and.i<=9999) then
    
      integer_mii=int(i/1000)
      rest_mii=mod(i,1000)
      integer_sute=int(rest_mii/100)
      rest_sute=mod(rest_mii,100)
      integer_zeci=int(rest_sute/10)
      rest_zeci=mod(rest_sute,10)
      filename1=char(48+integer_mii)
      filename2=char(48+integer_sute)
      filename3=char(48+integer_zeci) 
      filename4=char(48+rest_zeci)
    
     endif
    
     filename_tot=''//filename1//''//filename2//''//filename3//''//filename4//''
     return
     end subroutine nume_fisier
    

    How I could add dir to $PATH in Makefile?

    What I usually do is supply the path to the executable explicitly:

    EXE=./bin/
    ...
    test all:
        $(EXE)x
    

    I also use this technique to run non-native binaries under an emulator like QEMU if I'm cross compiling:

    EXE = qemu-mips ./bin/
    

    If make is using the sh shell, this should work:

    test all:
        PATH=bin:$PATH x
    

    Get max and min value from array in JavaScript

    use this and it works on both the static arrays and dynamically generated arrays.

    var array = [12,2,23,324,23,123,4,23,132,23];
    var getMaxValue = Math.max.apply(Math, array );
    

    I had the issue when I use trying to find max value from code below

    $('#myTabs').find('li.active').prevAll().andSelf().each(function () {
                newGetWidthOfEachTab.push(parseInt($(this).outerWidth()));
            });
    
            for (var i = 0; i < newGetWidthOfEachTab.length; i++) {
                newWidthOfEachTabTotal += newGetWidthOfEachTab[i];
                newGetWidthOfEachTabArr.push(parseInt(newWidthOfEachTabTotal));
            }
    
            getMaxValue = Math.max.apply(Math, array);
    

    I was getting 'NAN' when I use

        var max_value = Math.max(12, 21, 23, 2323, 23);
    

    with my code

    How to split a delimited string into an array in awk?

    echo "12|23|11" | awk '{split($0,a,"|"); print a[3] a[2] a[1]}'
    

    Code signing is required for product type 'Application' in SDK 'iOS5.1'

    I had same problem with an Apple Sample Code. In project "PhotoPicker", in Architectures, the base SDK was:

    screen shot 1

    This parametrization provokes the message:

    CodeSign error: code signing is required for product type 'Application' in SDK 'iOS 7.1'

    It assumes you have a developer user, so... use it and change:

    screen shot 2

    And the error disappears.

    Homebrew: Could not symlink, /usr/local/bin is not writable

    For those running into this issue (granted 4 years after this post was made) while running Mac OS High Sierra - the steps outlined here solved the problem for me. Essentially just outlines uninstalling and reinstalling brew.

    https://medium.com/@mrkdsgn/brew-error-on-macos-high-sierra-check-you-have-permission-to-write-to-usr-local-e8bd1c6a22d4

    After running those steps, brew link worked like a charm!

    Get The Current Domain Name With Javascript (Not the path, etc.)

    How about:

    window.location.hostname
    

    The location object actually has a number of attributes referring to different parts of the URL

    Amazon S3 - HTTPS/SSL - Is it possible?

    As previously stated, it's not directly possible, but you can set up Apache or nginx + SSL on a EC2 instance, CNAME your desired domain to that, and reverse-proxy to the (non-custom domain) S3 URLs.

    How to check if a column exists before adding it to an existing table in PL/SQL?

    All the metadata about the columns in Oracle Database is accessible using one of the following views.

    user_tab_cols; -- For all tables owned by the user

    all_tab_cols ; -- For all tables accessible to the user

    dba_tab_cols; -- For all tables in the Database.

    So, if you are looking for a column like ADD_TMS in SCOTT.EMP Table and add the column only if it does not exist, the PL/SQL Code would be along these lines..

    DECLARE
      v_column_exists number := 0;  
    BEGIN
      Select count(*) into v_column_exists
        from user_tab_cols
        where upper(column_name) = 'ADD_TMS'
          and upper(table_name) = 'EMP';
          --and owner = 'SCOTT --*might be required if you are using all/dba views
    
      if (v_column_exists = 0) then
          execute immediate 'alter table emp add (ADD_TMS date)';
      end if;
    end;
    /
    

    If you are planning to run this as a script (not part of a procedure), the easiest way would be to include the alter command in the script and see the errors at the end of the script, assuming you have no Begin-End for the script..

    If you have file1.sql

    alter table t1 add col1 date;
    alter table t1 add col2 date;
    alter table t1 add col3 date;
    

    And col2 is present,when the script is run, the other two columns would be added to the table and the log would show the error saying "col2" already exists, so you should be ok.

    How to access html form input from asp.net code behind

    What I'm guessing is that you need to set those input elements to runat="server".

    So you won't be able to access the control

    <input type="text" name="email" id="myTextBox" />
    

    But you'll be able to work with

    <input type="text" name="email" id="myTextBox" runat="server" />
    

    And read from it by using

    string myStringFromTheInput = myTextBox.Value;
    

    Generating an array of letters in the alphabet

    Note also, the string has a operator[] which returns a Char, and is an IEnumerable<char>, so for most purposes, you can use a string as a char[]. Hence:

    string alpha = "ABCDEFGHIJKLMNOPQRSTUVQXYZ";
    for (int i =0; i < 26; ++i)
    {  
         Console.WriteLine(alpha[i]);
    }
    
    foreach(char c in alpha)
    {  
         Console.WriteLine(c);
    }
    

    Insert at first position of a list in Python

    Use insert:

    In [1]: ls = [1,2,3]
    
    In [2]: ls.insert(0, "new")
    
    In [3]: ls
    Out[3]: ['new', 1, 2, 3]
    

    SQLite with encryption/password protection

    SQLite has hooks built-in for encryption which are not used in the normal distribution, but here are a few implementations I know of:

    • SEE - The official implementation.
    • wxSQLite - A wxWidgets style C++ wrapper that also implements SQLite's encryption.
    • SQLCipher - Uses openSSL's libcrypto to implement.
    • SQLiteCrypt - Custom implementation, modified API.
    • botansqlite3 - botansqlite3 is an encryption codec for SQLite3 that can use any algorithms in Botan for encryption.
    • sqleet - another encryption implementation, using ChaCha20/Poly1305 primitives. Note that wxSQLite mentioned above can use this as a crypto provider.

    The SEE and SQLiteCrypt require the purchase of a license.

    Disclosure: I created botansqlite3.

    Show a message box from a class in c#?

    using System.Windows.Forms;
    ...
    MessageBox.Show("Hello World!");
    

    iptables LOG and DROP in one rule

    for china GFW:

    sudo iptables -I INPUT -s 173.194.0.0/16 -p tcp --tcp-flags RST RST -j DROP
    sudo iptables -I INPUT -s 173.194.0.0/16 -p tcp --tcp-flags RST RST -j LOG --log-prefix "drop rst"
    
    sudo iptables -I INPUT -s 64.233.0.0/16 -p tcp --tcp-flags RST RST -j DROP
    sudo iptables -I INPUT -s 64.233.0.0/16 -p tcp --tcp-flags RST RST -j LOG --log-prefix "drop rst"
    
    sudo iptables -I INPUT -s 74.125.0.0/16 -p tcp --tcp-flags RST RST -j DROP
    sudo iptables -I INPUT -s 74.125.0.0/16 -p tcp --tcp-flags RST RST -j LOG --log-prefix "drop rst"
    

    How can I properly use a PDO object for a parameterized SELECT query

    Method 1:USE PDO query method

    $stmt = $db->query('SELECT id FROM Employee where name ="'.$name.'"');
    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);
    

    Getting Row Count

    $stmt = $db->query('SELECT id FROM Employee where name ="'.$name.'"');
    $row_count = $stmt->rowCount();
    echo $row_count.' rows selected';
    

    Method 2: Statements With Parameters

    $stmt = $db->prepare("SELECT id FROM Employee WHERE name=?");
    $stmt->execute(array($name));
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
    

    Method 3:Bind parameters

    $stmt = $db->prepare("SELECT id FROM Employee WHERE name=?");
    $stmt->bindValue(1, $name, PDO::PARAM_STR);
    $stmt->execute();
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    **bind with named parameters**
    $stmt = $db->prepare("SELECT id FROM Employee WHERE name=:name");
    $stmt->bindValue(':name', $name, PDO::PARAM_STR);
    $stmt->execute();
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    or
    $stmt = $db->prepare("SELECT id FROM Employee WHERE name=:name");
    $stmt->execute(array(':name' => $name));
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
    

    Want to know more look at this link

    How can I create my own comparator for a map?

    Yes, the 3rd template parameter on map specifies the comparator, which is a binary predicate. Example:

    struct ByLength : public std::binary_function<string, string, bool>
    {
        bool operator()(const string& lhs, const string& rhs) const
        {
            return lhs.length() < rhs.length();
        }
    };
    
    int main()
    {
        typedef map<string, string, ByLength> lenmap;
        lenmap mymap;
    
        mymap["one"] = "one";
        mymap["a"] = "a";
        mymap["fewbahr"] = "foobar";
    
        for( lenmap::const_iterator it = mymap.begin(), end = mymap.end(); it != end; ++it )
            cout << it->first << "\n";
    }
    

    How do I run a simple bit of code in a new thread?

    If you want to get a value:

    var someValue;
    
    Thread thread = new Thread(delegate()
                {                 
                    //Do somthing and set your value
                    someValue = "Hello World";
                });
    
    thread.Start();
    
    while (thread.IsAlive)
      Application.DoEvents();
    

    Does Python have an ordered set?

    The ParallelRegression package provides a setList( ) ordered set class that is more method-complete than the options based on the ActiveState recipe. It supports all methods available for lists and most if not all methods available for sets.

    How do I uninstall a Windows service if the files do not exist anymore?

    1st Step : Move to the Directory where your service is present

    Command : cd c:\xxx\yyy\service

    2nd Step : Enter the below command

    Command : C:\Windows\Microsoft.NET\Framework\v4.0.30319\InstallUtil.exe service.exe \u

    Here service.exe is your service exe and \u will uninstall the service. you'll see "The uninstall has completed" message.

    If you wanna install a service, Remove \u in the above command which will install your service

    How to change font of UIButton with Swift

    Use titleLabel instead. The font property is deprecated in iOS 3.0. It also does not work in Objective-C. titleLabel is label used for showing title on UIButton.

    myButton.titleLabel?.font =  UIFont(name: YourfontName, size: 20)
    

    However, while setting title text you should only use setTitle:forControlState:. Do not use titleLabel to set any text for title directly.

    Import mysql DB with XAMPP in command LINE

    this command posted by Daniel works like charm

    C:\xampp\mysql\bin>mysql -u {DB_USER} -p {DB_NAME} < path/to/file/ab.sql
    

    just put the db username and db name without those backets

    **NOTE: Make sure your database file is reside inside the htdocs folder, else u'll get an Access denied error

    In C++ check if std::vector<string> contains a certain value

    You can use std::find as follows:

    if (std::find(v.begin(), v.end(), "abc") != v.end())
    {
      // Element in vector.
    }
    

    To be able to use std::find: include <algorithm>.

    AttributeError: 'datetime' module has no attribute 'strptime'

    If I had to guess, you did this:

    import datetime
    

    at the top of your code. This means that you have to do this:

    datetime.datetime.strptime(date, "%Y-%m-%d")
    

    to access the strptime method. Or, you could change the import statement to this:

    from datetime import datetime
    

    and access it as you are.

    The people who made the datetime module also named their class datetime:

    #module  class    method
    datetime.datetime.strptime(date, "%Y-%m-%d")
    

    Difference between using bean id and name in Spring configuration file

    Since Spring 3.1 the id attribute is an xsd:string and permits the same range of characters as the name attribute.

    The only difference between an id and a name is that a name can contain multiple aliases separated by a comma, semicolon or whitespace, whereas an id must be a single value.

    From the Spring 3.2 documentation:

    In XML-based configuration metadata, you use the id and/or name attributes to specify the bean identifier(s). The id attribute allows you to specify exactly one id. Conventionally these names are alphanumeric ('myBean', 'fooService', etc), but may special characters as well. If you want to introduce other aliases to the bean, you can also specify them in the name attribute, separated by a comma (,), semicolon (;), or white space. As a historical note, in versions prior to Spring 3.1, the id attribute was typed as an xsd:ID, which constrained possible characters. As of 3.1, it is now xsd:string. Note that bean id uniqueness is still enforced by the container, though no longer by XML parsers.

    EC2 instance types's exact network performance?

    Bandwidth is tiered by instance size, here's a comprehensive answer:

    For t2/m3/c3/c4/r3/i2/d2 instances:

    • t2.nano = ??? (Based on the scaling factors, I'd expect 20-30 MBit/s)
    • t2.micro = ~70 MBit/s (qiita says 63 MBit/s) - t1.micro gets about ~100 Mbit/s
    • t2.small = ~125 MBit/s (t2, qiita says 127 MBit/s, cloudharmony says 125 Mbit/s with spikes to 200+ Mbit/s)
    • *.medium = t2.medium gets 250-300 MBit/s, m3.medium ~400 MBit/s
    • *.large = ~450-600 MBit/s (the most variation, see below)
    • *.xlarge = 700-900 MBit/s
    • *.2xlarge = ~1 GBit/s +- 10%
    • *.4xlarge = ~2 GBit/s +- 10%
    • *.8xlarge and marked specialty = 10 Gbit, expect ~8.5 GBit/s, requires enhanced networking & VPC for full throughput

    m1 small, medium, and large instances tend to perform higher than expected. c1.medium is another freak, at 800 MBit/s.

    I gathered this by combing dozens of sources doing benchmarks (primarily using iPerf & TCP connections). Credit to CloudHarmony & flux7 in particular for many of the benchmarks (note that those two links go to google searches showing the numerous individual benchmarks).

    Caveats & Notes:

    The large instance size has the most variation reported:

    • m1.large is ~800 Mbit/s (!!!)
    • t2.large = ~500 MBit/s
    • c3.large = ~500-570 Mbit/s (different results from different sources)
    • c4.large = ~520 MBit/s (I've confirmed this independently, by the way)
    • m3.large is better at ~700 MBit/s
    • m4.large is ~445 Mbit/s
    • r3.large is ~390 Mbit/s

    Burstable (T2) instances appear to exhibit burstable networking performance too:

    • The CloudHarmony iperf benchmarks show initial transfers start at 1 GBit/s and then gradually drop to the sustained levels above after a few minutes. PDF links to reports below:

    • t2.small (PDF)

    • t2.medium (PDF)
    • t2.large (PDF)

    Note that these are within the same region - if you're transferring across regions, real performance may be much slower. Even for the larger instances, I'm seeing numbers of a few hundred MBit/s.

    How to chain scope queries with OR instead of AND?

    You would do

    Person.where('name=? OR lastname=?', 'John', 'Smith')
    

    Right now, there isn't any other OR support by the new AR3 syntax (that is without using some 3rd party gem).

    How do I connect to a specific Wi-Fi network in Android programmatically?

    I broke my head to understand why your answers for WPA/WPA2 don't work...after hours of tries I found what you are missing:

    conf.allowedAuthAlgorithms.set(WifiConfiguration.AuthAlgorithm.OPEN);
    

    is REQUIRED for WPA networks!!!!

    Now, it works :)

    How should I edit an Entity Framework connection string?

    Follow the next steps:

    1. Open the app.config and comment on the connection string (save file)
    2. Open the edmx (go to properties, the connection string should be blank), close the edmx file again
    3. Open the app.config and uncomment the connection string (save file)
    4. Open the edmx, go to properties, you should see the connection string uptated!!

    Styling input buttons for iPad and iPhone

    You may be looking for

    -webkit-appearance: none;
    

    How to find distinct rows with field in list using JPA and Spring?

    @Query("SELECT DISTINCT name FROM people WHERE name NOT IN (:names)")
    List<String> findNonReferencedNames(@Param("names") List<String> names);
    

    JavaScript global event mechanism

    One should preserve the previously associated onerror callback as well

    <script type="text/javascript">
    
    (function() {
        var errorCallback = window.onerror;
        window.onerror = function () {
            // handle error condition
            errorCallback && errorCallback.apply(this, arguments);
        };
    })();
    
    </script>
    

    Java JTable getting the data of the selected row

    using from ListSelectionModel:

    ListSelectionModel cellSelectionModel = table.getSelectionModel();
    cellSelectionModel.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
    
    cellSelectionModel.addListSelectionListener(new ListSelectionListener() {
      public void valueChanged(ListSelectionEvent e) {
        String selectedData = null;
    
        int[] selectedRow = table.getSelectedRows();
        int[] selectedColumns = table.getSelectedColumns();
    
        for (int i = 0; i < selectedRow.length; i++) {
          for (int j = 0; j < selectedColumns.length; j++) {
            selectedData = (String) table.getValueAt(selectedRow[i], selectedColumns[j]);
          }
        }
        System.out.println("Selected: " + selectedData);
      }
    
    });
    

    see here.

    org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing

    I Solved this problem adding @Cascade to the @ManyToOne attribute.

    import org.hibernate.annotations.Cascade;
    import org.hibernate.annotations.CascadeType;
    
    @ManyToOne
    @JoinColumn(name="BLOODGRUPID")
    @Cascade({CascadeType.MERGE, CascadeType.SAVE_UPDATE})
    private Bloodgroup bloodgroup;
    

    Cron job every three days

    Run it every three days...

    0 0 */3 * *
    

    How about that?

    If you want it to run on specific days of the month, like the 1st, 4th, 7th, etc... then you can just have a conditional in your script that checks for the current day of the month.

    if (((date('j') - 1) % 3))
       exit();
    

    or, as @mario points out, you can use date('k') to get the day of the year instead of doing it based on the day of the month.

    Getting the actual usedrange

    This function returns the actual used range to the lower right limit. It returns "Nothing" if the sheet is empty.

    '2020-01-26
    Function fUsedRange() As Range
    Dim lngLastRow As Long
    Dim lngLastCol As Long
    Dim rngLastCell As Range
        On Error Resume Next
        Set rngLastCell = ActiveSheet.Cells.Find("*", searchorder:=xlByRows, searchdirection:=xlPrevious)
        If rngLastCell Is Nothing Then  'look for data backwards in rows
            Set fUsedRange = Nothing
            Exit Function
        Else
            lngLastRow = rngLastCell.Row
        End If
        Set rngLastCell = ActiveSheet.Cells.Find("*", searchorder:=xlByColumns, searchdirection:=xlPrevious)
        If rngLastCell Is Nothing Then  'look for data backwards in columns
            Set fUsedRange = Nothing
            Exit Function
        Else
            lngLastCol = rngLastCell.Column
        End If
        Set fUsedRange = ActiveSheet.Range(Cells(1, 1), Cells(lngLastRow, lngLastCol))  'set up range
    End Function
    

    Is there a printf converter to print in binary format?

    Here's is a very simple one:

    int print_char_to_binary(char ch)
    {
        int i;
        for (i=7; i>=0; i--)
            printf("%hd ", ((ch & (1<<i))>>i));
        printf("\n");
        return 0;
    }
    

    How to run .sql file in Oracle SQL developer tool to import database?

    As others recommend, you can use Oracle SQL Developer. You can point to the location of the script to run it, as described. A slightly simpler method, though, is to just use drag-and-drop:

    • Click and drag your .sql file over to Oracle SQL Developer
    • The contents will appear in a "SQL Worksheet"
    • Click "Run Script" button, or hit F5, to run

    enter image description here

    File URL "Not allowed to load local resource" in the Internet Browser

    You just need to replace all image network paths to byte strings in HTML string. For this first you required HtmlAgilityPack to convert Html string to Html document. https://www.nuget.org/packages/HtmlAgilityPack

    Find Below code to convert each image src network path(or local path) to byte sting. It will definitely display all images with network path(or local path) in IE,chrome and firefox.

    string encodedHtmlString = Emailmodel.DtEmailFields.Rows[0]["Body"].ToString();

            // Decode the encoded string.
            StringWriter myWriter = new StringWriter();
            HttpUtility.HtmlDecode(encodedHtmlString, myWriter);
            string DecodedHtmlString = myWriter.ToString();
    
            //find and replace each img src with byte string
             HtmlDocument document = new HtmlDocument();
             document.LoadHtml(DecodedHtmlString);
             document.DocumentNode.Descendants("img")
              .Where(e =>
            {
                string src = e.GetAttributeValue("src", null) ?? "";
                return !string.IsNullOrEmpty(src);//&& src.StartsWith("data:image");
            })
            .ToList()
                        .ForEach(x =>
                        {
                            string currentSrcValue = x.GetAttributeValue("src", null);                                
                            string filePath = Path.GetDirectoryName(currentSrcValue) + "\\";
                            string filename = Path.GetFileName(currentSrcValue);
                            string contenttype = "image/" + Path.GetExtension(filename).Replace(".", "");
                            FileStream fs = new FileStream(filePath + filename, FileMode.Open, FileAccess.Read);
                            BinaryReader br = new BinaryReader(fs);
                            Byte[] bytes = br.ReadBytes((Int32)fs.Length);
                            br.Close();
                            fs.Close();
                            x.SetAttributeValue("src", "data:" + contenttype + ";base64," + Convert.ToBase64String(bytes));                                
                        });
    
            string result = document.DocumentNode.OuterHtml;
            //Encode HTML string
            string myEncodedString = HttpUtility.HtmlEncode(result);
    
            Emailmodel.DtEmailFields.Rows[0]["Body"] = myEncodedString;
    

    How to read string from keyboard using C?

    You have no storage allocated for word - it's just a dangling pointer.

    Change:

    char * word;
    

    to:

    char word[256];
    

    Note that 256 is an arbitrary choice here - the size of this buffer needs to be greater than the largest possible string that you might encounter.

    Note also that fgets is a better (safer) option then scanf for reading arbitrary length strings, in that it takes a size argument, which in turn helps to prevent buffer overflows:

     fgets(word, sizeof(word), stdin);
    

    Ruby function to remove all white spaces?

    Ruby's .scan() and .join() methods of String can also help to overcome whitespace in string.

    scan(/\w+/).join will remove all spaces and join the string

    string = "White spaces in me".scan(/\w+/).join
    =>"Whitespacesinme"
    

    It is also removing space from left and right part of the string. Means ltrim, rtrim and trim. Just in case if someone has background over C, FoxPro or Visual Basic and jump in Ruby.

    2.1.6 :002 > string = " White spaces in me ".scan(/\w+/).join => "Whitespacesinme" 2.1.6 :003 > string = " White spaces in me".scan(/\w+/).join => "Whitespacesinme" 2.1.6 :004 > string = "White spaces in me ".scan(/\w+/).join => "Whitespacesinme" 2.1.6 :005 >

    Difference between using Throwable and Exception in a try catch

    Thowable catches really everything even ThreadDeath which gets thrown by default to stop a thread from the now deprecated Thread.stop() method. So by catching Throwable you can be sure that you'll never leave the try block without at least going through your catch block, but you should be prepared to also handle OutOfMemoryError and InternalError or StackOverflowError.

    Catching Throwable is most useful for outer server loops that delegate all sorts of requests to outside code but may itself never terminate to keep the service alive.

    Reading file line by line (with space) in Unix Shell scripting - Issue

    You want to read raw lines to avoid problems with backslashes in the input (use -r):

    while read -r line; do
       printf "<%s>\n" "$line"
    done < file.txt
    

    This will keep whitespace within the line, but removes leading and trailing whitespace. To keep those as well, set the IFS empty, as in

    while IFS= read -r line; do
       printf "%s\n" "$line"
    done < file.txt
    

    This now is an equivalent of cat < file.txt as long as file.txt ends with a newline.

    Note that you must double quote "$line" in order to keep word splitting from splitting the line into separate words--thus losing multiple whitespace sequences.

    How to set Grid row and column positions programmatically

    Try this:

                    Grid grid = new Grid(); //Define the grid
                    for (int i = 0; i < 36; i++) //Add 36 rows
                    {
                        ColumnDefinition columna = new ColumnDefinition()
                        {
                            Name = "Col_" + i,
                            Width = new GridLength(32.5),
                        };
                        grid.ColumnDefinitions.Add(columna);
                    }
    
                    for (int i = 0; i < 36; i++) //Add 36 columns
                    {
                        RowDefinition row = new RowDefinition();
                        row.Height = new GridLength(40, GridUnitType.Pixel);
                        grid.RowDefinitions.Add(row);
                    }
    
                    for (int i = 0; i < 36; i++)
                    {
                        for (int j = 0; j < 36; j++)
                        {
                            Label t1 = new Label()
                            {
                                FontSize = 10,
                                FontFamily = new FontFamily("consolas"),
                                FontWeight = FontWeights.SemiBold,
                                BorderBrush = Brushes.LightGray,
                                BorderThickness = new Thickness(2),
                                HorizontalContentAlignment = HorizontalAlignment.Center,
                                VerticalContentAlignment = VerticalAlignment.Center,
                            };
                            Grid.SetRow(t1, i);
                            Grid.SetColumn(t1, j);
                            grid.Children.Add(t1); //Add the Label Control to the Grid created
                        }
                    }
    

    How do I get the current date and time in PHP?

    Since PHP 5.2.0 you can use the DateTime() class:

    use \Datetime;
    
    $now = new DateTime();
    echo $now->format('Y-m-d H:i:s');    // MySQL datetime format
    echo $now->getTimestamp();           // Unix Timestamp -- Since PHP 5.3
    

    And to specify the timezone:

    $now = new DateTime(null, new DateTimeZone('America/New_York'));
    $now->setTimezone(new DateTimeZone('Europe/London'));    // Another way
    echo $now->getTimezone();
    

    Multi-Line Comments in Ruby?

    =begin
    (some code here)
    =end
    

    and

    # This code
    # on multiple lines
    # is commented out
    

    are both correct. The advantage of the first type of comment is editability—it's easier to uncomment because fewer characters are deleted. The advantage of the second type of comment is readability—reading the code line by line, it's much easier to tell that a particular line has been commented out. Your call but think about who's coming after you and how easy it is for them to read and maintain.

    Adding images or videos to iPhone Simulator

    Just to tell you : KONG's solution also works on iOS 7 beta.

    His solution was:

    Drag the image to simulator, then Safari opens (or browse to the Image in the internet using Safari) Hold your click on the image When the pop-up appears, choose Save Image and enjoy ;)

    Can anybody tell me details about hs_err_pid.log file generated when Tomcat crashes?

    A very very good document regarding this topic is Troubleshooting Guide for Java from (originally) Sun. See the chapter "Troubleshooting System Crashes" for information about hs_err_pid* Files.

    See Appendix C - Fatal Error Log

    Per the guide, by default the file will be created in the working directory of the process if possible, or in the system temporary directory otherwise. A specific location can be chosen by passing in the -XX:ErrorFile product flag. It says:

    If the -XX:ErrorFile= file flag is not specified, the system attempts to create the file in the working directory of the process. In the event that the file cannot be created in the working directory (insufficient space, permission problem, or other issue), the file is created in the temporary directory for the operating system.

    how to access master page control from content page

    You cannot use var in a field, only on local variables.

    But even this won't work:

    Site master = Master as Site;
    

    Because you cannot use this in a field and Master as Site is the same as this.Master as Site. So just initialize the field from Page_Init when the page is fully initialized and you can use this:

    Site master = null;
    
    protected void Page_Init(object sender, EventArgs e)
    {            
        master = this.Master as Site;
    }
    

    How to create a table from select query result in SQL Server 2008

    Please try:

    SELECT * INTO NewTable FROM OldTable
    

    Can I fade in a background image (CSS: background-image) with jQuery?

    This is what worked for my, and its pure css


    css

    html {
        padding: 0;
        margin: 0;
        width: 100%;
        height: 100%;
      }
    
      body {
        padding: 0;
        margin: 0;
        width: 100%;
        height: 100%;
      }
    
      #bg {
        width: 100%;
        height: 100%;
        background: url('/image.jpg/') no-repeat center center fixed;
    
        -webkit-background-size: cover;
        -moz-background-size: cover;
        -o-background-size: cover;
        background-size: cover;
    
        -webkit-animation: myfirst 5s ; /* Chrome, Safari, Opera */
        animation: myfirst 5s ;
      }
    
      /* Chrome, Safari, Opera */
      @-webkit-keyframes myfirst {
        from {opacity: 0.2;}
        to {opacity: 1;}
      }
    
      /* Standard syntax */
      @keyframes myfirst {
        from {opacity: 0.2;}
        to {opacity: 1;}
      }
    

    html

    <!DOCTYPE html>
    <html>
    <head>
        <title></title>
    </head>
    <body>
      <div id="bg">
        <!-- content here -->
      </div> <!-- end bg -->
    </body>
    </html>
    

    How do I import a sql data file into SQL Server?

    Try this process -

    Open the Query Analyzer

    Start --> Programs --> MS SQL Server --> Query Analyzer

    Once opened, connect to the database that you are wish running the script on.

    Next, open the SQL file using File --> Open option. Select .sql file.

    Once it is open, you can execute the file by pressing F5.

    Bootstrap throws Uncaught Error: Bootstrap's JavaScript requires jQuery

    You need to add JQuery before adding bootstrap-

    <!-- JQuery Core JavaScript -->
    <script src="lib/js/jquery.min.js"></script>
    
    <!-- Bootstrap Core JavaScript -->
    <script src="lib/js/bootstrap.min.js"></script>
    

    SQL selecting rows by most recent date with two unique columns

    You can use a GROUP BY to group items by type and id. Then you can use the MAX() Aggregate function to get the most recent service month. The below returns a result set with ChargeId, ChargeType, and MostRecentServiceMonth

    SELECT
      CHARGEID,
      CHARGETYPE,
      MAX(SERVICEMONTH) AS "MostRecentServiceMonth"
    FROM INVOICE
    GROUP BY CHARGEID, CHARGETYPE
    

    How to fix a collation conflict in a SQL Server query?

    I had problems with collations as I had most of the tables with Modern_Spanish_CI_AS, but a few, which I had inherited or copied from another Database, had SQL_Latin1_General_CP1_CI_AS collation.

    In my case, the easiest way to solve the problem has been as follows:

    1. I've created a copy of the tables which were 'Latin American, using script table as...
    2. The new tables have obviously acquired the 'Modern Spanish' collation of my database
    3. I've copied the data of my 'Latin American' table into the new one, deleted the old one and renamed the new one.

    I hope this helps other users.

    Unsupported major.minor version 52.0

    Upgrade your Andorra version to JDK 1.8.

    This is a version mismatch that your compiler is looking for Java version 8 and you have Java version 7.

    You can run an app build in version 7 in version 8, but you can't do vice versa because when it comes to higher levels, versions are embedded with more features, enhancements rather than previous versions.

    Download JDK version from this link

    And set your JDK path for this

    Is there a Newline constant defined in Java like Environment.Newline in C#?

    Be aware that this property isn't as useful as many people think it is. Just because your app is running on a Windows machine, for example, doesn't mean the file it's reading will be using Windows-style line separators. Many web pages contain a mixture of "\n" and "\r\n", having been cobbled together from disparate sources. When you're reading text as a series of logical lines, you should always look for all three of the major line-separator styles: Windows ("\r\n"), Unix/Linux/OSX ("\n") and pre-OSX Mac ("\r").

    When you're writing text, you should be more concerned with how the file will be used than what platform you're running on. For example, if you expect people to read the file in Windows Notepad, you should use "\r\n" because it only recognizes the one kind of separator.

    How to add a string to a string[] array? There's no .Add function

    to clear the array and make the number of it's elements = 0 at the same time, use this..

    System.Array.Resize(ref arrayName, 0);
    

    How to change button background image on mouseOver?

    I made a quick project in visual studio 2008 for a .net 3.5 C# windows form application and was able to create the following code. I found events for both the enter and leave methods.

    In the InitializeComponent() function. I added the event handler using the Visual Studio designer.

    this.button1.MouseLeave += new System.EventHandler( this.button1_MouseLeave );
    this.button1.MouseEnter += new System.EventHandler( this.button1_MouseEnter );
    

    In the button event handler methods set the background images.

    /// <summary>
    /// Handles the MouseEnter event of the button1 control.
    /// </summary>
    /// <param name="sender">The source of the event.</param>
    /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
    private void button1_MouseEnter( object sender, EventArgs e )
    {
          this.button1.BackgroundImage = ((System.Drawing.Image)(Properties.Resources.img2));
    }
    
    /// <summary>
    /// Handles the MouseLeave event of the button1 control.
    /// </summary>
    /// <param name="sender">The source of the event.</param>
    /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param>
    private void button1_MouseLeave( object sender, EventArgs e )
    {
           this.button1.BackgroundImage = ((System.Drawing.Image)(Properties.Resources.img1));
    }
    

    Could not open a connection to your authentication agent

    Did You Start ssh-agent?

    You might need to start ssh-agent before you run the ssh-add command:

    eval `ssh-agent -s`
    ssh-add
    

    Note that this will start the agent for msysgit Bash on Windows. If you're using a different shell or operating system, you might need to use a variant of the command, such as those listed in the other answers.

    See the following answers:

    1. ssh-add complains: Could not open a connection to your authentication agent
    2. Git push requires username and password (contains detailed instructions on how to use ssh-agent)
    3. How to run (git/ssh) authentication agent?.
    4. Could not open a connection to your authentication agent

    To automatically start ssh-agent and allow a single instance to work in multiple console windows, see Start ssh-agent on login.

    Why do we need to use eval instead of just ssh-agent?

    To find out why, see Robin Green's answer.

    Public vs Private Keys

    Also, whenever I use ssh-add, I always add private keys to it. The file ~/.ssh/id_rsa.pub looks like a public key, I'm not sure if that will work. Do you have a ~/.ssh/id_rsa file? If you open it in a text editor, does it say it's a private key?

    Using PropertyInfo.GetValue()

    In your example propertyInfo.GetValue(this, null) should work. Consider altering GetNamesAndTypesAndValues() as follows:

    public void GetNamesAndTypesAndValues()
    {
      foreach (PropertyInfo propertyInfo in allClassProperties)
      {
        Console.WriteLine("{0} [type = {1}] [value = {2}]",
          propertyInfo.Name,
          propertyInfo.PropertyType,
          propertyInfo.GetValue(this, null));
      }
    }
    

    console.log showing contents of array object

    It's simple to print an object to console in Javascript. Just use the following syntax:

    console.log( object );
    

    or

    console.log('object: %O', object );
    

    A relatively unknown method is following which prints an object or array to the console as table:

    console.table( object );

    I think it is important to say that this kind of logging statement only works inside a browser environment. I used this with Google Chrome. You can watch the output of your console.log calls inside the Developer Console: Open it by right click on any element in the webpage and select 'Inspect'. Select tab 'Console'.

    postgres, ubuntu how to restart service on startup? get stuck on clustering after instance reboot

    I guess it would be best to fix the database startup script itself. But as a work around, you can add that line to /etc/rc.local, which is executed about last in init phase.

    extract part of a string using bash/cut/split

    Using a single sed

    echo "/var/cpanel/users/joebloggs:DNS9=domain.com" | sed 's/.*\/\(.*\):.*/\1/'
    

    Why am I getting string does not name a type Error?

    string does not name a type. The class in the string header is called std::string.

    Please do not put using namespace std in a header file, it pollutes the global namespace for all users of that header. See also "Why is 'using namespace std;' considered a bad practice in C++?"

    Your class should look like this:

    #include <string>
    
    class Game
    {
        private:
            std::string white;
            std::string black;
            std::string title;
        public:
            Game(std::istream&, std::ostream&);
            void display(colour, short);
    };
    

    How to change legend size with matplotlib.pyplot

    There are multiple settings for adjusting the legend size. The two I find most useful are:

    • labelspacing: which sets the spacing between label entries in multiples of the font size. For instance with a 10 point font, legend(..., labelspacing=0.2) will reduce the spacing between entries to 2 points. The default on my install is about 0.5.
    • prop: which allows full control of the font size, etc. You can set an 8 point font using legend(..., prop={'size':8}). The default on my install is about 14 points.

    In addition, the legend documentation lists a number of other padding and spacing parameters including: borderpad, handlelength, handletextpad, borderaxespad, and columnspacing. These all follow the same form as labelspacing and area also in multiples of fontsize.

    These values can also be set as the defaults for all figures using the matplotlibrc file.

    How can I get a JavaScript stack trace when I throw an exception?

    Note that chromium/chrome (other browsers using V8), and also Firefox do have a convenient interface to get a stacktrace through a stack property on Error objects.

    try {
       // Code throwing an exception
    } catch(e) {
      console.log(e.stack);
    }
    

    It applies for the base exceptions as well as for the ones you throw yourself. (Considered that you use the Error class, which is anyway a good practice).

    See details on V8 documentation

    Easy way to concatenate two byte arrays

    Merge two PDF byte arrays

    If you are merging two byte arrays which contain PDF, this logic will not work. We need to use a third-party tool like PDFbox from Apache:

    ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
    mergePdf.addSource(new ByteArrayInputStream(a));
    mergePdf.addSource(new ByteArrayInputStream(b));
    mergePdf.setDestinationStream(byteArrayOutputStream);
    mergePdf.mergeDocuments();
    c = byteArrayOutputStream.toByteArray();
    

    is there a require for json in node.js

    No. Either use readFile or readFileSync (The latter only at startup time).

    Or use an existing library like

    Alternatively write your config in a js file rather then a json file like

    module.exports = {
      // json
    }
    

    Angular JS: What is the need of the directive’s link function when we already had directive’s controller with scope?

    The controller function/object represents an abstraction model-view-controller (MVC). While there is nothing new to write about MVC, it is still the most significant advanatage of angular: split the concerns into smaller pieces. And that's it, nothing more, so if you need to react on Model changes coming from View the Controller is the right person to do that job.

    The story about link function is different, it is coming from different perspective then MVC. And is really essential, once we want to cross the boundaries of a controller/model/view (template).

    Let' start with the parameters which are passed into the link function:

    function link(scope, element, attrs) {
    
    • scope is an Angular scope object.
    • element is the jqLite-wrapped element that this directive matches.
    • attrs is an object with the normalized attribute names and their corresponding values.

    To put the link into the context, we should mention that all directives are going through this initialization process steps: Compile, Link. An Extract from Brad Green and Shyam Seshadri book Angular JS:

    Compile phase (a sister of link, let's mention it here to get a clear picture):

    In this phase, Angular walks the DOM to identify all the registered directives in the template. For each directive, it then transforms the DOM based on the directive’s rules (template, replace, transclude, and so on), and calls the compile function if it exists. The result is a compiled template function,

    Link phase:

    To make the view dynamic, Angular then runs a link function for each directive. The link functions typically creates listeners on the DOM or the model. These listeners keep the view and the model in sync at all times.

    A nice example how to use the link could be found here: Creating Custom Directives. See the example: Creating a Directive that Manipulates the DOM, which inserts a "date-time" into page, refreshed every second.

    Just a very short snippet from that rich source above, showing the real manipulation with DOM. There is hooked function to $timeout service, and also it is cleared in its destructor call to avoid memory leaks

    .directive('myCurrentTime', function($timeout, dateFilter) {
    
     function link(scope, element, attrs) {
    
     ...
    
     // the not MVC job must be done
     function updateTime() {
       element.text(dateFilter(new Date(), format)); // here we are manipulating the DOM
     }
    
     function scheduleUpdate() {
       // save the timeoutId for canceling
       timeoutId = $timeout(function() {
         updateTime(); // update DOM
         scheduleUpdate(); // schedule the next update
       }, 1000);
     }
    
     element.on('$destroy', function() {
       $timeout.cancel(timeoutId);
     });
    
     ...
    

    Is there an upper bound to BigInteger?

    The first maximum you would hit is the length of a String which is 231-1 digits. It's much smaller than the maximum of a BigInteger but IMHO it loses much of its value if it can't be printed.

    Check if an excel cell exists on another worksheet in a column - and return the contents of a different column

    You can use following formulas.

    For Excel 2007 or later:

    =IFERROR(VLOOKUP(D3,List!A:C,3,FALSE),"No Match")
    

    For Excel 2003:

    =IF(ISERROR(MATCH(D3,List!A:A, 0)), "No Match", VLOOKUP(D3,List!A:C,3,FALSE))
    

    Note, that

    • I'm using List!A:C in VLOOKUP and returns value from column ? 3
    • I'm using 4th argument for VLOOKUP equals to FALSE, in that case VLOOKUP will only find an exact match, and the values in the first column of List!A:C do not need to be sorted (opposite to case when you're using TRUE).

    How to retrieve the current version of a MySQL database management system (DBMS)?

    SHOW VARIABLES LIKE "%version%";
    +-------------------------+------------------------------------------+
    | Variable_name           | Value                                    |
    +-------------------------+------------------------------------------+
    | protocol_version        | 10                                       |
    | version                 | 5.0.27-standard                          |
    | version_comment         | MySQL Community Edition - Standard (GPL) |
    | version_compile_machine | i686                                     |
    | version_compile_os      | pc-linux-gnu                             |
    +-------------------------+------------------------------------------+
    5 rows in set (0.04 sec)
    

    MySQL 5.0 Reference Manual (pdf) - Determining Your Current MySQL Version - page 42

    Can I mask an input text in a bat file?

    I used Blorgbeard's above solution which is actually great in my opinion. Then I enhanced it as follows:

    1. Google for ansicon
    2. Download zip file and sample text file.
    3. Install (that means copy 2 files into system32)

    Use it like this:

    @echo off
    ansicon -p
    set /p pwd=Password:ESC[0;37;47m
    echo ESC[0m
    

    This switches the console to gray on gray for your password entry and switches back when you are done. The ESC should actually be an unprintable character, which you can copy over from the downloaded sample text file (appears like a left-arrow in Notepad) into your batch file. You can use the sample text file to find the codes for all color combinations.

    If you are not admin of the machine, you will probably be able to install the files in a non-system directory, then you have to append the directory to the PATH in your script before calling the program and using the escape sequences. This could even be the current directory probably, if you need a non-admin distributable package of just a few files.

    Submit form using AJAX and jQuery

    This is what ended up working.

    $("select").change(function(){
        $.get("/page.html?" + $(this).parent("form").find(":input").serialize()); 
    });
    

    Check if a user has scrolled to the bottom

    i used this test to detect the scroll reached the bottom: event.target.scrollTop === event.target.scrollHeight - event.target.offsetHeight

    How to create Drawable from resource

    Your Activity should have the method getResources. Do:

    Drawable myIcon = getResources().getDrawable( R.drawable.icon );
    


    As of API version 21 this method is deprecated and can be replaced with:

    Drawable myIcon = AppCompatResources.getDrawable(context, R.drawable.icon);
    

    If you need to specify a custom theme, the following will apply it, but only if API is version 21 or greater:

    Drawable myIcon =  ResourcesCompat.getDrawable(getResources(), R.drawable.icon, theme);
    

    How to insert text at beginning of a multi-line selection in vi/Vim

    I can recommend the EnhCommentify plugin.

    eg. put this to your vimrc:

    let maplocalleader=','
    vmap <silent> <LocalLeader>c <Plug>VisualTraditional
    nmap <silent> <LocalLeader>c <Plug>Traditional
    let g:EnhCommentifyBindInInsert = 'No'
    let g:EnhCommentifyMultiPartBlocks = 'Yes'
    let g:EnhCommentifyPretty = 'Yes'
    let g:EnhCommentifyRespectIndent = 'Yes'
    let g:EnhCommentifyUseBlockIndent = 'Yes'
    

    you can then comment/uncomment the (selected) lines with ',c'

    Error 'LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt' after installing Visual Studio 2012 Release Preview

    Reinstalling CMake worked for me. The new copy of CMake figured out that it should use Visual Studio 11 instead of 10.

    PHP Get Site URL Protocol - http vs https

    Because testing port number is not a good practice according to me, my solution is:

    define('HTTPS', isset($_SERVER['HTTPS']) && filter_var($_SERVER['HTTPS'], FILTER_VALIDATE_BOOLEAN));
    

    The HTTPSconstant returns TRUE if $_SERVER['HTTPS'] is set and equals to "1", "true", "on" or "yes". Returns FALSE otherwise.

    Check if instance is of a type

    Yes, the "is" keyword:

    if (c is TForm)
    {
        ...
    }
    

    See details on MSDN: http://msdn.microsoft.com/en-us/library/scekt9xw(VS.80).aspx

    Checks if an object is compatible with a given type. For example, it can be determined if an object is compatible with the string type like this:

    How to update ruby on linux (ubuntu)?

    the above is not bad, however its kinda different for 11.10

    sudo apt-get install ruby1.9 rubygems1.9
    

    that will install ruby 1.9

    when linking, you just use ls /usr/bin | grep ruby it should output ruby1.9.1

    so then you sudo ln -sf /usr/bin/ruby1.9.1 /usr/bin/ruby and your off to the races.

    How to check postgres user and password?

    You may change the pg_hba.conf and then reload the postgresql. something in the pg_hba.conf may be like below:

    # "local" is for Unix domain socket connections only
    local   all             all                                     trust
    # IPv4 local connections:
    host    all             all             127.0.0.1/32            trust
    

    then you change your user to postgresql, you may login successfully.

    su postgresql
    

    finished with non zero exit value

    I too was facing this issue just because i had renamed my project folder while project was opened in Android Sudio.So,Android Studio created another folder in that directory of my window.

    I found in my build.gradle(Module:app), all the support libraries were updated and was throwing error on compile time of project.

    All you require to do is,simply change updated support libraries to your current build tool version like this and rebuild the project.

    compile 'com.android.support:appcompat-v7:22.2.1'
    compile 'com.android.support:design:22.2.1'
    compile 'com.android.support:cardview-v7:22.2.1'
    

    my current build tool version is 22.2.1

    How to Get enum item name from its value

    Here is another neat trick to define enum using X Macro:

    #include <iostream>
    
    #define WEEK_DAYS \
    X(MON, "Monday", true) \
    X(TUE, "Tuesday", true) \
    X(WED, "Wednesday", true) \
    X(THU, "Thursday", true) \
    X(FRI, "Friday", true) \
    X(SAT, "Saturday", false) \
    X(SUN, "Sunday", false)
    
    #define X(day, name, workday) day,
    enum WeekDay : size_t
    {
        WEEK_DAYS
    };
    #undef X
    
    #define X(day, name, workday) name,
    char const *weekday_name[] =
    {
        WEEK_DAYS
    };
    #undef X
    
    #define X(day, name, workday) workday,
    bool weekday_workday[]
    {
        WEEK_DAYS
    };
    #undef X
    
    int main()
    {
        std::cout << "Enum value: " << WeekDay::THU << std::endl;
        std::cout << "Name string: " << weekday_name[WeekDay::THU] << std::endl;
        std::cout << std::boolalpha << "Work day: " << weekday_workday[WeekDay::THU] << std::endl;
    
        WeekDay wd = SUN;
        std::cout << "Enum value: " << wd << std::endl;
        std::cout << "Name string: " << weekday_name[wd] << std::endl;
        std::cout << std::boolalpha << "Work day: " << weekday_workday[wd] << std::endl;
    
        return 0;
    }
    

    Live Demo: https://ideone.com/bPAVTM

    Outputs:

    Enum value: 3
    Name string: Thursday
    Work day: true
    Enum value: 6
    Name string: Sunday
    Work day: false
    

    How do I format a number with commas in T-SQL?

    Here is a scalar function I am using that fixes some bugs in a previous example (above) and also handles decimal values (to the specified # of digits) (EDITED to also work with 0 & negative numbers). One other note, the cast as money method above is limited to the size of the MONEY data type, and doesn't work with 4 (or more) digits decimals. That method is definitely simpler but less flexible.

    CREATE FUNCTION [dbo].[fnNumericWithCommas](@num decimal(38, 18), @decimals int = 4) RETURNS varchar(44) AS
    BEGIN
        DECLARE @ret varchar(44)
    
        DECLARE @negative bit; SET @negative = CASE WHEN @num < 0 THEN 1 ELSE 0 END
    
        SET @num = abs(round(@num, @decimals)) -- round the value to the number of decimals desired
        DECLARE @decValue varchar(18); SET @decValue = substring(ltrim(@num - round(@num, 0, 1)) + '000000000000000000', 3, @decimals)
        SET @num = round(@num, 0, 1) -- truncate the incoming number of any decimals
        WHILE @num > 0 BEGIN
            SET @ret = str(@num % 1000, 3, 0) + isnull(','+@ret, '')
            SET @num = round(@num / 1000, 0, 1)
        END
        SET @ret = isnull(replace(ltrim(@ret), ' ', '0'), '0') + '.' + @decValue
        IF (@negative = 1) SET @ret = '-' + @ret
    
        RETURN @ret
    END
    
    GO
    

    Which is the best Linux C/C++ debugger (or front-end to gdb) to help teaching programming?

    You could try using Insight a graphical front-end for gdb written by Red Hat Or if you use GNOME desktop environment, you can also try Nemiver.

    java: Class.isInstance vs Class.isAssignableFrom

    Both answers are in the ballpark but neither is a complete answer.

    MyClass.class.isInstance(obj) is for checking an instance. It returns true when the parameter obj is non-null and can be cast to MyClass without raising a ClassCastException. In other words, obj is an instance of MyClass or its subclasses.

    MyClass.class.isAssignableFrom(Other.class) will return true if MyClass is the same as, or a superclass or superinterface of, Other. Other can be a class or an interface. It answers true if Other can be converted to a MyClass.

    A little code to demonstrate:

    public class NewMain
    {
        public static void main(String[] args)
        {
            NewMain nm = new NewMain();
            nm.doit();
        }
    
        class A { }
    
        class B extends A { }
    
        public void doit()
        {
            A myA = new A();
            B myB = new B();
            A[] aArr = new A[0];
            B[] bArr = new B[0];
    
            System.out.println("b instanceof a: " + (myB instanceof A)); // true
            System.out.println("b isInstance a: " + A.class.isInstance(myB)); //true
            System.out.println("a isInstance b: " + B.class.isInstance(myA)); //false
            System.out.println("b isAssignableFrom a: " + A.class.isAssignableFrom(B.class)); //true
            System.out.println("a isAssignableFrom b: " + B.class.isAssignableFrom(A.class)); //false
            System.out.println("bArr isInstance A: " + A.class.isInstance(bArr)); //false
            System.out.println("bArr isInstance aArr: " + aArr.getClass().isInstance(bArr)); //true
            System.out.println("bArr isAssignableFrom aArr: " + aArr.getClass().isAssignableFrom(bArr.getClass())); //true
        }
    }
    

    Convert Pandas Column to DateTime

    You can use the DataFrame method .apply() to operate on the values in Mycol:

    >>> df = pd.DataFrame(['05SEP2014:00:00:00.000'],columns=['Mycol'])
    >>> df
                        Mycol
    0  05SEP2014:00:00:00.000
    >>> import datetime as dt
    >>> df['Mycol'] = df['Mycol'].apply(lambda x: 
                                        dt.datetime.strptime(x,'%d%b%Y:%H:%M:%S.%f'))
    >>> df
           Mycol
    0 2014-09-05
    

    Correct format specifier for double in printf

    "%f" is the (or at least one) correct format for a double. There is no format for a float, because if you attempt to pass a float to printf, it'll be promoted to double before printf receives it1. "%lf" is also acceptable under the current standard -- the l is specified as having no effect if followed by the f conversion specifier (among others).

    Note that this is one place that printf format strings differ substantially from scanf (and fscanf, etc.) format strings. For output, you're passing a value, which will be promoted from float to double when passed as a variadic parameter. For input you're passing a pointer, which is not promoted, so you have to tell scanf whether you want to read a float or a double, so for scanf, %f means you want to read a float and %lf means you want to read a double (and, for what it's worth, for a long double, you use %Lf for either printf or scanf).


    1. C99, §6.5.2.2/6: "If the expression that denotes the called function has a type that does not include a prototype, the integer promotions are performed on each argument, and arguments that have type float are promoted to double. These are called the default argument promotions." In C++ the wording is somewhat different (e.g., it doesn't use the word "prototype") but the effect is the same: all the variadic parameters undergo default promotions before they're received by the function.

    Jenkins - how to build a specific branch

    I can see many good answers to the question, but I still would like to share this method, by using Git parameter as follows:

    Add Git parameter

    When building the pipeline you will be asked to choose the branch: Choose branch to build

    After that through the groovy code you could specify the branch you want to clone:

    git branch:BRANCH[7..-1], url: 'https://github.com/YourName/YourRepo.git' , credentialsId: 'github' 
    

    Note that I'm using a slice from 7 to the last character to shrink "origin/" and get the branch name.

    Also in case you configured a webhooks trigger it still work and it will take the default branch you specified(master in our case).

    Mysql 1050 Error "Table already exists" when in fact, it does not

    Sounds like you have Schroedinger's table...

    Seriously now, you probably have a broken table. Try:

    • DROP TABLE IF EXISTS contenttype
    • REPAIR TABLE contenttype
    • If you have sufficient permissions, delete the data files (in /mysql/data/db_name)

    Responsive image map

    I found a no-JS way to address this if you are okay with rectangular hit areas.

    First of all, make sure your image is in a div that's relatively positioned. Then put the image inside this div, which means it'll take up all the space in the div. Finally, add absolutely positioned div's under the image, within the main div, and use percentages for top, left, width, and height to get the link hit areas the size and position you want.

    I find it's easiest to give the div a black background color (ideally with some alpha fading so you can see the linked content underneath) when you're first working, and to use a code inspector in your browser to adjust the percentages in real time, so that you can get it just right.

    Here's the basic outline you can work with. By doing everything with percentages, you ensure the elements all stay the same relative size and position as the image scales.

    <div style="position: relative;">
      <img src="background-image.png" style="width: 100%; height: auto;">
      <a href="/link1"><div style="position: absolute; left: 15%; top: 20%; width: 12%; height: 8%; background-color: rgba(0, 0, 0, .25);"></div></a>
      <a href="/link2"><div style="position: absolute; left: 52%; top: 38%; width: 14%; height: 20%; background-color: rgba(0, 0, 0, .25);"></div></a>
    </div>
    

    Use this code with your code inspector in Chrome or your browser of choice, and adjust the percentages (you can use decimal percentages to be more exact) until the boxes are just right. Also choose a background-color of transparent when you're ready to use it since you want your hit areas to be invisible.

    db.collection is not a function when using MongoClient v3.0

    For those that want to continue using version ^3.0.1 be aware of the changes to how you use the MongoClient.connect() method. The callback doesn't return db instead it returns client, against which there is a function called db(dbname) that you must invoke to get the db instance you are looking for.

    const MongoClient = require('mongodb').MongoClient;
    const assert = require('assert');
    
    // Connection URL
    const url = 'mongodb://localhost:27017';
    
    // Database Name
    const dbName = 'myproject';
    
    // Use connect method to connect to the server
    MongoClient.connect(url, function(err, client) {
      assert.equal(null, err);
      console.log("Connected successfully to server");
    
      const db = client.db(dbName);
    
      client.close();
    });
    

    I have 2 dates in PHP, how can I run a foreach loop to go through all of those days?

    If you use Laravel and want to use Carbon the correct solution would be the following:

    $start_date = Carbon::createFromFormat('Y-m-d', '2020-01-01');
    $end_date = Carbon::createFromFormat('Y-m-d', '2020-01-31');
    
    $period = new CarbonPeriod($start_date, '1 day', $end_date);
    
    foreach ($period as $dt) {
     echo $dt->format("l Y-m-d H:i:s\n");
    }
    

    Remember to add:

    • use Carbon\Carbon;
    • use Carbon\CarbonPeriod;

    Sending mass email using PHP

    I already did it using Lotus Notus and PHP.

    This solution works if you have access to the mail server or you can request something to the mail server Administrator:

    1) Create a group in the mail server: Sales Department

    2) Assign to the group the accounts you need to be in the group

    3) Assign an internet address to the group: [email protected]

    4) Create your PHP script using the mail function:

    $to = "[email protected]";
    mail($to, $subject, $message, $headers);
    



    It worked for me and all the accounts included in the group receive the mail.

    The best of the lucks.

    How do I reference to another (open or closed) workbook, and pull values back, in VBA? - Excel 2007

    You will have to open the file in one way or another if you want to access the data within it. Obviously, one way is to open it in your Excel application instance, e.g.:-

    (untested code)

    Dim wbk As Workbook
    Set wbk = Workbooks.Open("C:\myworkbook.xls")
    
    ' now you can manipulate the data in the workbook anyway you want, e.g. '
    
    Dim x As Variant
    x = wbk.Worksheets("Sheet1").Range("A6").Value
    
    Call wbk.Worksheets("Sheet2").Range("A1:G100").Copy
    Call ThisWorbook.Worksheets("Target").Range("A1").PasteSpecial(xlPasteValues)
    Application.CutCopyMode = False
    
    ' etc '
    
    Call wbk.Close(False)
    

    Another way to do it would be to use the Excel ADODB provider to open a connection to the file and then use SQL to select data from the sheet you want, but since you are anyway working from within Excel I don't believe there is any reason to do this rather than just open the workbook. Note that there are optional parameters for the Workbooks.Open() method to open the workbook as read-only, etc.

    Last Run Date on a Stored Procedure in SQL Server

    If you enable Query Store on SQL Server 2016 or newer you can use the following query to get last SP execution. The history depends on the Query Store Configuration.

    SELECT 
          ObjectName = '[' + s.name + '].[' + o.Name  + ']'
        , LastModificationDate  = MAX(o.modify_date)
        , LastExecutionTime     = MAX(q.last_execution_time)
    FROM sys.query_store_query q 
        INNER JOIN sys.objects o
            ON q.object_id = o.object_id
        INNER JOIN sys.schemas s
            ON o.schema_id = s.schema_id
    WHERE o.type IN ('P')
    GROUP BY o.name , + s.name 
    

    initializing a boolean array in java

    The main difference is that Boolean is an object and boolean is an primitive.

    • Object default value is null;
    • boolean default value is false;

    How to exit an if clause

    while some_condition:
       ...
       if condition_a:
           # do something
           break
       ...
       if condition_b:
           # do something
           break
       # more code here
       break
    

    LinkButton Send Value to Code Behind OnClick

    Add a CommandName attribute, and optionally a CommandArgument attribute, to your LinkButton control. Then set the OnCommand attribute to the name of your Command event handler.

    <asp:LinkButton ID="ENameLinkBtn" runat="server" CommandName="MyValueGoesHere" CommandArgument="OtherValueHere" 
              style="font-weight: 700; font-size: 8pt;" OnCommand="ENameLinkBtn_Command" ><%# Eval("EName") %></asp:LinkButton>
    
    <asp:Label id="Label1" runat="server"/>
    

    Then it will be available when in your handler:

    protected void ENameLinkBtn_Command (object sender, CommandEventArgs e)
    {
       Label1.Text = "You chose: " + e.CommandName + " Item " + e.CommandArgument;
    }
    

    More info on MSDN

    System.MissingMethodException: Method not found?

    This happened to me using MVC4, and I decided after reading this thread to rename the object that was throwing the error.

    I did a clean and rebuild and noted that it was skipping two projects. When I rebuilt one of them, there was an error where I'd started a function and not finished it.

    So VS was referencing a model that I had rewritten without asking me if I wanted to do that.

    Drawing rotated text on a HTML5 canvas

    Here's an HTML5 alternative to homebrew: http://www.rgraph.net/ You might be able to reverse engineer their methods....

    You might also consider something like Flot (http://code.google.com/p/flot/) or GCharts: (http://www.maxb.net/scripts/jgcharts/include/demo/#1) It's not quite as cool, but fully backwards compatible and scary easy to implement.

    Bash script error [: !=: unary operator expected

    Quotes!

    if [ "$1" != -v ]; then
    

    Otherwise, when $1 is completely empty, your test becomes:

    [ != -v ]
    

    instead of

    [ "" != -v ]
    

    ...and != is not a unary operator (that is, one capable of taking only a single argument).

    How do I exit the results of 'git diff' in Git Bash on windows?

    Using WIN + Q worked for me. Just q alone gave me "command not found" and eventually it jumped back into the git diff insanity.

    How much overhead does SSL impose?

    Assuming you don't count connection set-up (as you indicated in your update), it strongly depends on the cipher chosen. Network overhead (in terms of bandwidth) will be negligible. CPU overhead will be dominated by cryptography. On my mobile Core i5, I can encrypt around 250 MB per second with RC4 on a single core. (RC4 is what you should choose for maximum performance.) AES is slower, providing "only" around 50 MB/s. So, if you choose correct ciphers, you won't manage to keep a single current core busy with the crypto overhead even if you have a fully utilized 1 Gbit line. [Edit: RC4 should not be used because it is no longer secure. However, AES hardware support is now present in many CPUs, which makes AES encryption really fast on such platforms.]

    Connection establishment, however, is different. Depending on the implementation (e.g. support for TLS false start), it will add round-trips, which can cause noticable delays. Additionally, expensive crypto takes place on the first connection establishment (above-mentioned CPU could only accept 14 connections per core per second if you foolishly used 4096-bit keys and 100 if you use 2048-bit keys). On subsequent connections, previous sessions are often reused, avoiding the expensive crypto.

    So, to summarize:

    Transfer on established connection:

    • Delay: nearly none
    • CPU: negligible
    • Bandwidth: negligible

    First connection establishment:

    • Delay: additional round-trips
    • Bandwidth: several kilobytes (certificates)
    • CPU on client: medium
    • CPU on server: high

    Subsequent connection establishments:

    • Delay: additional round-trip (not sure if one or multiple, may be implementation-dependant)
    • Bandwidth: negligible
    • CPU: nearly none

    Relay access denied on sending mail, Other domain outside of network

    I'm using THUNDERBIRD as MUA and I have same issues. I solved adding the IP address of my home PC on mynetworks parameter on main.cf

    mynetworks = 127.0.0.0/8 [::ffff:127.0.0.0]/104 [::1]/128 MyIpAddress

    P.S. I don't have a static ip for my home PC so when my ISP change it I ave to adjust every time.

    jQuery call function after load

    Crude, but does what you want, breaks the execution scope:

    $(function(){
    setTimeout(function(){
    //Code to call
    },1);
    });
    

    JSchException: Algorithm negotiation fail

    add KexAlgorithms diffie-hellman-group1-sha1,diffie-hellman-group-exchange-sha??1 to your sshd_config on the server.

    This worked, but make sure you restart sshd: sudo service sshd restart

    How to replace � in a string

    dissect the URL code and unicode error. this symbol came to me as well on google translate in the armenian text and sometimes the broken burmese.

    "’" showing on page instead of " ' "

    The same thing happened to me with the '–' character (long minus sign).
    I used this simple replace so resolve it:

    htmlText = htmlText.Replace('–', '-');
    

    The type or namespace name 'Entity' does not exist in the namespace 'System.Data'

    I will add my answer to cover all cases:

    My solution was unistalling EntityFramework from NuGet Package Manager and then I was prompted to restart Visual Studio because it couldn't "finalize the uninstall".

    I restarted Visual Studio and reinstalled EntityFramework then my problem was solved.

    Hope this helps someone!

    How to make unicode string with python3

    In a Python 2 program that I used for many years there was this line:

    ocd[i].namn=unicode(a[:b], 'utf-8')
    

    This did not work in Python 3.

    However, the program turned out to work with:

    ocd[i].namn=a[:b]
    

    I don't remember why I put unicode there in the first place, but I think it was because the name can contains Swedish letters åäöÅÄÖ. But even they work without "unicode".

    How to sort with lambda in Python

    You're trying to use key functions with lambda functions.

    Python and other languages like C# or F# use lambda functions.

    Also, when it comes to key functions and according to the documentation

    Both list.sort() and sorted() have a key parameter to specify a function to be called on each list element prior to making comparisons.

    ...

    The value of the key parameter should be a function that takes a single argument and returns a key to use for sorting purposes. This technique is fast because the key function is called exactly once for each input record.

    So, key functions have a parameter key and it can indeed receive a lambda function.

    In Real Python there's a nice example of its usage. Let's say you have the following list

    ids = ['id1', 'id100', 'id2', 'id22', 'id3', 'id30']
    

    and want to sort through its "integers". Then, you'd do something like

    sorted_ids = sorted(ids, key=lambda x: int(x[2:])) # Integer sort
    

    and printing it would give

    ['id1', 'id2', 'id3', 'id22', 'id30', 'id100']
    

    In your particular case, you're only missing to write key= before lambda. So, you'd want to use the following

    a = sorted(a, key=lambda x: x.modified, reverse=True)
    

    jQuery’s .bind() vs. .on()

    These snippets all perform exactly the same thing:

    element.on('click', function () { ... });
    element.bind('click', function () { ... });
    element.click(function () { ... });
    

    However, they are very different from these, which all perform the same thing:

    element.on('click', 'selector', function () { ... });
    element.delegate('click', 'selector', function () { ... });
    $('selector').live('click', function () { ... });
    

    The second set of event handlers use event delegation and will work for dynamically added elements. Event handlers that use delegation are also much more performant. The first set will not work for dynamically added elements, and are much worse for performance.

    jQuery's on() function does not introduce any new functionality that did not already exist, it is just an attempt to standardize event handling in jQuery (you no longer have to decide between live, bind, or delegate).

    How to check if file already exists in the folder

    Dim SourcePath As String = "c:\SomeFolder\SomeFileYouWantToCopy.txt" 'This is just an example string and could be anything, it maps to fileToCopy in your code.
    Dim SaveDirectory As string = "c:\DestinationFolder"
    
    Dim Filename As String = System.IO.Path.GetFileName(SourcePath) 'get the filename of the original file without the directory on it
    Dim SavePath As String = System.IO.Path.Combine(SaveDirectory, Filename) 'combines the saveDirectory and the filename to get a fully qualified path.
    
    If System.IO.File.Exists(SavePath) Then
       'The file exists
    Else
        'the file doesn't exist
    End If