Posts by Afuro Terumi • 231 points
22 posts
-
-1
votes2
answers51
viewsQ: How to check if a character set exists in the table column?
I have the following table: |id|nome | |1 |Lucas Santos da Silva| |2 |Igor Julião Gonçalves| |3 |Mário Marques Silva | |4 |David Silva | How could I catch all the people who have Silva in the name?…
-
3
votes2
answers53
viewsQ: Process command line arguments
Hello, I’m trying to work with command line argument process, I’ll show you an example command line I’m using: user@notebook$ python arquivo.py -nome Lucas --idade 12 --pais Brasil Code: import sys…
pythonasked Afuro Terumi 231 -
0
votes1
answer66
viewsA: Working with a python dictionary
I found the function that checks whether the character is or is not string, so I used the isalpha(), my departure was identical to the required exit from the URI, but the question remains with Wrong…
-
-1
votes1
answer66
viewsQ: Working with a python dictionary
I’m trying to resolve an issue in the URI, I’m going to put the description of the issue, and the link, whatever you prefer. Link: https://www.urionlinejudge.com.br/judge/pt/problems/view/1215 Andy…
-
1
votes1
answer337
viewsQ: How to fix Time limit exceeded error
I was trying to solve this issue in URI and I managed to reach the output required by URI. However I got the error Time limit exceeded, because the running time limit is 2s, and my code resulted in…
-
2
votes1
answer110
viewsQ: Format difference between two dates
I calculated the period between two dates in the format d H : M : S, and now I’m trying to format it, but I still can’t, follow an example of what I want to, and my code: ENTRADA Dia 5 08 : 12 : 23…
-
1
votes1
answer241
viewsQ: Runtime error in python 3.8 - URI
I’m practicing some examples in the URI Online Judge and I’ve come up with this example: And I tried the following solution: numeros = input().split(); N1, N2, N3, N4 = float(numeros[0]),…
-
0
votes1
answer475
viewsQ: Date filter in a table with javascript
Notice now that for my question, I will use only focused data for the problem, without having to put all the fields of a table and the whole HTML body. It took me a long time to elaborate on this…
-
0
votes0
answers24
viewsQ: Union of more than one table
In my database there are two tables: cde_usuario cde_venda_detail I will begin to introduce a part of Notifications system. The record must have some column indicating whether the notification has…
-
0
votes2
answers503
viewsQ: Validate password confirmation
I have two inputs within my form: Password and Confirm Password Before the user submit the form, I would like to compare the value of the two inputs. If they are equal, send the form normally. If…
-
0
votes1
answer110
viewsQ: Add "required" attribute after change in "select"
In my system, there are three types of users: General Manager; administrator; and Client. The Client does not have access to the system, therefore, it does not need password and would not be…
javascriptasked Afuro Terumi 231 -
-1
votes1
answer123
viewsQ: I can’t start Xampp
While trying to start Mysql in xampp as usual, this error occurred: Error: MySQL shutdown unexpectedly. 14:04:23 [mysql] This may be due to a blocked port, missing dependencies, 14:04:23 [mysql]…
-
1
votes1
answer65
viewsQ: Format money value from database
I have an input with a mask where the user type the desired price and automatically is formatted. Before sending to the database, I transform this value so I can work with it with some arithmetic…
-
2
votes1
answer39
viewsQ: Correcting Error Nan
Where is wrong to generate this error? I believe it is in var preco = $(this).next("input.preco").val(); as it replaces the Number(preco) for Number(qtde) works, but I need you to be the…
-
0
votes2
answers148
viewsQ: Immediate sum within input - Javascript
I have a sales system, where the administrator marks the checkbox of the products that want to sell, soon after appears an input to enter the desired quantity, and at the end of the sale, is…
-
-1
votes1
answer37
viewsQ: Add values from a column in the table
I need to select the 3 users with the highest revenue. Before in the table cde_usuario there was a column called scythe, being very simple to make this query, used this sql: $sql = "SELECT * FROM…
-
4
votes1
answer93
viewsQ: Limit number on an input - 2nd doubt
My goal in a previous post was to put a maximum and minimum value in a text field, a user solved it almost perfectly. Let’s use as an example at most the number 37: function checa(e){ const mi =…
-
0
votes2
answers67
viewsA: Limit number on an input
What if the maximum value is 10, and I need to type, for example: the number 6? I cannot. function checa(e){ const mi = +e.min; const ma = +e.max; const va = e.value; if(va < mi){ e.value = mi;…
-
0
votes1
answer274
viewsQ: Show input when checking checkbox
I would like that when I check the checkbox, the input in front of you becomes visible, I found a function that partially solved the problem: //capturando evento de click e touch(mobile) em todos os…
-
0
votes2
answers67
viewsQ: Limit number on an input
I would like to know how to limit the maximum number entered in an input. For example: I want the largest number that can be typed to be 42, that is, if the user tries to type 43: either it would…
-
0
votes5
answers79
viewsA: SQL using two tables
I managed to solve, I did so: $sql = "SELECT * FROM solicitacoes_solicitacao as so WHERE (SELECT COUNT(*) FROM solicitacoes_tarefas as ta WHERE ta.dataconclusao = 0000-00-00 and ta.id_evento = 0 and…
-
2
votes5
answers79
viewsQ: SQL using two tables
I need to select all records from the table solicitation where all the table records tasks that have in the column id_solicitation the id concerning that request, and date of completion are…