Posts by Neoelectronics • 99 points
9 posts
-
0
votes1
answer32
viewsQ: sum values in subquery by field
Good morning, I’m trying to solve this but I can’t, in this select he has a field called emprestimo_id. I need to sum the remaining amount of each loan into one subquery calling for "remainder", but…
mysqlasked Neoelectronics 99 -
0
votes0
answers251
viewsQ: Create Bootstrap Paging Links using Ajax
$.ajax({ type: "POST", url: "php/crud.php", dataType: "json", data: {qtd_registros: 3, pagina: 1}, success:function(dados){ var paginacao = '<nav><ul class="pagination…
-
-1
votes1
answer94
viewsQ: Empty function inside another to run script from another file
I have a file called funcoes.js and another one called eventos.js need the script that is written inside events.js to be executed inside functions.js in another function, but in the order that it is…
-
0
votes1
answer533
viewsQ: Create variable with other variable content
I need to create a variable but its name has to be the content of another already created. Example: var nome = "teste"; Now using the value of the name variable that is "test" need to automatically…
-
1
votes2
answers63
viewsQ: function to use query data
I am building a function that via ajax queries a query in the database and via json returns the result. But everything works but I can’t use the json object anywhere else except within the function.…
-
0
votes0
answers364
viewsQ: Traverse all strings by delimiter in the field and generate a column with the result
SET @contador := 0; SELECT SUBSTRING_INDEX( SUBSTRING_INDEX("BOX 01;BOX 02;BOX 03;BOX 04;BOX 05;BOX 06;BOX 07;BOX 08;BOX 09;BOX 10;BOX 11;BOX 12;BOX 13;BOX 14;BOX 15;BOX 16;BOX 17;BOX 18;BOX 19;BOX…
-
-2
votes1
answer57
viewsQ: Need to manage a text field with separate values ;
I need to insert, edit, delete a text field in this format: 11 2222-3333;11 3333-4444;11 5555-6666;11 7777-8888 In case I need a zebrad grid that lists the data and on each line has this information…
-
2
votes3
answers104
viewsQ: I need to list a text field with values separated by ;
I have a field text that is being inserted in the same phones in that format: 11 2222-3333;12 9 1111-2222;18 1111-2222;11 2222-3333 And I need to list these fields as a simple select in line and…
-
5
votes2
answers18687
viewsQ: How to add values of a field grouped by date?
SELECT funcionario_id, data, avaliacao_postura FROM equipe id funcionario_id data avaliacao_postura 1 1 2014-03-02 -25;-10;-5;-12 2 1 2014-03-01 -25;-10;-18 3 1 2014-03-02 -25;-15;-14 I need to make…