Questions tagged as 'consulta'

Tagged questions
1
answer

How to show records of 2 related tables?

I have a CRUD with multiple files, create 2 tables, one is an activity where all the data goes and another image where only the files associated with the activity go. The problem happens that if user wants to add 2 or more files to the act...
asked by 01.06.2018 / 01:44
1
answer

Data filtering between two SQL Server tables

Good afternoon, I have a problem wanting to select specific data when making a query to two tables; The tables are the following: create table persona ( id int identity (1,1) not null, nombre varchar (350) not null, apellido varchar (350) not...
asked by 22.05.2018 / 19:41
1
answer

Hello, I have a slight problem

I write this code, but at the time of execution, it tells me an error, it says that this function is dedeclared but it is not used .... why is this error? private void Button1_Click(object sender, EventArgs e) { if...
asked by 28.11.2018 / 03:28
1
answer

Why do I receive different values in the same mysqli php query?

I have a problem with a mysqli login validation query, the problem is that there are two queries of the same function but obvious of different variables, one throws me an object result with an array of values, and the other returns bool ( false)...
asked by 26.11.2018 / 00:41
0
answers

Parameters in consultation with angular firestore

I would like to be able to call only certain fields of a document stored in firestore, in order to reduce the amount of information of the call, however I can only bring the full document. The call I do it in the following way: return this.afs...
asked by 26.09.2018 / 08:04
1
answer

Get row number sql

I've been testing for a couple of days how to get the row number of a query, and in fact I got it but when I upload the code to the server where I have my page hosted, I find a syntax error. I have reviewed the mysql versions and in local I have...
asked by 04.09.2018 / 12:27
0
answers

Doubt with query in MYSQL

I will try to explain my doubt in a simple way since it is something complex. I have a table called formacion with the fields ID , Tipo , Categoría and SubCategoria A table called alumnos with the fi...
asked by 10.06.2018 / 19:28
0
answers

HELP! How to make this MySQL query

I have these tables, payroll, deductions, bonuses, advances, employee, and what I want is to add the total bonus, total deductions, total advances, then show this data, and with this calculate the total salary and group it by idEmpleado, I've do...
asked by 24.04.2018 / 06:40
2
answers

Help with database structure

I have a system for sending files and I have control in two tables, one to save file names and status of sending and processing, and another in which I keep the details as error messages when sending or success when processing. Now I have the...
asked by 15.09.2018 / 18:21
1
answer

What is the use of & gt and the & lt in a native query?

I have the following native query but I do not know what it means or what it does & gt, & lt <query> SELECT ID, ID_BASE, NOMBRE, RFC, NOMBRE_CLAVE, FEC_REGISTRO, FECH_PRINCIPAL FROM FACTURA F WHERE F.ID_BASE=?1 AND F.FEC_RE...
asked by 12.07.2018 / 05:35