Posts by gabrielfalieri • 1,231 points
132 posts
-
-1
votes0
answers13
viewsQ: Compare information in sql
I have the following scenario. I have a site where there are "partners" for this site. Each partner has a specific url for it. When someone accesses this link, with a specific url, something like…
mysqlasked gabrielfalieri 1,231 -
1
votes1
answer22
viewsQ: Calculate value difference from same column after sum with condition
I wanted to calculate the balance of an extract, since I have fields like extrato_tipo and extrato_valor, whereas the extrato_tipo I use to be able to define whether the extract is input or output.…
mysqlasked gabrielfalieri 1,231 -
0
votes1
answer18
viewsQ: Find out less value that is coming from an excel
I have a spreadsheet that receives several values on the same line, they can both be filled or only one of the values filled. So for example: Coluna | A | B | C | Valor | 56,00 | 48,00 | 50,00 |…
phpasked gabrielfalieri 1,231 -
-1
votes1
answer336
viewsQ: Download pdf file from php error
I have some pdf files that are generated by my system that I know work, but when I do a script to download this file, this file gives me opening error. The script below downloads the file my system…
-
0
votes1
answer36
viewsQ: List only one image of a product
I am doing a project, where will allow you to register more than one image per product, this has been generating me a certain difficulty. I wanted to list the products that have image and only an…
mysqlasked gabrielfalieri 1,231 -
-2
votes1
answer48
viewsQ: Doubt about subquery
I have several images for a site that I am doing. I wanted to show only the last image that was registered for a particular product. I know with left Join will pull up all the images and that I need…
-
-2
votes1
answer346
viewsQ: IPN paid market does not notify
Good night. I am using the code suggested by the MP to be the basis of my IPN implementation. I’ve done all the integration tests and MercadoPago\SDK::setAccessToken("ENV_ACCESS_TOKEN");…
phpasked gabrielfalieri 1,231 -
1
votes1
answer97
viewsQ: The following Parameters must be Valid date and format (yyyy-MM-dd’T'HH:mm:ssz): date_of_expiration
Hello. I am creating a payment system via pagseguro, where this system is not letting create billets, because it claims the date. I know the date in style 2020-05-30T21:52:49.000-04:00works, but…
-
1
votes1
answer50
viewsQ: Bind amounts in PHP and other languages
Safety and performance is extremely important for any application, so some techniques are used for development. One of them is the bind to perform any type of query in your database. When you do it…
-
-2
votes1
answer298
viewsQ: Get php return in Ajax
I need to take the value of an ajax, after a php fetchAll I am doing a function to calculate the freight of a commodity based on a database of deliveries that I own, already with a predefined value.…
-
-1
votes2
answers38
viewsQ: How to transform this query to lavarel?
I have a query and I need to turn it into lavarel code. I have no idea how to do it. select DISTINCT ( SELECT distinct products.name FROM products join topics on topics.product_id = products.id ) AS…
-
0
votes1
answer146
viewsQ: How to take the mat-Selection-list "Aria-Selected" attribute with angular?
I own a mat-accordion that has a mat-Selection-list in an internal way. I saw that inside this mat-Selection-list has an attribute that calls Aria-Selected, I need to take the data of the checkbox…
-
-3
votes1
answer71
viewsQ: Fill array with array return
I make a request, where search data of a request, where it returns me the "Areas" and saved inside an array. I make an iterator to search the "topics" referring to that "Area", I wanted to put this…
javascriptasked gabrielfalieri 1,231 -
1
votes0
answers46
viewsQ: Error when connecting to Java JMS message with activemq
I’m creating a rudimentary chat for a university job, using JMS and Activemq You’re giving me this mistake that until then I couldn’t understand which mistake is this and why javax.jms.JMSException:…
-
1
votes1
answer45
viewsA: Why does it appear undifined index?
Failed to declare and inhibit it $totalcopias = 0; $mailto = $_POST['mailto']; $mailSub = $_POST['mailsub']; $escola=$_POST['escola']; $nome = $_POST['nome']; $processo=$_POST['processo'];…
-
2
votes1
answer645
viewsQ: How to create a regex to delete letters and number after the 3rd decimal place
I need a regular expression with the following rules: Erase all that is letter Delete all number after 3rd decimal place For example, if I type 34,444 any next number will be deleted. If I type a…
-
1
votes1
answer1301
viewsQ: Sort per month in power bi
I have an excel spreadsheet that gives me something like Contrato Jan/2018 Fev/2018 Mar/2018 2010100 15.800,00 9.000,00 15.000,00 2010101 10.000,00 10.000,50 11.000,15 Right after I made a unpivot…
powerbiasked gabrielfalieri 1,231 -
1
votes0
answers35
viewsQ: Understanding the Crossword Puzzle Algorithm
I have this algorithm below, I wanted to know if I made a correct understanding, if it is very superficial and so have something else to add. My understanding of the algorithm is being made explicit…
c#asked gabrielfalieri 1,231 -
2
votes2
answers781
viewsA: Load select city after selecting state
When the user selects a state, he has to fire an ajax request, which is just below Ajax: $("#UF").on("change", function () { var estado = $("#UF option:selected").val(); $.ajax({ type: 'GET', data:…
-
1
votes0
answers23
viewsQ: Difference between Hoare vs Java Monitor
I’m trying to figure out something I haven’t quite figured out yet why. In my book of SD, you present the following statement: Nos monitores de Hoare, se uma thread (dentro do monitor) executa…
javaasked gabrielfalieri 1,231 -
-3
votes1
answer67
viewsQ: javax.naming.Noinitialcontextexception:
I am trying to do a university job with messageria, but my chat is not starting and presenting the following problem: javax.naming.NoInitialContextException: Cannot instantiate class:…
-
-1
votes1
answer28
viewsQ: Configure database creation in another folder
You can change the mysql database source folder? I wanted to change his source folder
mysqlasked gabrielfalieri 1,231 -
0
votes1
answer352
viewsQ: How to create a measure to count different numbers?
I’m new in this world of power bi and I’m in need of a help, it may be basic what I’m going to ask. I have an excel spreadsheet that gives me more or less to structure down. Protocolo Pedido Item…
powerbiasked gabrielfalieri 1,231 -
1
votes1
answer68
viewsA: Return not working on Function
We’ve been talking and testing, we’re missing put one async: false as a parameter of your ajax
-
2
votes4
answers567
viewsQ: How to know if the first character of a string is capitalized?
I need to know if the first character of a string is capitalized and does not let the program follow. How to do? Console.Write("Digite o nome do " + i + "º rei: " ); kings[i] = Console.ReadLine();…
-
0
votes1
answer371
viewsQ: Compare first characters of two distinct columns in excel
Is there a function in excel that allows me to compare the first n text characters I want? Por exemplo Tenho a palavra Joaquim e Joana, comparo por "Joa" e ele me retorna verdadeiro ou falso.…
excelasked gabrielfalieri 1,231 -
1
votes0
answers32
viewsQ: Change size column bootgrid
I need to change the size of the bootgrid, I’ve looked in your documentation some way to do this and I haven’t found anything like the datatable, which allows you to touch the width. Do you know any…
bootgridasked gabrielfalieri 1,231 -
-1
votes1
answer109
viewsQ: Change date display format in View
I have the following field that returns me the date as follows: 09/17/2018 11:52 AM How to put it inside the standard en. I have tried to put the .ToString("dd/MM//yyyy") in the model.dtProtoclo but…
-
0
votes2
answers59
viewsQ: Problem running SQL
Good afternoon. I have a simple SQL query Select * from Tabela Order By Campo Where this field is string, and this string has data like "xyz001", "xyz002", "xyz0011", thus, the "xyz0011" is…
sqlasked gabrielfalieri 1,231 -
-3
votes2
answers208
viewsA: PHP - associative array: check the amount of elements within a value (which has an array) of a key
Sabrina, you can use a command called foreach Your foreach would look like this foreach ($array as $key => $value) { foreach ($value as $keys => $valor) { //aqui você pega seu valor } }…
-
0
votes1
answer283
viewsA: Register and display image in PHP database
Friend, possible is. There is a file type in Mysql called blob. I have tried some tests to save an image inside Mysql, never worked cool, the image is very distorted. The ideial is to save the image…
-
1
votes4
answers72
viewsA: Remove Class after Click
try with $("#sidebar-show").on('click',function(){ $('#sidebar').removeClass("d-none"); });
jqueryanswered gabrielfalieri 1,231 -
2
votes2
answers124
viewsA: How to format results display
To format dates in PHP, you can use the function date: date('d/m/Y', strtotime($linha['DATA']));
phpanswered gabrielfalieri 1,231 -
3
votes2
answers1197
viewsQ: It is possible to know that an option has been selected in javascript event
I know it’s possible to take the value of a select selected with: $("id option:selected").val() But I was wondering if it’s possible to catch some select is selected via event, for example when…
-
0
votes2
answers860
viewsQ: Open select open value with javascript
Good morning, I’m with a request that I can’t find anything like this. When clicking on select, it sends a request for javascript and fills in the data, and when filling in, I need this data to…
-
-2
votes3
answers35
viewsQ: Ajax not sending request
I can’t see where the mistake is. Accuse me of this mistake $("#btnSalvarArquivo").on('click', function () { var EspecieArquivo =…
-
2
votes1
answer123
viewsQ: How to know if a dynamic <a> has been clicked in javascript
need to know if a certain id of a <a> dynamically created was clicked. formatters: { return " <a href= '#' class='btn btn-warning btnAlterarSolicitacao' data-idSolicitacao='" + row.Id + "'…
-
-1
votes3
answers636
viewsA: Average all records in a table and update column in MYSQL
I don’t know if it can help, but there is a function in mysql called avg, she averages her records
-
2
votes2
answers885
viewsQ: Send email via c#
Good afternoon, I’m needing to send email via c#, ai for testing, wanted to know what are outlook/Hotmail credentials to send emails
-
1
votes1
answer110
viewsQ: System.Data.Entity.Infrastructure.Dbupdateconcurrencyexception error while updating with Entity
Good morning. I need to do an update via Entity and it accuses me of the following error: System.Data.Entity.Infrastructure.DbUpdateConcurrencyException: 'Store update, insert, or delete statement…
-
0
votes0
answers33
viewsQ: form does not upload file
I have a form that I need to upload to an ftp. When I put the fashion down no file loads. <form id="frmEnviar" name="frmEnviar" data-ajax="false" method="post" runat="server"…
-
1
votes2
answers534
viewsQ: Fill List with sql return
good morning How do I fill a List with a return of an sql? What I tried to do for sure will give me an outofrange Exception List<string> list = new List<string>(); string query = "select…
-
0
votes0
answers62
viewsQ: Select with Entity does not work
I have this method that makes me a select but it does not return me anything. [WebMethod] [ScriptMethod(UseHttpGet = true)] public JsonResult GetContratos() { List<object> resultado = new…
-
0
votes0
answers43
viewsQ: How to add sql server Integration server to an existing project?
I am needing to integrate ssis to a project that has already been started, for importing excel spreadsheets and things like. All the tutorials I see shows creating a ssis as if it were a new…
ssisasked gabrielfalieri 1,231 -
0
votes1
answer25
viewsA: Stay with input text filled after changing view Asp.net
I found the solution: $(window).load('btnSalvarNovaAreaReclamacao', function () { });
-
0
votes1
answer25
viewsQ: Stay with input text filled after changing view Asp.net
I’m in the following situation I have a view with a certain field, when clicking a button it calls a certain view, it would need that when clicking a button of that other view, it called this…
-
0
votes0
answers20
viewsQ: application error in Homolog
Good morning, I am experiencing a problem in the Homolog version of the project The index 'IX_ReqCompraId_Id' is dependent on column 'ReqCompraId'. The object…
sqlasked gabrielfalieri 1,231 -
0
votes1
answer27
viewsQ: error in running c#Asp.net Entity application
Good morning, My project started from nothing to present this mistake. Could not load file or assembly 'System.Net.Http, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of…
-
0
votes0
answers40
viewsQ: Procedure does not perform
I have two calls from a trial that just won’t run. The code passes, Procedure code in sql management studio works perfectly and within c# returns me no error. It registers the protocol normally…
c#asked gabrielfalieri 1,231 -
0
votes2
answers110
viewsQ: transform sql with subquery into query in Entity
I’m in need and I’m having trouble getting this sql with subquery and doing the same thing in c# Entity. SELECT Id,Nome, (SELECT Count(Id) FROM Pedidos WHERE Pedidos.ColaboradorId = Colaborador.Id)…