Posts by HudsonPH • 2,492 points
108 posts
-
1
votes1
answer40
viewsA: Insert using time table only at values that do not exist in the main table
Correction of your query, use where EXISTS: insert into solicitacao_materiais(codigo_material,quantidade_estoque,descricao_material,almoxarifado_relacionamento_id) select…
postgresqlanswered HudsonPH 2,492 -
0
votes2
answers74
viewsA: Select to Alias
In postgresql the alias 'and in this format: select (select dia_da_semana from ano where dia = 1 and mes = 10) as 1 but would probably return you an error if you have more than one value, pq would…
-
2
votes1
answer60
viewsA: View linked ID of a duplicate mysql record
You can use the GROUP_CONCAT. In the query below will return duplicate names, next to a list of id concatenated: select count(nome_f), nome_F, GROUP_CONCAT(id) from comerciantes group by nome_f…
-
1
votes2
answers122
viewsA: Is using the Mariadb JSON type a good one for saving primary keys?
The correct is to have a table that makes the relationship between passengers and travel, functional example: CREATE TABLE IF NOT EXISTS passageiro( _id INT AUTO_INCREMENT, nome VARCHAR(255) NOT…
-
0
votes1
answer253
viewsA: Drag and drop + Scroll
Your jsfindle is working, the only problem is that you have not put any event to show that drag and drop works visually. I believe you need something like this: $('.item').draggable({ cursor:…
-
1
votes3
answers1214
viewsA: Input date ta in English
In your example you are using the French version bootstrap-datetimepicker.fr.js Then you need to change this link to: <script…
-
3
votes2
answers1356
viewsA: Bootstrap Datepicker doesn’t work?
Possible problems: forgot to put jquery, put jquery in wrong order, missing css reference. Functional example: $( "#datepicker" ).datepicker({ format: "dd/mm/yyyy", language: "pt-BR" }); <script…
-
1
votes1
answer105
viewsA: Conceptual error about functions in C++!
the problem is on that line: double sqrtChi; the correct would be : double sqrtChi = 0; if you do not instate object the second call your function will reuse the first added value. A second option…
-
2
votes1
answer220
viewsA: Submenu Bootstrap in Jquery for Typescript
I tested, the problems and their corrections: var $subMenu = this.nextElementSibling(".dropdown-menu"); for var $subMenu = this.nextElementSibling;…
-
2
votes3
answers356
viewsA: insert into the dictionary
a small change var dict = {}; dict.chave ="valor"; console.log(dict);…
-
3
votes1
answer77
viewsA: Can you create variable in git?
to save you can use: declare nomedavariavel=c/ocaminho... and to use the variable use $+the variable: cd $nomedavariavel
-
3
votes2
answers478
viewsA: Styles of my Datatable does not load in modal
Missed some files like jquery.js, boostrap.js and bootstrap.css, and missed calling the function that generates the table: $("#bootgrid-command").bootgrid(); $("#bootgrid-command").bootgrid();…
-
0
votes2
answers90
viewsA: How can I Create a column in SQL SERVER where, depending on the value, debt or credit appears?
This can be solved in c#: valor > 0? "Crédito" : "Débito" and that "Credit/Debit" column in the database is not necessary because it is redundant, unless you have positive debit and negative…
-
2
votes1
answer663
viewsA: Check if the driver has a public constructor without parameters
May be one of the following options: Your service makes use of other interfaces that have not been injected Your service has no constructor More: your method of Injection is wrong…
-
0
votes2
answers172
viewsA: Sweetalert Does Not Return False
Your sweetalert has no problem. function verificaCamposDadosEstudante () { var endereco_aluno = $("#endereco-aluno").val(); var bairro_aluno = $("#bairro-aluno").val(); if (endereco_aluno == '') {…
-
0
votes1
answer459
viewsA: Entity Framework Migrations on an already installed system, how to run?
If you use Migration: So your first steps are: Add-Migration primeiroExec update-database when Voce generates or changes some model then you will redo the same process: Add-Migration…
-
2
votes3
answers699
viewsA: How can I use the function href="#"?
href="#pularpara" and your div with id related to href id="pularpara" <a href="#pularpara">clique aqui para pular...</a> <div style="height:5000px">Nada</div> <h1…
-
2
votes1
answer139
viewsA: Recover Select from Any Trigger
You can use Sqltabledependency: using System; using TableDependency.SqlClient; using TableDependency.SqlClient.Base.EventArgs; namespace RealTimeUpdate { public class Customer { public int Id { get;…
-
1
votes1
answer103
viewsA: Populate an html with list jquery
You need to use .append() example of use: var data = [{Nome:"test", Foto: "foto1"},{Nome:"test2", Foto: "foto2"},{Nome:"test3", Foto: "foto3"}]; var rows = ""; $(data).each(function (i, item) { rows…
-
0
votes2
answers85
viewsA: Link tag on Html5 in the wrong place on bootstrap
in the first a swap for div I believe that’s what you want: function disableLinks() { $("div").addClass("disabled"); } function showSpinners(arg){ $(arg).collapse() $("div").collapse('hide') }…
-
0
votes3
answers77
viewsA: Help to reduce Javascript code
if you want to turn it: "GABRIEL gUIDETti" in "Gabriel Guidetti" you can do so on a single line: console.log("GABRIEL gUIDETti".toLowerCase().replace(/\b[a-z]/g, function(letra) { return…
javascriptanswered HudsonPH 2,492 -
9
votes4
answers1103
viewsA: What is the Kubernetes?
What is the purpose and benefit of using this tool? Agile application creation and deployment: Greater ease and efficiency of container image creation compared to the use of VM images. Continuous…
-
2
votes1
answer216
viewsA: Type of Android kernel
Android uses the linux kernel (but has its own branch), and the linux kernel 'and monolithic. Example of Android manure: And a comparison of kernel types:…
-
1
votes1
answer60
viewsA: How to make Image Edge below?
HTML 4 and 5 Voce can use <legend>: <form> <fieldset> <legend>Exemplo:</legend> <input type="radio" id="A" name="rdo"> <label…
-
1
votes1
answer773
viewsA: How to map two LIST properties using the Automapper
Using Automapper: Mapper.Initialize(cfg => cfg.CreateMap<PessoaContatoViewModel, PessoaContato>()); List<PessoaContato> contato = Mapper.Map<List<PessoaContatoViewModel>,…
-
0
votes3
answers204
viewsA: Update app.config or web.config via code
Looking semantically, it is incorrect to use this approach? Yes and very wrong, mainly the amount that Voce wants to store the file only supports up to…
-
2
votes3
answers78
viewsA: How to style classes initiated with . fa-?
Wouldn’t it be but handy if you create a secudaria class with the color you want? so you can do reuse without having to redo the css of the fontawesome. .fa-vermelho{ color: #ff0000; } <link…
-
1
votes2
answers795
viewsA: asynchronous foreach in javascript
what was missing was the await in the freight of fetch example: async function generateWishlist() { var products = []; var productLength = 0; var lista = [1,2,3,4,5,6,7,8,9,10]; for (i = 0; i <…
-
1
votes3
answers566
viewsA: How does Python handle and represent an array internally?
How an array is represented internally in Python? Array is represented as a list in python. there is the library of array example: from array import * x = array('i', [10,20,30,40,50]) print(type(x))…
-
1
votes2
answers130
viewsA: How does the interpretation of HTML code work?
You mixed a lot of things in your question: "HTML code", the correct is HTML documentation. compilers interpret lexemas and not documentation! About the question itself, it needs to be closed or…
-
6
votes2
answers128
viewsA: Adjust the value of cents
Just do that: var n = 100.3; n=n.toString().replace(".",".0"); console.log(n);…
-
1
votes2
answers1507
viewsA: How to update a password in MYSQL and encrypt it
Same logic as the register: just use your encryption function password_hash(string, string) before sending: $dados['senha'] = password_hash($dados['senha'], PASSWORD_DEFAULT);…
-
0
votes1
answer105
viewsA: Autocomplete not working - Asp . net MVC
change that part: function (data) { response($.map(data, function (item) { return { label: item.Label, value: item.Value } })) for: function (data) { $.map(data, function (item) { return { label:…
-
0
votes2
answers158
viewsA: create a bat file
only need to open cmd with the /C command, everything after the /c is copied to console. example: start cmd /C ping 10.0.0.1 -t
-
4
votes2
answers431
viewsA: What is the difference between "Css Resolution" and "Pixel Resolution"
This refers to the quality of the image or web on your mobile phone, in the S8 Ration is 4 pixel hardware per CSS pixel, 360x740 * 4 = 1440x2960 in CSS would look like this: @media…
-
1
votes2
answers53
viewsA: Library import
Advantage would be the final result in size and loading. Example when you matter ceil and sqrt, va will generate only these packages, case use the * will matter the entire library(not always depends…
-
4
votes1
answer1434
viewsA: How to execute a command in CMD or Powershell, passing the commands via C#?
C# to open and CMD and run the command: System.Diagnostics.Process.Start("cmd.exe", "/C \"C:\\Program Files\\MySQL\\MySQL Workbench 8.0 CE\\mysqldump.exe\" --column-statistics=0 -uroot -p1234…
-
3
votes1
answer191
viewsA: Why would it be interesting to add or remove HTML element from the DOM?
The question is: In what real situation would I use this? For what reason, for example, would I want to remove an element from the DOM? In practice there are several examples, I will cite two more…
-
0
votes2
answers69
viewsA: Globalization does not work when deploying
Have you checked which language is being used in your browser? intenert explorer: Chrome:…
-
0
votes1
answer98
viewsA: Postgresql 10 - Parallel Settings
After some researches I found some answers, this can help who wants to enable and have a base configuration, if it has 4 cores (CPU): your max worker processes 'and the amount of cores and the…
-
0
votes3
answers655
viewsA: More than one Date Field in Ajax
If your php is expecting a model Json: $(function(){ $('#enviavenda').submit(function(){ var modelnome= { codBarras : $("#codBarras").val(), quantidade :$("#on2Focus").val() } $.ajax({ url:…
-
2
votes1
answer171
viewsA: INSERT INTO in Postgresql with random values
vc already populated your table the next step would be to change the column nome: Update data set nome = md5(random()::text); this will popular all the column rows nome with md5 Random text…
-
0
votes1
answer59
viewsA: How do I activate Timespan with a set time
from what I understand you want this: var timer = new System.Threading.Timer((e) => { if ((DateTime.Now.TimeOfDay >= System.TimeSpan.Parse("08:00:00.000") && DateTime.Now.TimeOfDay…
-
1
votes2
answers30
views -
1
votes3
answers878
viewsA: How to Get JSON Data
your error 'and in the tag format script <script type="text/javascript"> document.getElementById("teste").innerHTML = pag_1.produto; </script> in Html5 it is not necessary to use…
-
0
votes4
answers358
viewsA: How to add the amount of days with jQuery
errors are the use of the same variable in the calculation dtVenc1 and the lack of getDate() without getDate() its variable is just a string and its sum will result in something like Mon Nov 19 2018…
-
1
votes2
answers415
viewsA: Trigger automatically blocks the table (LOCK TABLE)?
Yes there is the lock until the transition is over. Triggers work in transactions (implicit or not) and, while are open, will block resources. The lock will remain on until the transaction is…
-
1
votes1
answer98
viewsQ: Postgresql 10 - Parallel Settings
There are 4 settings to enable the parallel and make the optimizations, but the documentation Postgresql does not say anything about values or calculations. My questions are: 1- How to calculate the…
-
0
votes2
answers148
viewsA: Validate all required dataannotations fields in the tabs
The problem and its expression $(this) pq it will use only the selected tab, you should use something like $('.tab-content') to search for all your inputs $('#FornecedorNovo').on('submit', function…
-
1
votes1
answer931
viewsA: Session configured on Web.Config and IIS Session State is expiring ahead of time
120 minutes in config will stay like this: <configuration> <system.web> <sessionState timeout="120"></sessionState> </system.web> </configuration>…