Questions tagged as 'select'

Tagged questions
1
answer

Fine tuning in Ranking for a game system [closed]

I have a very crazy problem that has already burned my logic ability. Some time ago I asked a question almost the same as this one but they helped me a lot (thank you very much) but my need has changed and now I have another table and my quer...
asked by 23.02.2016 / 17:41
1
answer

Is there a way to join multiple SELECTS in just one query?

I have a page where I will have to make several queries to the bank. At present, they are a total of three tables. They are: cadastro , publicacoes and estilo . Currently I do this: SELECT nome, sobrenome, usuario, email FRO...
asked by 31.01.2016 / 00:28
1
answer

Is it possible to reuse this complex function for multiple entries at the same time?

In the site that I assumed from a previous developer, one registers investors one by one after a system search called CM. The function is called cadastraInvestidor: function cadastraInvestidor(codigoCM){ // TODO 2/4/2015 - Cadastro de investid...
asked by 07.10.2015 / 16:06
1
answer

Mysql ambiguous error

I'm having an error in my Select SELECT *, SUM(IF(debito_credito_financeiro = 'D', valor_financeiro, 0)) AS debito, SUM(IF(debito_credito_financeiro = 'C', valor_financeiro, 0)) AS credito, (SELECT SUM(IF(debito_credito_financeiro = 'C', valor...
asked by 02.06.2016 / 14:45
1
answer

How do I not select records that are within a date?

I have a table in MySQL with apartment, like this: id | nome | data_ja_locado 1 | ap teste | 09/08/2015, 10/08/2015, 11/08/2015 Then when the user does a search he wants to find apartments that are available within a space of time. If...
asked by 21.07.2015 / 17:55
1
answer

Android sqlite - Return _id logged ListView only a value selected using Where condition

Good evening guys, I'm new here, I'm new to Android programming, but I decided to do my TCC, an Android project. by doing it alone, finding stuff on the internet, without taking Android classes, I'm going to do it well (or not), but I ran agroun...
asked by 01.04.2015 / 07:04
1
answer

Error Code: 1048, SQL State: 23000 Column 'colegiado_id' can not be null

Hello, this error "[Error Code: 1048, SQL State: 23000] Column 'colegiado_id' cannot be null" It happens when I try to run the SQL command below directly in MySQL: start transaction; INSERT INTO EspecialistasColegiados (colegiado_id, esp...
asked by 04.03.2015 / 22:06
1
answer

How to mount a Select to join columns

I have a question that I do not even know if it is possible, it is as follows: I would like to perform a select that joins up two columns. Otherwise it would be: Table Person with the fields cod_people - name - rg - razao_social - cnpj C...
asked by 13.01.2015 / 00:51
1
answer

How to add an array to a value attribute?

Hello! I'm having trouble using a multiple select field with a choseen-select plugin in a form link <form id="cadastro" action="process_teste.php" method="post"> <select id="form-edit-selecionar" name="fornecedor[]" data-placeholder...
asked by 12.09.2014 / 15:01
1
answer

How to get all rows using duplicate value in IN

How do I get all rows using IN (), and inside the IN () have duplicate values SELECT NOME FROM PESSOA WHERE ID IN (1,1,1,2,3,3,4) I want to return 3 times the name of ID 1, and 2 times the name of ID 3.     
asked by 29.10.2014 / 15:11