Calling the mysql procedure returns an empty result

When I call procedure, I get an empty result

   call hussian('prstate','table_1','column1,column2,column3',1)

it is running but there is empty result, please help me …


 CREATE PROCEDURE hussain(IN src_col varchar(20), 
                     IN tblname varchar(100), 
                     IN col_names varchar(100), 
                     IN _leadid int)

    IF (col_names  = 'column1' AND col_names  = 'column2'  AND col_names = 'column3')

    SET @sql = CONCAT('insert into ', tblname, '(',col_names,')', ' select ' ,src_col,',','firstname,lastname from tbllead where id = ',_leadid); 
    PREPARE s1 from @sql;
     EXECUTE s1;
  END //

it inserts data into table when i romove condition ….. mvc – problem calling another controller's view

Friends I have a detail with a new address, I will show you the access URL to a login project that we are carrying out:

As you can see, the controller's action indicates that it is performing a validation. This is confirmed. We call another action with the name "User" for his action Login and call it up as follows:

if (oRA.resultado > 1)
            return View("Mensaje", oRA);
            Session("mensaje_usuario") = "";
            **return View("Login","Usuario");**

In the ELSE section he calls me to the URL, but the weapon looks like this: / Login

It shows me the login view but doesn't load the layout of the view. So that this is displayed correctly, I remove a login from the above URL and everything is displayed correctly. / Login

The login is as a clearing subsite … how can I make the correct call from the controller application to the login of the user controller.

Many thanks for the help.

Append the dual sim code in front of the phone number when calling from SIM2

I've been trying to find a way to do this for weeks, but I just can't find a solution.
I have two SIM cards, private (SIM1) and work (SIM2).
SIM2 has a dedicated dialer app that basically adds a specific code (which never changes, 154784) before the number I want to call.

Telephone number: 070-1111-2222
Call from the app becomes: 1547847011112222

The problem is that this dialer only supports SIM2 and I currently have to use two different dialers depending on which SIM card I want to call from.

What I want to do is use the default dialer, which prompts me to choose a SIM card when I want to make a call, and do it so that the above code (154784) is automatically added when I dial SIM2 , I want to avoid using the other dialer app altogether.

Is it something that can be done or should I just give it up?

sharepoint online – Power Shell error: Exception when calling "ExecuteQuery" with "0" arguments: "File not found."

I am scripting to essentially copy an entire directory to a SharePoint Online library. I created the folder directory in SharePoint, but it seems that I cannot load files into the online directory. I think I'm really close to cracking this beast. I just have to solve one last mistake. The full error and my code are listed below:

I printed line 109 in bold

Exception when calling "ExecuteQuery" with "0" arguments: "File not found."
In the line: 109 characters: 5
+ $ clientContext.ExecuteQuery ()
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo: NotSpecified: (:) (), MethodInvocationException
+ FullyQualifiedErrorId: ServerException

 ###################### copy files 
$t1  = get-date
$count = ((Get-ChildItem -File  -Recurse -Path $source_folder) | Measure-Object -Property FullName ).Count
foreach ($file in (Get-ChildItem -File  -Recurse -Path $source_folder))
    $t01  = get-date
    #$url_dest = $url_sharepoint+$Url_site+$file.FullName.Substring($file.FullName.IndexOf($MainFolder)-1).ToLower().Replace('','/')
    #$url_dest = $url_sharepoint+$Url_site+'/'+$library+(($file.FullName.ToLower()).Replace($source_folder.ToLower(),'')).Replace('','/')
    $url_dest = $url_sharepoint+$Url_site+$library+$file.FullName.Substring($file.FullName.IndexOf($MainFolder)-1).ToLower().Replace('','/')
    $FileStream = New-Object IO.FileStream($File.FullName,(System.IO.FileMode)::Open)
    $FileCreationInfo = New-Object Microsoft.SharePoint.Client.FileCreationInformation
    $FileCreationInfo.Overwrite = $true
    $FileCreationInfo.ContentStream = $FileStream
    $FileCreationInfo.URL = $url_dest
    $Upload = $mylist.RootFolder.Files.Add($FileCreationInfo)
    $listItem = $upload.ListItemAllFields
    Write-Host " Uploading file $i/$count $url_dest"
    $t02  = get-date
    $speed ="{0:n2}" -f ($file.Length/($t02-$t01).TotalSeconds/1mb)
    Write-Host "...................upload speed was " $speed " MB/sec"


$size = "{0:n2}" -f (gci -path $source_folder -recurse | measure-object -property length -sum).sum

Ranger – What is the action of calling a creature prey?

The feat "Hunt for Prey" gives a ranger bonuses against a creature. You seem to be able to set a goal that seems endless in one day:

You can only target one creature at a time. If
you use prey to hunt a creature if you already have a creature
designated, the previous creature loses the label and the new prey
receives the designation. Your name remains valid until the next day

This feat is marked Focus and ranger,

A few questions to clarify things I'm not sure of:

  1. Can a ranger endlessly redefine targets to be hunted during a day?
  2. How many actions (if any) is it to set a new goal?

sharepoint addin – The SPListItem field is reset to zero after calling Update

I use Sharepoint 2013 with the following code:

listItem("MyCol") = " "; // Space character.
Console.WriteLine($"listItem("MyCol") = {listItem("MyCol")}"); // Here i see the space character.
Console.WriteLine($"listItem("MyCol") = {listItem("MyCol")}"); // Here value is became null.

It looks like the problem is only reproduced for spaces.

PHP error calling a member function prepare () on array

I have this error preparing my query. I can not determine where the error comes from. I'll put the codes below.

With the storage function in foreach, I pass the column array and data array to the storage function

public function salvar(array $dadosPastos, int $id)

    $coluns = array_filter($this->coluns,function ($valor,$chave){
        return $valor != "pasto_id" && $valor != "pasto_situacao";

    $insert = $this->dao->criarInsert($this->table,$this->coluns);

    $retorno = false;
    foreach ($dadosPastos as $chave => $valor) {


        $dados = array_filter($this->collection(),function($valor,$chave){
            return $chave != "pasto_id" && $chave != "pasto_situacao";

        $retorno = $insert->save($coluns,$dados);

        if(!$retorno) {
            echo "Erro ao salvar pastos";

    return $retorno;

public function save(array $arrayColunas, $arrayDados)
        if(is_array($arrayColunas) == true && is_array($arrayDados) == true)
            $query = $this->buildInsert($arrayColunas);

            $stm = $this->conexao->prepare($query);

            $contador = 1;

            foreach ($arrayDados as $atributo => $valor)
             $retornoExecucao = $stm->execute();
             $lastId = $this->conexao->lastInsertId();

             return compact("retornoExecucao","lastId");

        return null;
    }catch(PDOException $e)
        if(Errors::$error == true)
            Errors::geraExecao("Erro a salvar");
    }catch (Exception $e){
        if(Errors::$error == true)
            Errors::geraExecao("Erro a salvar");

In the memory function, it receives the arrays and inserts them into the bank. The error is shown on line 78, in my preparations

Get the system interface to Epson Printer by calling the toll-free number

Epson Printer is very popular for its print quality. If you have one Epson printerand

I don't know how to connect it to your computer. Then call ours immediately

Customer support toll free number now. You are able to solve any problem

without disability. Customers can call us while we resolve any technical issue. You can make calls at odd times as we are there for you around the clock.

magento2.3 – Magento 2.3 Varnish 503 Calling the backend failed

Paint server returns error message:

Error 503 Backend fetch failed
Backend fetch failed

Guru Meditation:
XID: 131307

Paint protocol info:

Varnish cache server   
# varnishlog -q 'RespStatus == 503'
*   << Request  >> 131307
-   Begin          req 196933 rxreq
-   Timestamp      Start: 1577129611.804607 0.000000 0.000000
-   Timestamp      Req: 1577129611.804607 0.000000 0.000000
-   ReqStart 57376
-   ReqMethod      GET
-   ReqURL /index.php/admin/customer/index/index/key/a1cb5649e0727c563c92b6873c654c996b94a4729dfdb8247ef3b57350c20ff2/
-   ReqProtocol    HTTP/1.1
-   ReqHeader      Host: m2.docker
-   ReqHeader      Connection: keep-alive
-   ReqHeader      Upgrade-Insecure-Requests: 1
-   ReqHeader      User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_14_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.88 Safari/537.36
-   ReqHeader      Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
-   ReqHeader      Referer: http://m2.docker/index.php/admin/admin/system_store/index/key/3685fd86510c4b9c1f7796f25f1b7fda21adcab527d13b0c3822bcb2d207ae40/
-   ReqHeader      Accept-Encoding: gzip, deflate
-   ReqHeader      Accept-Language: en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7
-   ReqHeader      Cookie: admin=3c2d07d3c163dd84faed04865f7e1401; form_key=CgVTpyUNua3s7Ynq; private_content_version=e105233d30e3e7553aa81958343c8dfb; AMCVS_8F99160E571FC0427F000101%40AdobeOrg=1; s_cc=true; mage-translation-storage=%7B%7D; mage-translation-file-version=%7
-   ReqHeader      X-Forwarded-For:
-   VCL_call       RECV
-   ReqURL         /index.php/admin/customer/index/index/key/a1cb5649e0727c563c92b6873c654c996b94a4729dfdb8247ef3b57350c20ff2/
-   ReqUnset       Accept-Encoding: gzip, deflate
-   ReqHeader      Accept-Encoding: gzip
-   ReqURL         /index.php/admin/customer/index/index/key/a1cb5649e0727c563c92b6873c654c996b94a4729dfdb8247ef3b57350c20ff2/
-   ReqURL         /index.php/admin/customer/index/index/key/a1cb5649e0727c563c92b6873c654c996b94a4729dfdb8247ef3b57350c20ff2/
-   ReqURL         /index.php/admin/customer/index/index/key/a1cb5649e0727c563c92b6873c654c996b94a4729dfdb8247ef3b57350c20ff2/
-   VCL_return     hash
-   VCL_call       HASH
-   VCL_return     lookup
-   Debug          "XXXX MISS"
-   VCL_call       MISS
-   VCL_return     fetch
-   Link           bereq 196935 fetch
-   Timestamp      Fetch: 1577129676.180708 64.376101 64.376101
-   RespProtocol   HTTP/1.1
-   RespStatus     503
-   RespReason     Backend fetch failed
-   RespHeader     Date: Mon, 23 Dec 2019 19:34:36 GMT
-   RespHeader     Server: Varnish
-   RespHeader     Content-Type: text/html; charset=utf-8
-   RespHeader     Retry-After: 5
-   RespHeader     X-Varnish: 196934
-   RespHeader     Age: 0
-   RespHeader     Via: 1.1 varnish-v4
-   VCL_call       DELIVER
-   RespUnset      Age: 0
-   RespUnset      Server: Varnish
-   RespUnset      X-Varnish: 196934
-   RespUnset      Via: 1.1 varnish-v4
-   VCL_return     deliver
-   Timestamp      Process: 1577129676.180742 64.376135 0.000034
-   RespHeader     Content-Length: 283
-   Debug          "RES_MODE 2"
-   RespHeader     Connection: keep-alive
-   Timestamp      Resp: 1577129676.180834 64.376226 0.000092
-   Debug          "XXX REF 1"
-   ReqAcct        1658 0 1658 175 283 458
-   End

I have the & # 39; default.vcl & # 39; from the Magento 2 backend export.

bitcoin core – How do I calculate the transaction fee for calling createpsbt ()?

When my user calls up my app, he passes the desired value of the TX fee in Satoshis per byte as the input parameter. I create a PSBT by calling createpsbt(), I have complete control over the determination of entrances and exits. For example, I don't call walletcreatefundedpsbt()because I don't want Bitcoind to choose inputs on my behalf. I have a chicken and egg problem that I need to call createpsbt() in order to determine the size of the tx in bytes, i have to state the amount of the fee before calling createpsbt(), The best solution I can think of is to make a dummy call to createpsbt() Use a dummy charge value, then measure the size of the TX and then make a real call createpsbt() after correct calculation of the fee amount. Is there a better way?

To edit: I want to output all UTXOs. I want two exits, one fixed amount, the other a change minus the fee. I've tried many mantras, I can't get it to work. Here is my last try:

raw_psbt = rpc.walletcreatefundedpsbt(
    # all UTXOs, as returned by listunspent():
    # one recipient: ( { addr : amount } )
    0,  # locktime
        "replaceable" : True,
        # I would like for the change less the fee to go here:
        "changeAddress" : xxx,
        "includeWatching" : True,
        "feeRate" : 0.005,

That fails with Signing transaction failed (-4), Any idea what I'm doing wrong?