Posts by NDelavi • 397 points
15 posts
-
0
votes1
answer125
viewsA: Update add product from one table to another table
Please try this way and see if it resolves for you: UPDATE PRODUTOS SET ESTOQUE = ESTOQUE + V.QUANTIDADE FROM PRODUTOS P INNER JOIN ( SELECT CodigoProduto, SUM(QUANTIDADE) AS QUANTIDADE FROM VENDAS…
-
1
votes1
answer958
viewsA: Calling the API with Httpclient - POST
I researched some things on the subject, after Minelli’s comments on the question, indicating that the problem was in HTTPS. Basically the problem is modifying the security protocol to be able to…
-
0
votes1
answer958
viewsQ: Calling the API with Httpclient - POST
It’s the first time I’ve developed something like this, so I don’t really know what could be wrong. I’m making a call to an API with the HttpClient, thus: private string autenticar() { try { using…
-
1
votes1
answer78
viewsA: Null object with jquery ajax MVC3
The problem was really the bind of the object. As my dto has a property called Message, the same could not do because everything practically calls Message (Controller, Dto). I switched my Dto and…
-
0
votes1
answer78
viewsQ: Null object with jquery ajax MVC3
I know I must be forgetting something. I am making a request ajax jquery to send a message via contact form, however the object is coming null on controller. I tried doing with the JSON.stringfy and…
-
0
votes1
answer48
viewsA: Redirect to another part of the same php page
You need an anchor. In the link you want to be clicked do so: <a class="qualquer_class" href="#Form-Interesse"></a> The div you want to appear when you click, do so: <div…
-
1
votes1
answer1178
viewsA: Change Timezone javascript
By default Heroku uses UTC Timezone. You can swap the default server Timezone using the configuration: heroku config:add TZ="America/Chicago" Configuration can also be done by Dashboard. SOURCE…
-
1
votes1
answer258
viewsA: Drag & Drop with jQuery does not place the element in the right DIV
Based on our comments, I took a look around the internet about the Sortable and found this post on Stack in English: Stackoverflow in English Basically you will use the Sortable within a table and…
-
3
votes2
answers48
viewsA: Perform multiple operations in a single SQL code
To bring everyone on the same line, you would have to nest the subselects, so: SELECT *, (total3 - total2) / total1 as calculado FROM ( SELECT COUNT(*) as total1 FROM nome_tabela) total1 JOIN…
-
3
votes1
answer627
viewsA: Grab image address, jquery
Do so: <html> <head> <title>hello</title> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script> <script> function get(){…
-
1
votes2
answers688
viewsA: Are the Unitarian tests correct?
Based on my comment your question, in addition to reaffirming that unit tests are for testing the business rule and must have both error and accuracy tests, it is nice to put that unit tests should…
-
0
votes3
answers132
viewsA: Error concatenating component value in query
If you are using the core framework, the latest you can do so: string Consulta = $@"select nome as Nome, endereco as Endereço, telefone as Telefone, dataCadastro as [Data de Cadastro] From clientes…
-
1
votes1
answer191
viewsA: How do PHP read Mysql from the bottom up?
Change the line: $result_usuarios = "SELECT * FROM posts LIMIT $inicio, $qnt_result_pg"; for $result_usuarios = "SELECT * FROM posts LIMIT $inicio, $qnt_result_pg ORDER BY 1 DESC";…
-
1
votes1
answer49
viewsA: Connect columns from different tables
Try this: SELECT e.EMPLOYEE_ID AS 'ID' ,e.FIRST_NAME + ',' + e.LAST_NAME AS 'Name' ,(SELECT DEPARTMENT_NAME FROM HR.DEPARTMENTS d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID) AS 'Department Name'…
sql-serveranswered NDelavi 397 -
2
votes1
answer2105
viewsA: How to publish a site on Locaweb with an application made in ASP.NET MVC?
In my web.config for publication I do not determine the trust level. I leave it to their server to do it. The message you’re giving is why your web.config is trying to modify a parameter defined in…
asp.net-mvcanswered NDelavi 397