Java ArrayList to single string without using loop

I have an ArrayList that is added to periodically. What I want to do is to cast the entire ArrayList to a String without doing a loop. Can anybody tell me is it possible without using loop?

Edited:
So we found some solutions, Like

list.stream().collect(Collectors.joining());

Or

String result = String.join(",", list);

or some others as well. Now Just for getting knowledge I put a question which one is the most optimal way for compiler?

Answer

You could make a stream out of your list and collect it using joining collector :

list.stream().collect(Collectors.joining());

You can pass the separator to Collectors::joining method for example :

list.stream().collect(Collectors.joining("-"));

Or you can use String::join method :

String result = String.join(",", list);

where , is the separator.

mysql - Syntax error or access violation php sql

i have added this sql in my code ,

function devenir_client_dataforform() {
        $type = $_POST['clientType'];
        //$produitname = $_POST['produitname'];

        $produitnid = $_POST['produitnid'];
        $query = db_select('node', 'n');

        $query->leftjoin('field_data_field_description_col_1', 'img', 'img.entity_id = n.nid');
        $query->leftjoin('field_data_field_pdf_file_image', 'pdf', 'pdf.entity_id = n.nid');
        $query->leftjoin('taxonomy_term_data', 't', 't.tid ='.$type); 



        $query->condition('n.nid', $produitnid, '=')

              //->condition('t.tid', $type, '=')
              ->fields('n', array('title'))
              ->fields('t', array('name'))
              ->fields('pdf', array('field_pdf_file_image_fid'))
              ->fields('img', array('field_description_col_1_value'));

        $result = $query->execute();
        foreach ($result as $record) {
            if(!empty($record->field_description_col_1_value)) {
                $fid =  $record->field_description_col_1_value;

                $produitname =  $record->title;
                $pdf =  $record->field_pdf_file_image_fid;
                $tp = $record->name;

            }
        }   
        $file = file_load($pdf);
        $uri = $file->uri;

        $path = file_create_url($uri);

        //$uri = image_style_path( $path);
         $items[] =  array(
                            "type" => $tp ,
                            "produitname" => $produitname,
                            "produitnid" => $produitnid,
                            "image" => $fid,
                            "pdf" => $path,
                            "typeid" => $type
                    );
        return $items;

    }

but in the last step there is an error

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064
You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'WHERE (n.nid = NULL)' at line 4: SELECT n.title AS title, t.name

AS name, pdf.field_pdf_file_image_fid AS field_pdf_file_image_fid,
img.field_description_col_1_value AS field_description_col_1_value
FROM {node} n LEFT OUTER JOIN {field_data_field_description_col_1} img
ON img.entity_id = n.nid LEFT OUTER JOIN
{field_data_field_pdf_file_image} pdf ON pdf.entity_id = n.nid LEFT
OUTER JOIN {taxonomy_term_data} t ON t.tid = WHERE (n.nid =
:db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0]
=> ) in devenir_client_dataforform() (line 189 of /home/dotit_bh/bh-website.dotit.mobi/sites/all/modules/devenir_client/devenir_client.module).

Answer

Error in this part of SQL Query:

 WHERE (n.nid = NULL)

Correct SQL Query:

WHERE (n.nid is NULL)

You shall rewrite your script:

$nid_operator = ($produitnid ? '=' : 'is');
$query->condition('n.nid', $produitnid, $nid_operator)
              //->condition('t.tid', $type, '=')
              ->fields('n', array('title'))
              ->fields('t', array('name'))
              ->fields('pdf', array('field_pdf_file_image_fid'))

              ->fields('img', array('field_description_col_1_value'));

marketing - First movie that collaborated with fast-food outlets?

In 1984, the movie Gremlins teamed up with Hardees to sell a set of LPs that came along with the movie:

Each week a different record would be sold, thus, each week, parents had to take their children to Hardees to get the latest one.

What was the first movie to team up with fast-food to do something like this? What was the product they sold?

Answer

The KFFT List Guide says:

Burger King was a pioneer in the
advertising practice known as the
product tie-in with a successful
partnering with George Lucas’
Lucasfilm, Ltd. to promote the 1977
film Star Wars in which BK sold a set of glasses featuring the main characters
from the film. This promotion was one
of the first in the fast food industry and
set the pattern that continues to the
present.

And from Wikipedia http://en.wikipedia.org/wiki/Burger_King_advertising :

Burger King's first successful cross- promotional campaign was in 1977. It offered several collectible items, such as
posters, glasses and sticker sets that
featured scenes and characters from Star Wars.

Here's some photos of the 1978 posters and cups and cups from 1977.

Set range using a variable for the row - Excel VBA

Short and (hopefully) simple question, I have searched a worksheet range to find a particular reference number and then want to search a range in that row for the first blank cell from the left, using the code snippet below (which I developed from this question: mrExcel help site)

Set projectSearchRange = Sheets("Milestones").Range("A:A").Find(projectref, , xlValues, xlWhole)

current_row = projectSearchRange.Row

Set searchrange = Sheets("Milestones").Range(Sheets("Milestones").Cells(current_row, 2), _

Sheets("Milestones").Cells(current_row, 23)).SpecialCells(xlCellTypeBlanks).Cells(1).Activate

milestoneduedate = ActiveCell.Offset(, 1).Value

However, the Set Searchrange line is throwing a

Runtime 424 - object required error

but as I understand it, I have written the line correctly.

Any insight as to what I've done wrong would be appreciated.

Answer

This should work for you:

Function MilestoneDueDate() As Variant

Dim projectSearchRange As Range

Dim Current_Row As Long
Dim SearchRange As Range

With Sheets("Milestones")
    Set projectSearchRange = .Range("A:A").Find(projectref, , xlValues, xlWhole)
    Current_Row = projectSearchRange.Row
    Set SearchRange = .Range(Cells(Current_Row, 2), Cells(Current_Row, 23)) _
       .SpecialCells(xlCellTypeBlanks).Cells(1)
End With


MilestoneDueDate = SearchRange.Offset(0, 1).Value

End Function

python - How can I round up the number of periodic digits?

I have two numbers, one I get by calculating it and the other one I bring it from the database.

calculated = 2.183333333333333
database   = 2.18333333333333

But when I compare them to know if they are the same, I return False when it should be True.

There is some way to limit the number of periodic numbers, but not to affect decimals that are not periodic, for example:

2.1748888888888 -> 2.1748
1.23333333      -> 1.23

Answer

You could use the math.isclose method:

>>> from math import isclose
>>> calculated = 2.183333333333333
>>> database   = 2.18333333333333
>>> isclose(calculated, database)
True

This allows for setting the relative tolerance and minimum absolute tolerance as well refer to the docs for more explanation.

mysql - Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean

Attempting to create a 'Change Password' page for my website, I keep being confronted with these two errors and I can't seem to understand why they are appearing;

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /home/ll12rth/public_html/COMM2735/database/password.php on line 51
Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in /home/ll12rth/public_html/COMM2735/database/password.php on line 139

session_start();
$db_hostname = 'localhost';


    $db_database = "****"; //replace with your db name
    $db_username = "****"; //replace with the db username that you created
    $db_password = "****"; //replace with the db password that you created
    $db_status   = 'not initialised';   
    $db_server   = mysqli_connect($db_hostname, $db_username, $db_password);
    $db_status   = "connected";

    if (!$db_server) {
        die("Unable to connect to MySQL: " . mysqli_connect_error());
        $db_status = "not connected";

    } else 

require_once('checklog.php');
require_once("functions.php");



// Grab the form data

$username = trim($_POST['username']);

$password = trim($_POST['password']);
$newpassword = trim($_POST['newpassword']);
$repeatpassword = trim($_POST['repeatpassword']);

if (isset($_POST['submit'])) {
    if ($username && $password) {
        $username = clean_string($db_server, $username);
        $password = clean_string($db_server, $password);
        $query = "SELECT * FROM users WHERE username='$username'";


        $result = mysqli_query($db_server, $query);

        if ($row = mysqli_fetch_array($result)) {
            $db_username = $row['username'];
            $db_password = $row['password'];

            if ($username == $db_username && salt($password) == $db_password) {
                $_SESSION['username'] = $username;
                $_SESSION['logged'] = "logged";


                // header('Location: home.php');
                // PASSWORD CHANGING IS DONE HERE
                if ($newpassword == $repeatpassword) {
                    //From register
                    if (strlen($newpassword) > 25 || strlen($newpassword) < 6) {
                        $message = "Password must be 6-25 characters long";
                    } else {
                        //part 8
                        // Process details here


                        //include file to do db connect

                        if ($db_server) {
                            //clean the input now that we have a db connection

                            $newpassword    = clean_string($db_server, $newpassword);
                            $repeatpassword = clean_string($db_server, $repeatpassword);
                            mysqli_select_db($db_server, $db_database);

                            // check whether username exists


                            $query = "SELECT password FROM users WHERE password='$newpassword'";

                           $result=mysqli_query($db_server, $query);

                            if ($row = mysqli_fetch_array($result)){
                                $message = "This is your current password. Please try again.";
                            } else {
                                //part 9
                                // Process further here

                                $newpassword = salt($newpassword);

                                $query = "INSERT INTO users (password) VALUES 

                                        ('$password')";

                                mysqli_query($db_server, $query) or die("Insert failed. " . mysqli_error($db_server));
                                $message = "
Your password has been changed!
";
                            }


                            mysqli_free_result($result);

                        } else {

                            $message = "Error: could not connect to the database.";

                        }

                        require_once("php/db_close.php"); //include file to do db close
                    }

                }
                //This code appears if passwords dont match 
                else {
                    $message = "
Your new passwords do not match! Try again.
";
                }

            } else {
                $message = "
Incorrect password!
";
            }
        } else {

            $message = "
That user does not exist!
" . "Please try again";
        }
        mysqli_free_result($result);

      //Close connection!
mysqli_close($db_server);

    } else {

        $message = "
Please enter a valid username/password
";


    }
}
?>







    
What do you want to change your password to echo $_SESSION['username'];
?>?



Current Username: 

Current Password: 


New Password: 

Repeat New Password: 



 




echo $message
?>

plot explanation - What happened to the natives?

In Aguirre: The Wrath of God, two natives approach the raft, and are taken aboard. After the priest on the raft attempts to convert them by showing them the bible and saying that it is the word of God, one of the natives tries to listen to it, and complains he can't hear anything. This makes the people on the raft upset, and they gather around, yelling at the natives, who crouch down, presumably in fright.

Then, in the next scene, they are gone for good. Were we supposed to infer that they were killed? The movie didn't shy away from showing other deaths. But it's not obvious that they could have gone anywhere.

Did I miss something?

jquery - Double HTTP call to server with different METHOD

My ex-colleague left some angular.js code to save some data to database via a HTTP POST.

factory.save=function(data){

    var deferred=$q.defer();

    $http({
        url:'http://localhost/saveData',
        method:"POST",
        headers: {'Content-Type': 'application/json'},
        data:data
    }).success(function(result){
        //success
        deferred.resolve();

    });

    return deferred.promise;
}

When I exam the web traffic between the UI and API Server, I see the saveData API was called twice. The first call is using request method OPTIONS and the second one is POST as expected. I searched throughout the UI code and don't find any API call to saveData with method = OPTIONS. Is this something built in $http? How do I save this hit to the API server?

PHP -MySQL:No connection could be made

I tried to connect mysql database.but am getting the following error.

Warning: mysql_connect(): [2002] No connection could be made because the target machine actively (trying to connect via tcp://localhost:3306) in test.php on line 5

Warning: mysql_connect(): No connection could be made because the target machine actively refused it. in test.php on line 5 Warning: mysql_close() expects parameter 1 to be resource, boolean given in test.php on line 15

test.php:

$link = mysql_connect(localhost, dbuser, dbpass);
if (!$link) {

   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>