Posts by Rogerio Pavan da Silva • 93 points
9 posts
-
0
votes1
answer498
viewsA: How to make condition in two different tables with sequelize?
I ended up using the "literal" sequel. var prestadores = await Prestador.findAll({ include: [{ model: Financeiro, as: 'financeiro', required: false, }], where: literal("`Prestador`.`status` =…
-
1
votes1
answer498
viewsQ: How to make condition in two different tables with sequelize?
How can I make this select in sequelize? select prestadores.status, financeiros.status as prestador_status from prestadores left join financeiros on prestadores.financeiro_id =…
-
0
votes1
answer151
viewsA: I need to take data from the database and display in JSON but gives error
json_enconde there is no! json_encode is correct.
-
0
votes2
answers162
viewsA: Output: Nan | Bhaskara Formula (quadratic function) in javascript
As I do not have your file with the numbers, I tested with a variable, const txt = "100 200 6", Because I think your file should look like this, right? Everything worked out fine. I believe your…
-
1
votes1
answer26
viewsA: Selecting specific SQL Server values
The two of you together, I don’t think you can do it, but you can do it one at a time: 1- Search People with their Cities select Pessoa.id, Pessoa.nome, Cidade.id, Cidade.nome, Cidade.UF from Pessoa…
-
0
votes4
answers450
viewsA: UPDATE WITH SELECT AS A CONDITION
I’ll ask you again! The user field of the second table is whose foreign key, is it from the id field of the login table? If not, your table structure is wrong. Your login and users table should have…
-
2
votes4
answers450
viewsA: UPDATE WITH SELECT AS A CONDITION
The field usuario of the second table is the id of user? If so, you can do so: UPDATE usuarios SET confirmado = '1' where usuario in (select id from LOGIN where logado = 1);…
-
0
votes1
answer98
viewsQ: Google Places API - Search with multiple Keywords using google Places api with javascript
I’m having trouble finding a way to search for more than one keyword at the same time, I couldn’t find anything in the google documentation about it. I need to look for sandwiches, but in São Paulo,…
-
2
votes1
answer256
viewsQ: Push Notification with Firebase + business rules
I have to receive push notification from firebase, but it is not for all phones that these notifications will be sent. My app checks for changes in contracts, the user reports a number of CPF and…