Posts by Chefe Druida • 1,086 points
187 posts
-
0
votes1
answer60
viewsQ: Error: string indices must be integers in loop
good evening, I’m needing to do a for a request based on an excel, with that I’m doing so: df1 = pd.read_excel('D:/repositorio/python/leitura.xls') count = 0 for y in df1['EAN']: data…
-
0
votes0
answers15
viewsQ: Sorting values in mui-datatable
I’m using the mui-datatables , someone can tell me how to adjust his ordination which apparently is organized only by the first digit of the value ?…
-
0
votes1
answer47
viewsQ: pdfmake__WEBPACK_IMPORTED_MODULE_16___default Reactjs error
When I start my project this returns the following error: TypeError: pdfmake__WEBPACK_IMPORTED_MODULE_16___default.a is not a constructor Follows information: Import: import _ from 'lodash'; import…
-
-1
votes1
answer79
viewsQ: Return of several CASE in a single line
How do I convert that return: In a single line: 548721 125 2 20836 20836 77821 77821 9999******9999 0 0 MASTERCARD 200 Cartao de Credito a Vista My query: SELECT CASE data_id WHEN 17 THEN data_value…
-
0
votes1
answer63
viewsQ: How to convert a function to view
Good afternoon, I have the following function: if object_id('dbo.batidas', 'TF') is null begin exec('create function dbo.batidas() returns @retorno table(T int) as begin return end'); end; go alter…
-
2
votes1
answer19
viewsQ: Converting columns into rows by concatenating the results
I have the following select : SELECT pedido, item FROM pedidos How do I get the result of it in columns and step to row concatenating with -? Example: Upshot pedido item 1 batata 1 arroz 1 feijão 1…
-
0
votes0
answers50
viewsQ: Slotmachine Jquery Dynamic
I have the following Slotmachine: Use the API <div> <div id="casino1" class="slotMachine" style="margin-left: -65px;"> <div class="slot slot1"></div> <div class="slot…
-
1
votes0
answers22
viewsQ: Remove the underside of Radialgauge
I have a gaugechart where it was mounted at an angle of 180º, but it continues to show the 360º, thus occupying an unnecessary space. How can I remove that part underneath the chart ? Follow…
-
1
votes3
answers428
viewsQ: Ctrl-Click Sublime Text on VS Code
In Sublime Text has a function where we hold the Ctrl and click on a text and it is selected. There is this function in VS Code? Here’s an example image where I selected 2 different texts in…
-
2
votes1
answer213
viewsQ: Columnchart not reverting colors of options google Charts
I am filling a Columnchart with the data brought from mysql, only that I would like to put the columns of different colors, more unsuccessfully. Shows the same color in both columns, as you can see…
-
4
votes1
answer221
viewsQ: Ionic with admob-free advertising displays only "Nice Job"
I created an application with Ionic version: 3.20.1 and set up with admobfree: cordova plugin add cordova-plugin-admob-free --save --variable ADMOB_APP_ID="ca-app-pub-XXXXXXXXXXXXXXXX/XXXXXXXXXX"…
-
1
votes1
answer126
viewsQ: Return of jquery autocomplete returning at top
I created a top complete with jquery, plus the return box is rising to the top of the page, as it could adjust? Follow image of example: Follow the code of the autocomplete: Test 01 <link…
-
0
votes1
answer341
viewsQ: Set timestamp field to accept value 0000-00-00 00:00:00
I’m in the wrong postgres, because a field that is timestamp this receiving value '0000-00-00 00:00:00', can tell me how to set up a field timestamp accept date and time reset ? Follows error:…
-
0
votes1
answer42
viewsQ: Save php parameter in vba variable
I have a form I step a parameter and at the same time open an Excel spreadsheet. Following example: <?php if (isset($_GET["param"]) && !empty($_GET["param"])) { $param = $_GET["param"];…
-
1
votes1
answer252
viewsQ: Split query result into columns
I have a select that brings items with prices, as I do to divide the result into two columns: Examples: I hope to leave it this way: Follow my code: <html> <head> <meta…
-
2
votes1
answer477
viewsQ: Error trying to add time field(varchar) sql server
I have a query that returns the following data: SELECT * FROM METAS mes lj saldo meta 4 2 153:59 123:00:00 4 2 25:33 00:00:00 4 2 29:57 08:00 4 2 38:58 45:00:00 4 2 94:47 20:00 4 2 23:41 15:00:00 4…
-
0
votes2
answers92
viewsQ: Merge query returns to be populated a combochart
I have 2 appointments in the bank: One returns the goals of the day until the last day of the month: DIA META 1 3,23 2 6,45 3 9,68 4 12,9 5 16,13 6 19,35 7 22,58 8 25,81 9 29,03 10 32,26 11 35,48 12…
-
7
votes1
answer1414
viewsQ: Make mysql query with INNER JOIN between different mysql servers
How could you make a query with INNER JOIN between different servers, as exemplified below: SELECT serverA.clinte AS CLIENTE, serverB.enderecoCliente AS ENDERECO FROM 127.0.0.1.dbo.cliente AS…
mysqlasked Chefe Druida 1,086 -
0
votes1
answer45
viewsQ: Calculate the total of a table column based on the checkbox by taking only the selected ones
I have the following table: <div class="table-responsive"> <form class="form-inline" action="registrosVazios.php" method="GET"> <table id="tabelaCupons" class="table table-condensed…
-
1
votes1
answer155
viewsQ: How to pass javascript return to php variable
I am passing the data of some inputs to a modal, I am doing this with jquery, until ai blza, more accurate the data that were sent and use them in a mysqli query, my doubt as I pass the values sent…
-
2
votes1
answer297
viewsQ: Data tables shrinking at start
I have 2 datatables on a page, only one of them is starting to shrink, as you can see in the image below. What I need to do to start properly? <!DOCTYPE html> <html lang="pt-br">…
-
0
votes1
answer43
viewsQ: Export fopen without ""
I’m using the fopen , to export the return of a select, it is exporting correctly, more in certain fields this appearing "" as I remove the "" of export, leaving only the , because it’s coming out…
-
0
votes1
answer72
viewsQ: Use a column as a header
I have a table in mysql of products, and need in select or php turns a column into header, example: cod produto valor pagina 123 caderno 1,00 pagina 1 456 lápis 1,00 pagina 1 789 borracha 1,00…
-
3
votes1
answer60
viewsQ: Export . csv with complement of lines based on a fixed number
I have a table in Mysql of products. I need to create an export . csv of them. The products are in the bank as follows: cod produto valor pagina 123 caderno 1,00 1 456 lápis 1,00 1 789 borracha 1,00…
-
0
votes2
answers80
viewsQ: Group of bootstrap Gird images staying out of loop
I have a list of images where I am using in grid to organize them getting the exact amount I need by lines. With this I made a loop to control the grids and I also have the loop of the images.…
-
2
votes1
answer87
viewsQ: Table with 2 td with select inputs showing return only in the first row
I have 1 table with 1 list of modules, and I have 2 columns that have options that can be chosen through select. The point is that the select’s only load the data in the first row of the table, the…
-
0
votes2
answers676
viewsQ: How to separate data from a GET request and insert into the mysql database with php
I have a form of questions with multiple questions, after the person answer has a save button that sends the answers and questions to the salva.php Follow the get (url): salva.php?…
-
2
votes1
answer168
viewsQ: How to take the events of a drag and move to php variables
I have this project below. In it I have a list of images where I can drag and bury as I need. So far it’s working properly the way I need it. I need to consider the position of the images as an…
-
1
votes1
answer70
viewsA: foreach returning non-existent empty data
Solution: <?php $StringPerguntaLoja = "SELECT * FROM sug_pergunta_fixa AS p left join sug_area as a ON a.sa_id = p.pf_area WHERE pf_status=0"; $QueryPerguntaLoja =…
-
-1
votes1
answer70
viewsQ: foreach returning non-existent empty data
I have the following form: <form class="form-horizontal" action="perguntas.php" method="GET"> <fieldset> <?php $StringPerguntaLoja = "SELECT * FROM sug_pergunta_fixa AS p inner join…
-
0
votes1
answer886
viewsQ: Error while restoring database using mysql folder
Good morning, I lost a hard drive where my databases were, but I have backup of the banks' folders. I took the briefcase from one of the banks and put it in: C: xampp mysql data And he appears…
-
0
votes1
answer123
viewsQ: Questions form with radio button returning empty displaying
Good night, I need to ask a question system (a question) just like this: https://jsfiddle.net/hmana2sL/ I just need the questions and the answer options to come from the bank. I tried this way only…
-
1
votes2
answers3449
viewsQ: Get only last query sql server record
I have the following query: SELECT CODIGO, DTINICIO AS INICIO, DTFINAL AS FINAL FROM PFHSTAFT WHERE EMPRESA =1 GROUP BY CODIGO, DTFINAL, DTINICIO It returns as follows: 0031 2000-11-06 00:00:00.000…
-
0
votes1
answer129
viewsA: How to concatenate the return of a query to a string from another mysql
Solution: delimiter | ALTER EVENT ExportaVersao ON SCHEDULE EVERY 5 SECOND COMMENT 'Exporta Versão do Sistema' DO BEGIN SET @sql_text = CONCAT ("SELECT * FROM SISTEMA into outfile…
-
0
votes1
answer129
viewsQ: How to concatenate the return of a query to a string from another mysql
I have the following query: SELECT id AS CODIGO, nome AS NOME, versao AS VERSAO, build AS BUILD, data AS DATA FROM sistema INTO OUTFILE 'D:/servicos/export/exportaVersao.csv' FIELDS TERMINATED BY…
-
2
votes1
answer63
viewsQ: Error trying to save txt
Everybody, good morning, everybody, I have this code pad: $delimitador = ';'; $cerca = '"'; $VarDataAux = ''; // Abrir arquivo para leitura $f = fopen($_FILES['arquivo']['tmp_name'], 'r'); if ($f) {…
-
0
votes1
answer32
viewsA: Help with condition to mount csv layout with php
Reply @-Kelver (from another community): ago $dataAuxiliar = ''; if($dataAuxiliar != $VarData){ faz o q tem q fazer.... } no fechamento do loop alimenta a $dataAuxiliar = $VarData;…
-
0
votes1
answer32
viewsQ: Help with condition to mount csv layout with php
I am generating a . CSV for an import where it is returning me the data as you can see in this gist: https://gist.github.com/otaciobarbosa/b1b442816ec95ff570d6d5c70e8b1f64 What happens is I have 2…
-
1
votes1
answer401
viewsA: Error trying to run the app with Ionic serves
Solved: npm install @ionic/app-scripts@latest --save-dev
-
0
votes1
answer401
viewsQ: Error trying to run the app with Ionic serves
When trying to run the app with Ionic serves this giving the following error: > ionic-hello-world@ ionic:serve D:\www\mobile\app > ionic-app-scripts serve "--v2" "undefined" "--address"…
-
1
votes1
answer252
viewsQ: Query mysql add day value to previous days
I have the following query: SELECT * FROM vw_total_diario WHERE pessoa ='Daniel' GROUP BY data; It returns as follows: 2017-05-02 Daniel 6 2017-05-03 Daniel 2 2017-05-04 Daniel 8 2017-05-05 Daniel 1…
mysqlasked Chefe Druida 1,086 -
1
votes1
answer93
viewsQ: Line Chart being populated only with last record only in while/php
Code: <!doctype html> <html> <head> <title>Line Chart</title> <script src="dist/Chart.bundle.js"></script> <script src="utils.js"></script>…
-
0
votes1
answer78
viewsQ: Error while creating php mysql line chart
I’m trying to make a line Chart with php and mysql like this : jsfiddle based on this tutorial. Only my chart only returns empty with undefined columns: The idea is to make a graph where it contains…
-
3
votes3
answers200
viewsQ: List columns according to current date
I have the following view: select * from chamdosrow It returns as follows: NOME 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31…
-
2
votes1
answer144
viewsQ: Mysql query grouping the results in the case
I have the following appointment: SELECT DAY(o.data_fechamento) AS DIA, u.nome AS TEC, COUNT(*) AS TOTAL FROM ocorrencias AS o LEFT JOIN sistemas AS a ON a.sis_id = o.sistema LEFT JOIN localizacao…
mysqlasked Chefe Druida 1,086 -
0
votes3
answers1157
viewsA: Get value from dynamically created fields
Try as follows, passing the name and id as it did with the value, example: episodio = 2; $(".addEpisodeField").click(function () { newField = $("#episodeField").append("<input type='text'…
-
0
votes1
answer626
viewsQ: When accessing with specific user he give an ssh on another server
I have 2 servers: Example: A and B. What I need: when I connect to the server A with a specific user it automatically make a ssh on the server B, if possible already sending login and password…
-
1
votes3
answers1405
viewsA: How to pass a PHP variable that is inside an "a" tag to be used inside a Modal?
How to pass values of PHP to the Javascript and vice versa? What cannot be ignored in the marriage of Javascript with PHP is that the two are running at different ends. The scripts of Javascript…
-
0
votes1
answer580
viewsA: How to generate code in an HTML form that does not yet exist
You can use the autocomplete of jquery ui and AJAX how I used here in my case You make a query in the bank bringing the return in a json, with that you could bring the very code you want. Follows an…
-
1
votes1
answer583
viewsA: Property forChild does not exist on type typeof Ionicmodule Ionic 2
Solution: Import the IonicPageModule instead of IonicModule Change of: imports: [ IonicModule.forChild(Login), ], To: imports: [ IonicPageModule.forChild(Login), ],…