Posts by Gabriel Oliveira • 407 points
9 posts
-
0
votes2
answers59
viewsA: Average between select results
You can use the function AVG in the column to calculate the average: SELECT avg(CONVERT(DECIMAL(10,2), ROUND(DATEDIFF(SECOND, OS.MAQPAR, OS.MAQFUN)/3600.0, 2))) AS TEMPO_REPARO FROM…
-
2
votes2
answers709
viewsA: HOW TO APPLY A BACKGROUND COLOR TO AN ANGULAR COMPONENT?
The tag <body> exists in angular yes. When you create a new project, inside the folder src some files are created: And inside the archive index.html Voce will find the html base code with the…
angularanswered Gabriel Oliveira 407 -
4
votes3
answers118
viewsA: Why doesn’t my program display the output values?
The problem with your code is that the variable idade of function imprimirresultado does not exist in the context of the function, to solve I added a return in the function that calculates age and…
javascriptanswered Gabriel Oliveira 407 -
4
votes2
answers68
viewsA: Doubts about HTML and CSS
You can use the tag <a> with a href containing the link to your page, thus: <a href="fb.com/seu_perfil"> <img src="seu_icone_aqui"> </a>…
-
6
votes2
answers1334
viewsQ: SQL decimal field size
I am making a form, and in the database documentation there are some numerical fields that are divided into 2 parameters. Ex: Field: Cost Type: NUMERIC Tam.: (12,4) What does this size divide and…
-
3
votes0
answers59
viewsQ: ASP.NETX conditional onkeydown event
I have an ASP form with 2 Divs with some fields to fill in, but there is a flag in the user’s profile that can or cannot hide one of them protected void Page_Load(object sender, EventArgs e) {…
-
2
votes3
answers291
viewsQ: Asp:Textbox type="date" is not completed
I am creating a form in Asp where a asp:Textbox should load the expiry date of a product, which should be filled in page_load() with the database data, and be free to change if necessary The problem…
-
1
votes1
answer338
viewsA: Join with various conditions
You can use the WHERE clause for condition: select * from tabela1 a, tabela2 b WHERE a.Numero_tel_dest = b.Numero_tel_dest AND a.Numero_tel_origem = b.Numero_tel_origem…
-
3
votes1
answer57
viewsA: Cannot implicity Convert type int to string?
I believe you are trying to concatenate an int with a string label_nome.Text = "Funcionario" + num_funcionario.ToString(); that should solve
c#answered Gabriel Oliveira 407