Posts by SpockWayne • 463 points
19 posts
-
1
votes1
answer30
viewsA: Post goes as Null in the Node api
Hello, Ricardo Despite not having enough information on your question, I decided to test your code locally. It is working "perfectly" as expected (according to the code)... It may be that in the…
-
5
votes1
answer109
viewsQ: Doubt about generic types in Typescript
I am currently studying Typeorm, and wanted to create a generic controller, as it will always be the same CRUD operations. I know I can solve with native Typeorm solutions, such as getRepository(),…
-
1
votes1
answer39
viewsA: MYSQL VIEW data listing
You is not specifying the day you want to consult, your query for the day is always limited to the first day returned as a result, which in case is 2019-07-15. I have no way to test my proposed…
-
0
votes1
answer18
viewsQ: How to "rebuild" a file from the buffer stored in the database?
I’m in great doubt. I upload files and receive them on a Node server with the help of middleware multer, the data comes something like this: Then I take this file and save in the database the result…
-
0
votes2
answers150
viewsQ: v-form post does not send data
I created a basic form to see if I receive data in my API using vuetify but when giving Ubmit the v-select data is not sent and I cannot understand the reason, since in general the examples of these…
-
-1
votes1
answer61
viewsA: I need a select that if the result is 0 or null it does not display the button
With this query will be returned the number of records that contain a link and product with the same ID that you are informed. SELECT count(*) 'linhas' FROM clientes c JOIN infos i ON c.id =…
-
0
votes1
answer45
viewsA: Problem with update in Trigger
The data you are entering in the table dpu.auditoria_usuario are insufficient as this table contains 5 primary keys (must be informed), of which 4 are foreign keys (the lack of them causes the error…
-
0
votes3
answers131
viewsA: How to relate questions to a question
Only indicate through an attribute of the alternatives whether or not it is the correct answer. I didn’t understand what you meant by : "to know the correct option it would be necessary to always go…
-
2
votes1
answer60
viewsA: I have to take a name typed by the user and create a file with this name... LING. C
Having the #include <string.h> you can use the strcat(str1, str2) function to concatenate 'strings', leaving your logic more or less like this: file=fopen(strcat(nome_arq, ".txt"),"w");…
canswered SpockWayne 463 -
2
votes2
answers59
viewsA: nonexistent origin registration. How to bypass? Foreign Key
If available, remove the restriction not null of the source field, so if a cell has no "source", it can be inserted into the database without problems.
-
1
votes2
answers210
viewsA: Logic for ABC curve
Your SQL query will need a grouping function, and it will look like something like this: //seleciono os campos que necessito (nome e quantidade) da tabela de vendas SELECT client_name,…
-
0
votes2
answers18166
viewsA: Uninstall Mysql from Ubuntu
It seems to me that you no longer have it installed: O pacote 'mysql-server' não está instalado, por isso não será removido You can follow the steps contained in this tutorial for a complete…
-
3
votes1
answer51
viewsA: Add up the Count results
You are missing when grouping this part of the script: GROUP BY r.[GITEC], r.[CGC], r.[PONTO DE ATENDIMENTO], r.[CIRCUITO], t.co_ocorrencia ORDER BY Oscilações DESC you are stating that the results…
-
0
votes2
answers97
viewsA: Use updatemany in Mongoose in a request
Apparently you forgot to close the key that is open just before the $set: {$set: {nome:"obj.$.nome", idade: "obj.$.idade"} She has to stay like this: {$set: {nome:"obj.$.nome", idade:…
-
3
votes1
answer97
viewsA: Modeling teaching offer database
When observing your model I see some problems as for example: From the table 'Class', apparently it is not possible to know which school she belongs to, as well as it is not possible to know in…
-
0
votes1
answer65
viewsA: Database query with java
I don’t know if I understand correctly what your question is, but if you are simply updating a Jtable’s data, just do a new query in the database and pass the result to Jtable. As an example I have…
-
1
votes1
answer32
viewsA: Javascript error
The error is in ' btnElement.onclick = createQuaded() ', so you are indicating that the function should already be immediately executed, when in fact it should only be executed when the button is…
-
1
votes1
answer395
viewsQ: Relating Javascript file to an HTML
I’m a beginner in the Node world, and I’m having trouble relating a . js file to an HTML. I took a simple code, in it I have a combobox that is filled when pressing a button: //app.js var express =…
-
0
votes1
answer70
viewsA: Relational Model of a Bank
Analyzing from the description provided, the model is largely already meeting your requirements, I believe your model is not yet complete, but still, I would like to signal some situations: There is…