Posts by Silvair L. Soares • 248 points
16 posts
-
2
votes1
answer26
viewsA: Return non-repeated lines in a Select
SELECT delivery, max(dt_coletado)AS dt_coletado FROM table1 GROUP BY delivery
-
0
votes2
answers355
viewsA: Storing multiple values in the same column of the database, how much is it worth?
I agree in part with the opinion of our colleague João Martins. I usually use this feature in my solutions, and I get the following criteria to decide between creating a new table or storing the…
-
0
votes2
answers119
viewsA: Query sql SELECT
From what I understand of your question, that would be: /*Buscando pelo nome do usuário*/ SELECT * FROM Post WHERE ID_USER = ( SELECT ID_USER FROM Users WHERE Login LIKE…
sqlanswered Silvair L. Soares 248 -
1
votes1
answer48
viewsA: Problem when trying to publish multiple Apks in Google Play Store
I managed to solve after a lot of fighting. What I did was: 1 - I executed a compilation, which generated the Apks with the internal version 100012, signed, aligned, uploaded the version Arm7 and…
-
1
votes1
answer48
viewsQ: Problem when trying to publish multiple Apks in Google Play Store
Good morning, everyone. I developed an application with Ionic using the crosswalk plugin. When compiling, two . apk files are generated, one for Arm7 architecture and one for x86 architecture. So…
-
1
votes1
answer258
viewsA: "Maximum call stack size exceeded" error when instantiating object
Thank you all, I managed to settle here. It was an error in the name of the property _interactions, in class Jobmodel. Basically I changed from: public _interacoes: JobIteractionsModel[]; get…
-
0
votes1
answer258
viewsQ: "Maximum call stack size exceeded" error when instantiating object
I have the following classes in an Ionic 2 app export class JobIteractionsModel { public _idJob: number; get idJob() { return this._idJob } set idJob(idJob: number) { this._idJob = idJob } public…
-
2
votes2
answers240
viewsQ: Custom Return in WEB API
Good afternoon. I would like to know if there is any standard or good practice (independent of the programming language), for building Web API that allow customization of the content of the…
-
0
votes2
answers16723
viewsA: Picking values with names in JSON
I tried to do as Antony Alkmim informed, but I could not, what worked for me was: //Obtem o objeto httpRequest para fazer requisições AJAX, de acordo com o browser function getHttpRequest(){ if…
-
1
votes1
answer57
viewsA: Return fields from parameters
I believe this is what you need. DECLARE @Variavel AS VARCHAR(MAX); DECLARE @ComandoSQL AS VARCHAR(MAX); SET @Variavel = 'campoa'; IF (@Variavel = 'campoa') BEGIN SET @ComandoSQL = 'SELECT campoa,…
sqlanswered Silvair L. Soares 248 -
2
votes1
answer38
viewsQ: http get method called automatically
Good morning guys, I’m implementing the get a Servlet method here with a very simple logic. If the user passes a url in the default: ".../entities/id", the editing form should be opened with the…
-
0
votes0
answers205
viewsQ: Boot failure of Tomcat 8 on Ubuntu 14.04.4
Good morning, everyone. I’m trying to initialize Tomcat 8 in Ubuntu and I’m not getting it. By running the following command "sudo /Tomcat/bin/startup.sh" the following log is generated: Log…
-
0
votes3
answers756
viewsA: How to group results in a row?
This way, you get the name of the exams dynamically. So you don’t need to rewrite the query when registering a new exam. DECLARE @ColunasExt AS VARCHAR(MAX); SET @ColunasExt = 'SELECT FICHA, ';…
-
2
votes2
answers1574
viewsA: How to get date and time in different columns through a select Sql server?
You should not treat separate date and time, you should concatenate them by filtering through them. In your example, the DBMS will try to bring the records between the dates "04/17/2015" and…
-
0
votes3
answers645
viewsA: SQL Server subquery is always returning null. How to fix.
The error in print, is because the query "(SELECT Id_address FROM CTE_ENDERECO)" did not bring any result or NULL and you tried to assign this result to the "Fk_address" field of the table "Tag"…
-
1
votes3
answers49197
viewsA: How to use the output of a select to mount another?
I believe this is what you need: DROP TABLE TabelaComandosSQL;/*Se já existir*/ /*Cria uma tabela para teste -----INÍCIO-----*/ CREATE TABLE TabelaComandosSQL( [Codigo] [int] NOT NULL CONSTRAINT…