Questions tagged as 'sql'

Tagged questions
1
answer

Browse Array with PHP to insert values in SQL query

I have the following code: if(isset($_POST['aplicar'])) { $bafle = $_POST['bafle']; $marca1 = $_POST['marca1']; if (is_array($marca1))...
asked by 17.08.2018 / 00:23
2
answers

Get latest registered email - SQL

I ask you a question, I have a table of this type: Basically the user can have several emails. What I need to do is bring all the users, without repeating them and that the email that I bring is the last one registered. For example,...
asked by 16.08.2018 / 19:54
1
answer

Creation of Script to complete data

My problem is to generate a location report by teams having the following BD: The problem with the report is that the equipment table saves the entry ID or movement automatically but not the location, so you would have to make a script....
asked by 08.08.2018 / 19:22
3
answers

Calculate the minutes difference between two hours

I have the following problem: I have two hours each in their respective jTextField , what I need to know is what to do to subtract those two hours, and calculate only the difference minutes at the moment of pressing the respective button....
asked by 14.08.2018 / 16:36
0
answers

Column type TIME postgresql, returns object

I have a table that has columns that are of type TIME I work with symfony, so what I need is for this field to be filled in a form generated with symfony, but when it is generated I get this error:    Type error: Return value of App...
asked by 14.08.2018 / 16:23
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

How to load data returned with spring mvc in an ExtJs grid?

A couple of days ago I look for the solution to my problem and nothing, and that is that I am working with java framework Spring MVC with SQL connection and integrated with Extjs 6.2 I try to load the data that returns spring to me within a grid...
asked by 10.08.2018 / 16:38
1
answer

Collect the value of GET in a Select and leave selected the correct value

I need to pass the value that I receive from a get to a Select and that the value I receive is selected. So far I've done that, but I only get the option selected by the GET, it does not show me the rest of the options. I show my code in case yo...
asked by 09.08.2018 / 09:51
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
0
answers

Foreach loop in stored procedure

Can you have 2 foreach in a stored procedure? example: I have the following shekel that I only need to do the process once only FOREACH insert into tabla 1 (campo1,campo2,campo3) select campo1_x,campo2_x,campo3_x from tabla2 where campo1_n=...
asked by 16.08.2018 / 00:06