Posts by Eduardo Bissi • 424 points
21 posts
-
1
votes1
answer57
viewsA: Postgresql: How to select a field based on the maximum value of another field?
Option 1: Sub-consultation Do a subconsultation using the values found in the first: SELECT codigo_requerimento, MIN(data_baixa) as primeira_baixa, MAX(data_baixa) as ultima_baixa, (SELECT…
-
0
votes1
answer30
viewsA: Create php array, saving how many times a string appears
Lucas, your code is practically ready, I just needed to order the array. I made the following modifications: $nomestr does not exist, replaced by $nome_das_maquinas_str Replace the numeric index $i…
-
1
votes1
answer38
viewsA: responsive circumferences in specific places
Solution: First, put #img-1 with position:relative or the percentages will apply with respect to the first element that does not have position:static. In this snippet is the html, so only on…
-
1
votes1
answer34
viewsA: circumference on top of an image
Solution: Place position: relative in the div containing the div circle. Motive: The position works with respect to an ancestral element that has not position: static (which is the standard). In the…
-
1
votes1
answer22
viewsA: Value calculation and result print in cells on the right
The way you nestled these For Each causes your program to have this behavior. For each input cell your program all the output cells making the Select Case with the current entry, so keep the last in…
-
0
votes1
answer31
viewsA: Because VBA returns #value error
To documentation of the function leaves to be desired by informing that it returns a Variant when in fact it returns a Array de Variant. You can check this by using the Vartype. In my tests, even…
-
0
votes2
answers63
viewsA: Error in printing C numbers
It’s not just duplicated, your code prints the same value k times, in the following passage: for(int l = 0; l < k; l++) { printf("%d ", vetor[r]); } To fix, use modular logic, thus: for(int r =…
canswered Eduardo Bissi 424 -
0
votes1
answer49
viewsA: Error when reading some words using percentage wildcard character (%)
The behavior is caused by find. In the code it uses the function parse_str (source). In the function manual it has the following description: Converts str as if it had been passed via URL ... This…
-
1
votes2
answers92
viewsA: Empty Space in PHP String Explode
Weverton, make it easy, make it 2 explodes: the first with 3 spaces as separator (which will divide the message into words) and a second explodes with 1 space as separator (which will divide the…
-
0
votes4
answers109
viewsA: Define the lowest and highest value among three numbers
If I understand your problem from your comments is that your program only displays the largest or only the smallest and not both at the same time. This is due to the fact that when using if with…
-
1
votes1
answer74
viewsA: Problem to get Hidden Input values in PHP
Thauan, $_POST['auth'] only comes into existence after you first click on one of the two buttons (send the form). The first time you open the page it doesn’t exist and gives the alert. If you sent…
phpanswered Eduardo Bissi 424 -
0
votes1
answer25
viewsA: VBA - Error checking cell value
In fact the error itself is already talking: "Incompatible types". This means that the program cannot compare the two values to check if they are equal and also cannot convert one value from one…
-
1
votes2
answers49
viewsA: Result of the same account is different in VB and C#
Natan, in the case of C# its casting applied only to (1 << 19), while in VB.net the conversion applied to the entire account after splitting. Replace the C#code by adding parentheses for the…
-
1
votes1
answer72
viewsA: While doesn’t display if I use get id?
Vinicius, Like when you remove the condition WHERE id='$vide' are displayed all genres I believe the "problem" is in the parameter i. By your comments and variable name ($vide) I believe you’re…
-
1
votes1
answer32
viewsA: How to create a function that deletes all spaces before and after the phrase starts in a string
Bernard a first apparent error is the comparison using only a sign of =. The condition if(a=1) always returns true, and that’s where you copy the character, so the return is equal. I did another…
-
0
votes1
answer66
viewsA: How to join the select of these 3 tables that have no connection at all?
I suggest doing something like this: First, make each of the 3 SELECT contains all result columns (columns that are not relevant, complete with zero) and columns of the same type and name. Example:…
-
2
votes1
answer33
viewsA: Error in Javascript parseint value with very large number
According to Javascript.info, the guy number cannot correctly represent integers larger than 2^53-1, or 9,007,199,254,740,991. Comparing: 9007199254740991 36428971654192132 Try to use Bigint:…
javascriptanswered Eduardo Bissi 424 -
1
votes2
answers49
viewsA: How to reload a page without losing inputfile
William, if I understand what you want to do, create 2 separate forms on the same page: one to send XML and the other to the fruit Submit. Each with its own upload button. Thus, in the first…
inputanswered Eduardo Bissi 424 -
1
votes2
answers420
viewsA: Encrypt bank passwords in the conf file
Gomes, I had similar doubts when I was setting up my site/server. Even if we encrypt the configuration file, elsewhere in our php we would have to put the password to access the file. The safety…
phpanswered Eduardo Bissi 424 -
0
votes1
answer160
viewsA: Visual Basic 6.0
You are inserting twice because there are two instructions in your code that execute the SQL command: rs.Open SQL, cn, adOpenKeyset, adLockReadOnly and cn.Execute SQL No need to create an object…
-
2
votes3
answers421
viewsA: Query with conditions in SQL SERVER
You can use a "Self Join" to filter posts where the author of the post is equal to the author of the parent post: SELECT pFilho.id_postagem, pFilho.titulo, a.nome FROM postagem pFilho INNER JOIN…