Posts by Lucas Souza • 170 points
20 posts
-
0
votes0
answers23
viewsQ: Client application in Heroku
My application is a client application where it consumes a Proxy API and shows the data received in 'ejs'. But when deploying in Heroku, when I try to access the URL displays the message below:…
-
0
votes1
answer662
viewsA: Excel export in PHP showing error
I think the problem was in downloading PHP, probably must have corrupted some file while downloading. Because I downloaded PHP 7.1.20 again, I pointed to the new folder and now it’s working.
-
1
votes1
answer662
viewsQ: Excel export in PHP showing error
I have a problem trying to export file to Excel in PHP. I tried with the library PHPExcel even though it is obsolete/discontinued and I tested with PhpSpreadSheet also. But both presented the same…
-
0
votes1
answer1781
viewsQ: Fatal error: Uncaught Error: Class 'COM' not found with PHP 7.2.x
Someone would tell me how to solve this problem? When I access my local address of my website, it returns this message "Fatal error: Uncaught Error: Class 'COM' not found". This message is only…
phpasked Lucas Souza 170 -
0
votes1
answer115
viewsQ: Query to catch date difference
I wonder how I can make a query of this type in Mongodb with date difference and picking the last record in a date range. SELECT *, DATEDIFF(NOW(),DATAHORA) AS DIAS FROM TBLTRANSFERS WHERE…
-
4
votes1
answer114
viewsQ: Bind by SQL Server position using JS Node (MSSQL)
I wonder if it is possible to bind the parameters by position instead of the name using mssql in Nodejs. Ex.: //Por nome return pool.request() .input('input_parameter1', sql.Int, 10)…
-
0
votes0
answers110
viewsQ: npm ERR! - When executing some command in the application
It was with the application in Nodejs working normally, but now it starts the application. But when I execute any command it presents this error. I’m using the Sqlite3. npm ERR! Windows_nt…
-
3
votes4
answers571
viewsA: Apply class to a link within an echo?
Try using simple quotes, it’s easier. echo "<a href=" . $pasta . $resultado['nomearq'] . " class='buttonlink'>".$resultado['dataup']." / " . $resultado['nomearq'] . "</a><br />";…
-
2
votes1
answer173
viewsQ: Sqlite - Too Many levels of Trigger recursion
I’m getting the error below when I try to make an insertion in Sqlite. Error while executing SQL query on database 'BDTESTE': Too Many levels of Trigger recursion Table creation CREATE TABLE…
-
0
votes0
answers697
viewsQ: Error: ORA-01461: can bind a LONG value only for Insert into a LONG column
I’m getting this error on Oracle. Error: ORA-01461: can bind a LONG value only for Insert into a LONG column When executing the code below that the error is presented, I would like to know how to…
-
0
votes0
answers81
viewsQ: Change Mysql query to work on SQL Server and Oracle
Would anyone know how this query in Mysql would look in SQL Server and Oracle? SELECT COUNT(*) AS TOTAL, SUM(EVENTO = 7 AND RESULTADO = 0) AS QTD_RX_OK, SUM(EVENTO = 7 AND RESULTADO <> 0) AS…
-
0
votes2
answers634
viewsA: Change button text in AJAX request
Change your function by placing a beforeSend and complete in Ajax. //Método Salvar function salvar_operador() { var url; if (_metodo_salvar == 'novo') { url = "operador/novo"; } else { url =…
-
0
votes1
answer3935
viewsA: ORA-01704: too long string literal
It worked that way. DECLARE texto CLOB := '{"Entity":{"Version":2,"Name":"teste"},"General":{"IdCodeProfile":"teste","Description":"Descricao de…
-
1
votes1
answer3935
viewsQ: ORA-01704: too long string literal
I have a CLOB type field in the BD, but when I give an INSERT it returns me an error saying that exceeded the field size that is 4000 characters. Relatório de erros - Erro de SQL: ORA-01704: literal…
-
1
votes2
answers1086
viewsA: Compare two values with jquery
The second IF is replacing the first. Try changing to a ELSE or ELSE IF, like this: // bairro igual ao que está cadastrado if (id_bairro == bairrocadastrado) { $('.entregatotal').html("R$" +…
-
0
votes3
answers91
viewsA: Fetch the previous value of a php sql table?
You passing the ID you want on, you’d get the previous record. SELECT <CAMPO> FROM <TABELA> WHERE ID = (SELECT MAX(ID) FROM <TABELA> WHERE ID < <VALOR.ID>)…
-
1
votes4
answers59
viewsA: Click the div to open option
Change your JS to this: $(document).on('click', '.selectClick',function(event) { $('.select').slideDown('slow'); });
jqueryanswered Lucas Souza 170 -
0
votes3
answers604
viewsA: Dynamically Place Plot Value
Thus, when executing an event in the plot, it already calculates the value per plot. <input type="text" placeholder="Valor Total" id="total"> <input type="text" placeholder="Quantidade…
-
0
votes0
answers21
viewsQ: Connection cluster for MS SQL Server
I need to create a Connection Cluster for MS SQL Server. Here’s an example I performed in Mysql: var mysql = require('mysql'); var db_cluster_config = require('./dbMysqlUtils').cluster_config; var…
-
1
votes0
answers111
viewsQ: Web Service for multiple databases
I’m starting with Node.js and wanted to know if someone could give me a strength in the matter of making a Web Service for multiple databases. I already have a code developed for Mysql, I need to…