Posts by Marcos ACR • 386 points
18 posts
-
1
votes1
answer25
viewsA: Problem when inserting new row in table
First you don’t need to put addeventlistener inside a function, this way you would do so: Using string template document.querySelector('#includeRow').addEventListener('click', function(){ var…
-
2
votes2
answers57
viewsA: How to get all <ul> elements using Document.querySelectorAll() - Javascript
You are only getting the UL, so you need to select the LI within the UL: function TrocaLataPrincipal(){ const pepsiPrincipal = document.querySelector(".pepsi") const lataPepsi =…
-
-1
votes1
answer88
viewsA: How to group data by time interval?
You can use the function filter (this way will return only when the comparison is True) or forEach (traverse the Array one time and you do the validation inside it) var object = [ { horario:…
-
0
votes1
answer33
viewsA: Use Javascript condition for mathematical operations
Use If inside Function, not IF to condition which Function will be. function calcular() { var num1 = Number(document.getElementById("num1").value); var elemResult =…
-
0
votes1
answer294
viewsA: Identify the end of the page in the scroll?
I think if you add this code to check the end of the page, it will be better: Replace the console.log with your ajax code var timer = null; window.addEventListener('scroll', function () { const…
-
0
votes2
answers63
viewsA: how Function would look to enable several checkboxes from a Radio type
First you should change the radio button Ids: For Yes and No <label>Possui rede social: </label> <input type="radio" name ="social" id="Sim" > Sim <input type="radio"…
-
1
votes1
answer58
viewsA: Doubt about SQL - Group by (beginner)
I believe that if you add CRM in group by it will already divide according to Cor and CRM Select a.TabAtendimentoSaida->TabMedicoId->TabPrestador->Codigo as CRM,…
-
4
votes1
answer40
viewsA: Problem with basic javascript
You need to set the value measure (PX, PT...) <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <title>Document</title> </head> <body>…
-
2
votes2
answers62
viewsA: Get value by taking into account two columns
Provide the data in column "H". But I believe this way it works: =CONT.SES(Gestão!B3:B1000; "Compras";Gestão!H3:H1000; "X")
excelanswered Marcos ACR 386 -
1
votes1
answer70
viewsA: Video audio continues after closed the popup that contained it
I think if you do a fuction on the close button of the type: // When the user clicks on <span> (x), close the modal span.onclick = function () { modal.style.display = "none"; var mVideo =…
-
0
votes2
answers413
viewsA: SQL Server - calculate number of word occurrences in a column, per record
Try if you only want to count the amount of records that have the word 'Rio' ever, that is, when there are 2 times in my Row will count only one: declare @palavra varchar(30), @result int select…
-
1
votes1
answer45
viewsA: INNER JOIN is not showing two rows in the table
Apparently these lines do not have the same value. In Inner Join it is shown only when there is the same Key in both tables:…
sqlanswered Marcos ACR 386 -
0
votes2
answers103
viewsA: Insert value in Table Y for all existing Table X Ids
select CONTAS_ID into PREMIO from CONTAS When we use INTO we play all results to the informed table.
-
2
votes1
answer60
viewsQ: Error with another bank’s Foreign key
I’m trying to put Foreign key related to tables from another database (I’m performing tests and sometimes I need to delete the main database). However it presents the following errors: Message 1763,…
-
1
votes1
answer48
viewsA: Add values with different codes
use the case, in the source field: In the end it would be ideal to do a group by DESCRICAO, but in my tests did not work. SELECT Month(d.[doacao_sdt_data]) AS MES, Year(d.[doacao_sdt_data]) AS Ano,…
-
0
votes2
answers55
viewsQ: Use Relative Form in Usercontrol
I’m trying to create a Usercontrol so you can call different Forms, however changing only the controls he make the call. Shows the error that the "Form" is non-existent. public partial class…
-
1
votes1
answer236
viewsA: Instantiating form to lock button
Just create in btn to open the password request: DialogResult resultado = new DialogResult(); Form1 f = new Form1(); resultado = f.ShowDialog(); if (resultado == DialogResult.OK)…
-
0
votes1
answer50
viewsQ: Select to show clients that are not in another table
What is the correct way to present my client table with the following clauses: Be more than 60 days without purchase, not in the Links table or have more than 20 days since the last call. Fields…