I need a select in which to search for tipo status and responsave l, only that it is catching by several Status, while only needing a count status A
count(if(r.reponsavel mae,if(t.tipo=1 ir t.tipo =2)if(t.status = '...
Hello, guys.
I'm having a hard time changing the background color of multiple selects in iteratively. I can already change, but I have to manually specify the index of the element for this to happen. Here's an example of what I'm doing:
&l...
I'm working with PHP and I have about 8000 records currently in DB.
As it is for a web page, I need to make a pagination to be viable reading the data.
As I understand it, I have to do something similar to limit and offset to...
To get some information from the database in some moments is simpler to make a query with raw sql than to use several models, maps functions and a touch of magic to reach the same goal, however the problem of using a raw querie or a raw express...
I have a real estate site that assembles a photo album for each type of photos: Facade, Common Area, Floor and Decor.
To do this, I do 4 MYSQL queries with PHP, using the criteria for each, but I believe that I should have a one-time solution...
I'm using this select
SELECT
*
FROM
(SELECT
*
FROM
clientescontatos t1
WHERE
codcliente = 'teste'
AND tecnicoFlag = 1
LIMIT 4 UNION ALL SELECT
*
FROM
clientescont...
I'm starting now in the programming area, I'm having a hard time with SELECT which brings the accumulated value day by day of sales, I need this SELECT to play it on the line of a graph indicating the cumulative sales value of the...
In my web system I have the following select:
SELECT round(SUM(peso),3) FROM mov02s WHERE modal = ('Carreta simples') AND data = ('2018-05-16')
I'd like to use a variable instead of '2018-05-16'. The user who will choose the date.
I thou...
I was able to save information to my SQLite database, but I can not call them.
I'm trying using the following method:
private void verPessoas() {
ArrayList<RespostasAguaCasa> pessoas = new Read().getLista();
for (int i = 0; i...
I'm not able to return the value inside my arry always returns 0
Read
public class Read {
public ArrayList<RespostasAguaCasa> getLista() {
SQLiteDatabase db = Maindb.getInstancia().getReadableDatabase();...