Posts by maiconfriedel • 522 points
42 posts
-
0
votes0
answers19
viewsQ: Change application name in Electron notification
How do I change the name of the application that appears in the Windows 10 notification using Electron with React? I highlighted what I want to change with a red square. My notification is called…
-
2
votes1
answer27
viewsA: Hover of a select with javascript/jquery
You can use the attribute title HTML, which automatically is placed a tooltip with the text you put, which in the case is the same that you put in the value. for (let index = 0; index <…
-
-1
votes1
answer32
viewsQ: Case Sensitive attribute
Good afternoon, everyone! I have a class called Inventory that has the following attributes: import InventoryItem from "./InventoryItem"; import InventoryConfiguration from…
-
0
votes1
answer152
viewsQ: JSON Customized for Dataannotations - Asp.Net Core Web Api
Good afternoon! I have a Web API in . Net Core, where I have the following request class for a POST route: public class CreateAgentRequest { [Required] public Agent Agent { get; set; } } With…
-
6
votes2
answers191
viewsQ: Typescript - Incorrect code output - Date
Why the output from that code is: Pessoa { Id: 1, Name: 'Maicon Gabriel Friedel', DateOfBirth: 1997-02-22T03:00:00.000Z } Code: import pessoa from './pessoa' pessoa.Id = 1; pessoa.Name = 'Maicon…
-
1
votes1
answer281
viewsQ: Swagger Json in Postman does not put the API URL
I am using the Swagger library on . NET CORE in a Web API to generate the documentation, below is my startup.Cs: public class Startup { public Startup(IConfiguration configuration) { Configuration =…
-
0
votes1
answer324
viewsQ: IONIC - Grid Responsive
Good afternoon, I have the following GRID with IONIC, it’s like this: <ion-grid> <ion-row class="cell-2"> <ion-col> Código </ion-col> <ion-col> Nome </ion-col>…
-
1
votes1
answer31
viewsA: Removing duplicate values from an array
According to the php documentation, you can use the function array_unique. The first parameter is the array, and the second is SORT_FLAG (not required).. Below is an example: <?php $input =…
phpanswered maiconfriedel 522 -
0
votes1
answer71
viewsA: how to search for more than one column in php
Add the other columns in your while as well... you just specified the column of the name, so only the column name is appearing: while($rows_sql = mysqli_fetch_array($resultado_cemiterio,…
-
0
votes4
answers3071
viewsA: If condition in Where SQL Server
You can do it like this: if (@dataInicial is null) begin select * from tabela where campoTabela <= @datafim end else begin select * from tabela where data between @dataInicial and @datafim end…
-
0
votes1
answer56
viewsA: SELECT TO REDUCE SEVERAL SIMILAR MYSQL ENTRIES
You can use a substring with subselect to do this: SELECT DISTINCT X.NAME FROM ( SELECT h.HOST, substring(s.NAME,1, 25) AS NAME FROM hardware as h, softwares as s WHERE h.ID = s.HARDWARE_ID AND…
-
2
votes2
answers67
viewsA: How to compare 2 arrays to find which value is missing in one of them, using PHP
You can use the function array_diff(). $arraybd=array('1','2','3','4'); $arrayxml=array('1','2'); $result = array_diff($arrayxml, $arraybd); print_r($diferencas); //irá printar 3 e 4 According to…
-
2
votes3
answers458
viewsA: How to Update to Linq?
Assuming it has two attributes, name and age and you want to update them: [HttpPost, ActionName("Edit")] [ValidateAntiForgeryToken] public ActionResult EditConfirmed(int id) { Pessoas pessoas =…
-
0
votes2
answers1989
viewsA: How to pass data via get?
In this stretch here: <a href="categoria.php" name="categoria"> do so: <a href="categoria.php?categoria=<?php $prod['categoria']; ?> " name="categoria"> Let’s say you have a…
-
0
votes2
answers158
viewsA: Sum of fields completed within the SELECT itself
You can make a SUBSELECT as follows: SELECT SUM(X.horas_manutencao + X.horas_sistema) AS duracao FROM ( SELECT calcula_horas_manutencao({data_inicio_f}, {data_final}, contrato.id) as…
-
1
votes2
answers1789
viewsA: Division in the sqlserver
Joseph’s answer is correct, but complementing it can also be like this: declare @numero decimal(10,3) = 50; set @numero = @numero / 100; print @numero Already declaring the variable as decimal, also…
-
0
votes1
answer134
viewsA: Return Data from MYSQL (Data) to HTML Tables
You must use the function date_format when dealing with dates. For example, in the line you have: <td><?php echo $dados['NEW_DATA'] ?></td> should do so: <td><?php echo…
-
0
votes3
answers37
viewsA: Improving jquery code
Adds a unique ID to each of your elements, and in this function you take this id and add the class and remove it, depending on its ID. And all the elements you want that have this behavior need to…
-
0
votes1
answer140
viewsQ: How to display objects from a list?
I have the Personal class which has the following method: public List<Pessoa> BuscarTodos() { List<Pessoa> list = null; EntityManager em = getEM(); try { list = em.createQuery("select t…
-
2
votes1
answer635
viewsQ: C# - Multiple keys in JOIN LINQ Lambda Expressions
I have an SQL as follows: SELECT * FROM KY_AR_SOLICITACAO A JOIN KY_AR_SOLICITACAO_ITEM B ON A.NF_ENTRADA = B.NF_ENTRADA AND A.SERIE_NF_ENTRADA = B.SERIE_NF_ENTRADA AND A.NOME_CLIFOR = B.NOME_CLIFOR…
-
0
votes2
answers29
viewsQ: Jquery - Tooggle Panels
I need help with Jquery below... I need each <div id="flip"></div> inside each <div id="conteudo"></div> show the <div id="panel">Hello world!</div>. However, the…
-
2
votes1
answer97
viewsQ: Jquery Pick Value Nearest Checkbox by Line
I need help with the following: I want to take the checkbox that is disabled and play on console 0 for what is disabled, and 1 for what is enabled. My source looks like this: (Asp.net mvc) @model…
-
0
votes0
answers41
viewsQ: Doubt - Send Ajax at Checkbox Click (Performance, Network)
I have a table in a view, which lists the modules, with each module and each user, and a checkbox that indicates whether or not the user has access to the module, and I want in the action of…
-
2
votes2
answers91
viewsA: System.Nullreferenceexception sending Form Asp.Net MVC
According to the Barbetta commented, I changed the AFFILIATE property in the AFFILIATE class to NOME_FILIAL, this time working public class Filial { [DisplayName("Filial")] public string nome_filial…
-
-1
votes2
answers91
viewsQ: System.Nullreferenceexception sending Form Asp.Net MVC
I have an edit controller, which receives a value from the bank and plays for view, and then I want with this view to play the values on the screen (basic test)... However, even with my controller…
-
0
votes2
answers63
viewsA: HTML view of the field
<input asp-for="TICMS" name="TICMS" onKeyPress="return(MascaraMoeda(this,'.',',',event))" class="form-control" type="hidden"/> Puts him as type="hidden", so the user will not see it, but will…
htmlanswered maiconfriedel 522 -
0
votes1
answer149
viewsA: Close Dropdown submenus when closing the Main Dropdown
I was able to do it this way: In my <ul class="dropdown-menu">, apart from the main, I added the child class: <ul class="dropdown-menu filho"> and on my main dropdown button <button…
-
0
votes1
answer149
viewsQ: Close Dropdown submenus when closing the Main Dropdown
$(document).ready(function(){ $('.dropdown-submenu a.sub').on("click", function(e){ $(this).next('ul').toggle(); e.stopPropagation(); e.preventDefault(); }); }); .dropdown-submenu { position:…
-
0
votes1
answer20
viewsQ: Data sent to Model Clean when changing Page?
A question that came to me now, based on this post: Building Customizable ASP.NET MVC Menu If I popular my model of Menuitem when the user logs in, it will popular, for example, with the following…
-
1
votes1
answer430
viewsA: SQL Query with multiple arguments
If it is SQL SERVER, it can be done like this: SELECT * FROM NOME_DA_TABELA WHERE LTRIM(RTRIM(NOME))+LTRIM(RTRIM(CIDADE))+LTRIM(RTRIM(PROFISSÃO)) LIKE '%JoãoGoiânia%' SELECT * FROM NOME_DA_TABELA…
-
2
votes3
answers529
viewsA: Difference between dates in months with decimal return
It’s not exact, but it comes close to what you want: SELECT CONVERT(VARCHAR(10), GETDATE(), 112), '20180222', CAST(DATEDIFF(DD, '20180222', CONVERT(VARCHAR(10), GETDATE(), 112)) AS numeric(14,2)) /…
-
1
votes2
answers85
viewsA: Dropdownlistfor with Viewbag and Dictonary returning null value
Try as follows: Creates a class called Company public string codigo_empresa{ get; set; } public string nome_empresa{ get; set; } And just below the next: public List<Empresas> ListaEmpresas(){…
-
1
votes1
answer924
viewsQ: Password Encryption Question - SQL Server
I am developing an ASP.NET MVC system, SQL Server database, which will have logins control, and to encrypt the password, I have developed the following functions and procedures: CREATE FUNCTION…
-
0
votes1
answer674
viewsA: ASP.NET MVC Pagedlistpager pagination with more than one parameter
I’ve already done it. I was specifying the Action wrong. The right would be: @Html.PagedListPager(Model, page => Url.Action("VisualizaPorSetor","Pessoa", new {pagina = page}) + "&setor=" +…
-
1
votes1
answer674
viewsQ: ASP.NET MVC Pagedlistpager pagination with more than one parameter
I have the following page using x.Pagedlist @using AspNet.Models; @using X.PagedList.Mvc @{ ViewBag.Title = "Visualiza"; @model X.PagedList.IPagedList<AspNet.Models.Pessoa> } <h2>Pessoas…
-
0
votes2
answers379
viewsQ: SQL connection with PHP does not find the Drivers
I have the following PHP: <?php class Conexao { private static $connection; private function __construct(){} public static function getConnection() { $pdoConfig = DB_DRIVER . ":". "Server=" .…
-
0
votes1
answer42
viewsQ: SQL connection to PHP
I have the following PHP, I am using WAMP, and as in the image below, dll’s are active: <?php $server = "dblinx"; $connection = array("Database"=>"Linx", "UID"=>"root","PWD"=>"root");…
-
1
votes1
answer142
viewsQ: Doubt to add values with for in Javascript
Guys, I have the following PHP/HTML page: <?php include_once("conexao.php"); ?> <!DOCTYPE html> <html> <head> <meta http-equiv="X-UA-Compatible"…
-
0
votes2
answers527
viewsQ: Upload Images does not work PHP
I have the following page in PHP: <?php session_start(); ?> <!DOCTYPE html> <html> <head> <title>Cadastro de Operacional</title> <meta charset="utf-8">…
-
1
votes3
answers200
viewsQ: Select bringing maximum Columns with Writing - MYSQL
Guys, I have the following structure in a Mysql table: https://prnt.sc/k0d0ev I need to make a select that brings me as many posts as there are any records, for example, in reference 269 bring me to…
-
0
votes1
answer89
viewsQ: Special Character appears in Lowercase - PHP
I have the following PHP page: <?php session_start(); ?> <!DOCTYPE html> <html lang="pt-br"> <head> <title>Consulta de OP's por OP</title> <meta…
-
0
votes0
answers46
viewsQ: Page title does not appear PHP
Guys, I have the following PHP page: <?php session_start(); include_once("navbar_op.php"); ?> <!DOCTYPE html> <html lang="pt-br"> <head> <title>Consulta de OP's por…