Questions tagged as 'query'

Tagged questions
0
answers

Lucene - Simple search with query

I'm trying to do searches on an index made with Lucene that was sent to me. They are simple searches that are not working ... package portugues; //https://lucene.apache.org/core/2_9_4/queryparsersyntax.html import java.nio.file.Paths; impor...
asked by 21.03.2017 / 13:28
1
answer

Query is executed, but the data does not go to the database

Good afternoon, Galera, I'm studying the PDO and with the following difficulty, the query executes (Or rather, it does not return any errors), but when I go to the bank, it does not have anything, what do I do? / p> pdo = new PDO ("mysql:host...
asked by 10.12.2016 / 16:39
0
answers

How to pass parameters to a query in a repository?

I'm creating a series of classes that return listings in Java (Android). I'm worried about the format of the parameters that will be passed. My initial approach has been to pass Map with parameters, this way I can add or remove paramet...
asked by 22.11.2016 / 18:01
1
answer

Calculate the mean values where fields are equal

I have a table, in mysql , which receives some data regarding evaluations. How can I average these evaluations directly in query , based on the question? I tried in many ways, including researching here, and I could not. SELECT perg.pergunta...
asked by 30.08.2016 / 16:18
0
answers

Reload failing in some moments

I made a script to set an image as a cover, the script works perfectly and I programmed it to perform a reload on the return, but strangely this reload fails in some moments for no apparent reason. The script is this: $(function() {...
asked by 16.06.2016 / 22:43
2
answers

SQL update query syntax error

When I run the following update query, a syntax error occurs before or within from: UPDATE Artigos SET totale = entradas.sent FROM Artigos INNER JOIN (SELECT cod_artigo, Sum([quantidade_ent]) AS sent FROM entradas GROUP BY cod_artigo) ON Arti...
asked by 07.07.2016 / 17:38
1
answer

Drop Index with SQL Variable

I am an inexperienced grasshopper and am looking to make an automatic script for myself. This script I created in batch and I can go without problems until the installation of SQL , restoration of the database and execution of some Querys....
asked by 28.06.2016 / 21:58
0
answers

function that returns the key field name of a query (tfdquery), Delphi XE8

I am preparing a CRUD in Delphi and need to do a function to find the key field ( KeyField ) of a particular record located in the query. The idea is to replace the 'id' field required by the Locate with this function and leave the dataset set u...
asked by 09.06.2016 / 00:26
0
answers

Number of queries to check user in laravel

I have a system of user authentication , where I use API sentinel in Laravel 5.2 . When I make Check_user() in middleware to see if the user is logged in and has access to the route, he checks 5 queries in the data...
asked by 13.06.2016 / 16:45
1
answer

Curiosity - PHP and Data Query Limit

Today while doing a query by type PhpMyAdmin SELECT * FROM tabela , I noticed that after a query in the database the query automatically gets the LIMIT , in this way SELECT * FROM tabela LIMIT 0 , 30 , that is, if I am correc...
asked by 05.05.2016 / 21:42