Questions tagged as 'query'

Tagged questions
1
answer

Get the length of the variable stored in the database table with codeigniter

It turns out that in my database I have a table called votes , in which within the column option I store a and b Then I want to get the total amount of 'a' stored in the table as well as the total amount of 'b' stored in the table....
asked by 22.12.2016 / 21:42
0
answers

Execute query and assign values to excel columns

I have a problem and I do not know how to execute a query and pass the values to the respective columns, this I do to generate an excel. I use the library PHPExcel . Query: $query = 'SELECT i.description_item,i.quantity,u.name_unit,i....
asked by 18.12.2018 / 19:17
1
answer

data within a date range

I need to generate a PDF report and show the items that are between a date range. This is the modal where the datepicker and the Generate Report button are found with a onclick="Report()" that leads to a function in JavaScript ,...
asked by 11.12.2018 / 22:53
1
answer

Concatenate data and insert in a field

I have part of this code php , where you are doing insert to the table inventory_list , but what I need is that it depends on that you have selected in fkCategory , fkLocation and fkSubCat that refer to...
asked by 13.12.2018 / 19:00
2
answers

Report everything, without id

Previously I had made a report in pdf where I brought everything that belonged to a folio , I had no problem in that, since identifying the number already came with their respective information. On this occasion I want to do anot...
asked by 05.12.2018 / 23:30
1
answer

How to modify the queryset of a ManyToMany field in Django Framework

my question is to know if you can and how it would be to modify the QuerySet by default that a field with the ManyToMany model brings, because as I understand the default query is: Modelo.objects.all() But I would like to change that query...
asked by 29.11.2018 / 23:21
0
answers

Validate client ID to export in SQL Server

Friends, good evening, I hope I can explain myself well about the problem I'm having. I am currently doing an export in SQL With the following query: SELECT IDFactura, FechaDocumento, NombreCliente, NIT, DireccionFacturacion, FOLIO, Sub...
asked by 29.11.2018 / 04:59
0
answers

Change of status in PHP

I am doing a api to change the status of an item within an inventory, for certain processes the change can be applied. else if(isset($_POST['id']) && isset($_POST['x'])) { $connection = new MySqlS...
asked by 29.11.2018 / 19:22
0
answers

Query SQL to table with several values that meet conditions

I have this query: SELECT Comments FROM Interview WHERE Profile_ID=[@field:Recruiting_Candidato_ID] AND Job_ID=[@field:Ofertas_Oferta_ID] The problem is that in the Interview table there are several lines that meet both conditions, then I j...
asked by 20.11.2018 / 17:34
1
answer

mysql search string with accents

Hello friends, could you help me? I have to make a query in mysql to look for states but they have to be as they are in the table; Ciudad de México Hidalgo Jalisco Estado de México Michoacán de Ocampo Nuevo León Querétaro San Luis Potosí Sinal...
asked by 21.11.2018 / 17:33