Questions tagged as 'query'

Tagged questions
0
answers

Wrong paging count in wordpress

When the slug stored in var $ type is for example 'salty pizzas' the page scrolls normally, now when this slug changes, the paging appears even without the need to appear, with several blank pages. It's like you're counting all the results for a...
asked by 12.11.2015 / 03:46
0
answers

Pagination on page-blog.php on Wordpress

I'm creating a Wordpress theme and I've created a page called Blog that is using the page-blog.php strong> slug page is also blog, where it will list all the posts of a CPT blog, where the same I configured the blog slug . But for som...
asked by 17.12.2015 / 12:09
1
answer

Query Performance - Postgresql

I have the following situation, I need to bring data from a vehicle table of the system in which I work and another with integrated data of a partner system, because integration is not very consistent data and the way to connect the tables can b...
asked by 29.10.2015 / 12:21
1
answer

Using python and django, problem with querys

I'm using Python with the Django framework. This method should return a resulting query, to send e-mail to the corresponding e-mails from the database. However, the method works for some cases and for others it does not. from django.db.models...
asked by 14.10.2015 / 21:35
1
answer

Result with repeated records

Good afternoon! I'm making an appointment, but the result is bringing repeated occurrences. is there a command for the query to just bring a record of each column? follow script: SELECT * FROM HIS_LOTPES A, his_afasta c, FERIAS D, PESSOAL P...
asked by 01.03.2016 / 20:55
1
answer

Returning an array from a function in PostgreSQL

I have a question here that I need to troubleshoot with a function in the postgreSQL database. The problem is this, I need to cross a table called stock_alt with a view called stock . In this table inventory_alt are only the codes of the...
asked by 01.03.2016 / 15:07
0
answers

Relational query in Parse in a single call HttpGet

Good morning. This question is for the Android environment. I use ADT. I need to implement a Carriage table and a Manufacturer table in Parse. Car has the model and manufacturer fields. The Manufacturer table has the Name field. In additio...
asked by 09.11.2015 / 14:00
0
answers

Perform subtraction using aggregate functions

I have a real estate table with the code , price and area fields. I need to figure out what the price difference is between the largest and smallest of the table (in a matter of area). I tried this, but the difference between the highe...
asked by 02.09.2015 / 21:28
2
answers

How to consult a table in a limited (partial) way?

I need to consult a table by extracting from it the infos: <nome> and <pontuacao> , my tcc is a game where one of your options is to see a Ranking of players registered. as there is a possibility that the soft grow in nu...
asked by 10.09.2015 / 19:31
1
answer

Query with two summations for the same column

Is it possible to do a query where two sums are executed on the same column in the same query? What I have is the following: Total sales sum select month(emitido_date) as mes, ifnull(sum((det.preco * det.quantidade) * (iva.valor/100) +...
asked by 11.08.2015 / 10:33