Good afternoon I need help to make a checkbox with the following function: if a checkbox value is already inserted it will be red, and if any value is not entered it will be green.
So this is my selectbox and what I need help is that when sel...
In MySQL how to create a select that looks for words "together". For example:
SELECT pessoa FROM tabela
WHERE pessoa like '%josedasilva%'
But this way it does not return anything. Because it is registered as "José da Silva". I would like y...
Hello, I'm a beginner, I'm learning to do select, and I would like to receive help from this wonderful community.
I need to pick up only the invoices that are with the a_vencer status of each student, it would more or less group by id the inv...
Hello friends I'm having a hard time finding what's wrong in my SELECT code in mysql, this is taking over 70sec I do not know why. Someone there to help me please?
Code:
SELECT id_aluno, nome_aluno, ano_lectivo, data data_pagamento_m, nome_...
Hello, in my project I need to list the people and the requests received by the user, but when it comes to listing people, I need to list only those that have not sent or that the user has not sent requests, in this case, my friendship table save...
I'm doing a select in my bank, that is, Postgres , and there are more records coming ..
For example, id_pessoa comes a 10 more record than it should come ..
SELECT pac.cns,
pac.cns_responsavel,
pac.cpf_responsavel,...
I'll be brief:
When trying to work the values of a query that uses MAX, I get the error:
Use of undefined constant protocol - assumed 'field name'.
Table:
Select:$atestados=$conect->query("select max(protocolo) from atestados");
P...
I am having a question for mounting a query on Oracle, I have the following so far ...
SELECT M5.NIVEL_ESTRUTURA
, M5.GRUPO_ESTRUTURA
, M5.SUBGRU_ESTRUTURA
, M5.ITEM_ESTRUTURA
, M5.SEQ_OPERACAO
, M5.CODIGO_ESTAGIO
FR...
I created a procedure with ibexpert, does commit correctly, but at the time of running procedure , I get the error:
multiple rows in singleton select.
My intention is to list all the values in the city column of the target table. Whe...
I am using the datatable with ajax, getting among others a column with select, but I do not know why onchange does not work. Here's the ajax return:
{"data":
[[
1,
"17020161",
"Marina Costa Vasconcelos",
"<select da...