Posts by Diego de Lima • 147 points
9 posts
-
1
votes1
answer879
viewsA: VBA Excel - Index Match with two conditions
I managed to solve with the following code: ActiveCell.Offset(0, -2).FormulaArray = "=INDEX(Tabela1[ID],MATCH(1,(cliente=Tabela1[CLIENTE])*(" & tipo & "=Tabela1[TIPO]),0))" Hint taken from…
-
1
votes1
answer879
viewsQ: VBA Excel - Index Match with two conditions
I have a spreadsheet with several tabs. In the first tab I have the following table: In tab 2 type the client and the type, and I wish to return the ID. For this I am using the following code in…
-
0
votes1
answer161
viewsA: MSSQL query on Ubuntu 18.04 LTS has stopped working
Version 17 did not require installing the ssql driver. In case of this update to the 18.04, I needed to install it and configure it according to this procedure:…
-
0
votes1
answer161
viewsQ: MSSQL query on Ubuntu 18.04 LTS has stopped working
I have a program that has been running on Ubuntu-server 17 for some time. This system performs queries on a database server with MSSQL 2008. I performed the installation of Ubuntu 18.04 LTS, and did…
-
0
votes1
answer111
viewsA: Mongodb extension for PHP 7.2.3 on Ubuntu 18.04
As contributed by fajuchem, missing only install extension.
-
0
votes1
answer111
viewsQ: Mongodb extension for PHP 7.2.3 on Ubuntu 18.04
I’ve been running Mongodb together as PHP on Ubuntu Server 17 for some time. I recently installed a copy of Ubuntu Server 18.04 and did the same installation procedure. But even including…
-
1
votes1
answer67
viewsQ: How to create a jquery object and insert it into mongodb via ajax?
I have the following structure in html: <form id="titulo"> <input type="text" name="nome"> </form> <form id="turno1"> <div class="linha"> <input type="text"…
-
0
votes1
answer188
viewsQ: How to iterate PHP array received as JSON?
I got the following JSON, that I create by the method JSON.stringify(dados), and walkthrough ajax to the php: {"nome":"nome_da_pessoa", "registro":"registro_da_pessoa",…
-
1
votes1
answer83
viewsQ: Mongodb Objectid returning [Object Object] in Ajax
In a query I do in Mongodb using Ajax and PHP, when I manipulate Objectid already in javascript, it returns me as [Object Object]. How do I use it as a string? It follows code $.ajax() $.ajax({ url:…