Questions tagged as 'consulta'

Tagged questions
1
answer

How to load certain tables of a DataGrid - MVVM - UWP?

I just want to create a Datagrid to load a query from the database, using this example link but I do not understand exactly how I charge the list. But I found this code <controls: DataGrid x:Name = "DataGrid" ItemsSource = "{Binding Pl...
asked by 01.11.2018 / 15:30
0
answers

Two volley queries in the same Android class?

Good I have this query to an external url, the results realize the set and get to a recycler. The issue is that I need to make two more queries of this style. How could I achieve these consultations in the same class? Thanks private void Carga...
asked by 23.08.2018 / 14:35
3
answers

Comparison between two sql tables

Well I need help with my sql code. This is my code: SELECT Pedidos.Numero, Pedidos.Estado, Pedidositems.Cantidad AS CantidadPedida, RemitosItems.Cantidad AS CantidadEntregada, pedidositems.Codigo AS CodigodeProducto, pedidositems.Descripción A...
asked by 10.08.2018 / 15:08
0
answers

SELECT query * FROM Does not bring all the data

I'm doing a query from one excel file to another. Through a recordset with the method SELECT I bring the columns that I want to my base, the problem is that I have a column Date de Facture with data type DATE (04/01/2018)...
asked by 09.08.2018 / 12:43
1
answer

how to make queries of 3 different tables in mysql in different capos

Excuse me, I'm doing a query where I need data from 3 different tables and the query is executed but in the column of table 1 and table two the data is repeated and those in the 3rd column if shown as they should, that I have to fix in my office...
asked by 27.06.2018 / 17:42
1
answer

Consult mysql with Flask

I am trying to make a query to MySQL that should bring data in a set date range and it does not work, if I could make other queries but it does not work, the data of the date range are two input type="date" I show them the code: <for...
asked by 22.06.2018 / 14:09
0
answers

Assign SQL Query to a Variable

I have this Consultation: $result = DB::table('cliente') ->select(DB::raw("CONCAT( TRIM(SUBSTRING( NombreCliente,1,1) ), TRIM(SUBSTRING( NombreCliente, locate( ' ',NombreCliente), 2) ) ) AS INICIALES")) ->get(); I get the...
asked by 15.06.2018 / 01:18
0
answers

How do I do this query in tables with msql

Hi, I have this code to make queries to some related tables, what I want to do is weigh the parameters but I can not find the way, the parameters that I want to pass are those of the municipality, for when searching for example, municipality lan...
asked by 10.06.2018 / 03:11
1
answer

Query with multiple records returns only one record

It returns only one record and in my DB there are 3. I suspect that the problem may be in the query, with the theme of concatenating tables. Here my sentence: SELECT productos.nombre, productos.name, productos.precio, categorias....
asked by 25.05.2018 / 18:08
0
answers

sql query sent with an array from jquery

I need to make an sql query with the results of an array so that it picks up some specific bbdd values var array_ch=JSON.stringify(ar); $.ajax({ url:'php/ch.php', type:'POST', data:{ch:array_ch},//aqui esta el array que...
asked by 16.05.2018 / 23:42