Questions tagged as 'query'

Tagged questions
0
answers

Hibernate Query with setParameters

Hibernate is ignoring my data from a Map when it is null. If I hedge with setParameter("nome",valor) and the value is null it works, does anyone know how to solve it? Here is the code: public List selectList(String sp, Map par...
asked by 09.05.2018 / 20:34
3
answers

save the value of a query in a php variable

I want to save the value of a select to a php variable, and then display it in the html. I tried something like: function totalEspumas(){ $banco = abrirBanco(); $quantidade_pedidos = "SELECT SUM(quantidade) from pedidos"; $resul...
asked by 04.04.2018 / 15:24
1
answer

How to create this view in postgres?

CREATE VIEW grafico AS SELECT AVG(realizacao) , AVG(estima), AVG(fisiologica),AVG(seguranca),AVG(social) FROM necessidade; I'm trying to create a view that brings the average of five columns of the required table, but I can not create this vie...
asked by 26.03.2018 / 20:29
1
answer

Filtering JSON records by JavaScript or PHP

I have a question about how to do data filtering when the client fills an input field. I'm looking for all server logs (running PHP) through a jQuery JSON request and would like to know how to make a less "restrictive" JavaScript filter since th...
asked by 30.03.2018 / 01:55
1
answer

mysql random questions

I have a somewhat complex and helpful question: I have a database with the following links: Exemplifying:IaminhistoryclassonKarlMarx.Thisclassislinkedtoacertain"subject" group of Karl Marx that has a bank of 100 questions. However, of tho...
asked by 20.03.2018 / 06:35
0
answers

Too much query delay in MySql only

Here in the company we have PG and MySql databases, these two banks are networked and identical in structure and data, where a "robot" performs this mirroring between them every 10 minutes. So far so good ... It turns out now that the bases ar...
asked by 15.03.2018 / 18:38
1
answer

Blank Query

I'm starting in the programming world and start with a problem when I run the query locally the query shows me the return normally but when I try to query through a simple application: <?php /** * * @var string $dsn : driver de conexão...
asked by 22.03.2018 / 14:54
1
answer

Query query in SQL Server 2012

I need this query to come only with records where the CURVE ABC column is different from the MODEL column. For example, this customer's ABC curve is silver and the model is diamond / gold, so it turns out that the name silver is not in the mo...
asked by 09.02.2018 / 14:25
1
answer

Doubt - Case when inside a stuff - SQL Server 2012

Well, how do I put a case when exists inside the query below. The result is currently working out like this: Customers Drugstore, Soccer, Gelagua However, I want to put a case when exists if it is in the condition, come yes, yes, not come....
asked by 31.01.2018 / 20:56
2
answers

How to use forech in Wordpress using the WP_Query variable

Good morning! I am not able to implement a forech in a database search using the native wordpress variables, searching I found something similar but it is not what I need. <?php global $post; $args = array('category' => 17); $custom_po...
asked by 21.02.2018 / 14:12