I have the following code:
var ret = Monitoramento.List
.Include(p => p.CD)
.ThenInclude(p => p.CargaEntrega)
.ThenInclude(p => p.CargaEntrega.Motorista)
.ThenInclude(p => p.CargaEntr...
I'm putting together a calendar of events in Wordpress and I need to list all the events of the week grouped by the current day. I have events that last only one day and others that last the whole month. I created the custom post type "Events" a...
I need to do a conditional select that checks a sum done this way:
select round(sum(('gin'.'Caixa_9L' / 1000)),1) AS 'total' from 'gin'
If this sum above is = 0, I need to get a value from one field in another table (called an asterisk) and...
I'm trying to display a query ordered by the month of a field date , in phpmyadmin the query comes out right and when I display the result of the same query with php the date quit the correct order.
query:
"select calendario.id_ca...
Good evening,
I have the following code:
WITH
CONSULTA AS (
SELECT
V.CHAPA,
V.DATA,
MAX(V.BATIDA) AS MAXBATIDA,
MIN(V.BATIDA) AS MINBATIDA
FROM
ARELBATIDATRANSITOVIEW AS V...
I need to manipulate a key that is passed as a parameter in this query :
$Read->FullRead("SELECT DISTINCT ".DB_CONTAS." WHERE
contas_status = 1 '{$FilterAdd} ", "{$FilterValues}");'
The var_dump {...
Personal help please,
I need to make a select in a table that contains ID, VALUE, DATE, NAME.
The result has to bring only the lines where the date was the largest one.
Example:
ID VALOR DATA NOME
1 100 22/05/2...
I'm in a project, I have the client and work table.
A job has a customer. I have already listed the tables, but I need to do a select that from the client id in the work table, return the client name.
I have to make a query to display in my c...