Questions tagged as 'query'

Tagged questions
2
answers

Help with PHP function to discard a MySQL data

I have the following: $verf = "SELECT nro_transf FROM pedidos WHERE nro_transf = '$nro_transf'"; $result = mysqli_query($db, $verf); $rows = mysqli_num_rows($result); $verf2 = "SELECT nro_transf FROM pagos WHERE nro_transf = '$nro_transf'";...
asked by 16.11.2018 / 16:49
0
answers

multiple query in JAVA - SQL

I am executing this query in java to a database in SQL, if I do the query in the following way, it runs without problems: String consulta= "SELECT * FROM Produccion.Transferido WHERE WO = '"+jTextIngresoWO.getText()+"'"; But I need the qu...
asked by 15.11.2018 / 16:39
0
answers

VBA Access - Error in product search engine

I am preparing a product search engine in a table. I want to know if there is a product unless it meets the given condition. If in the input of the function I put a 'c' I would like to know if there is at least one record that contains a text...
asked by 05.11.2018 / 16:02
1
answer

When I make a query within a function to assign the result to a variable, if the query does not return anything, does it save a null value?

SELECT c.horas_aportadas INTO horas_aportadas_coordinador FROM voluntario c WHERE new.id_coordinador = c.nro_voluntario; In that code, the id_coordinador is an attribute that can be null, so if it is then the query does not return anyth...
asked by 20.10.2018 / 19:11
0
answers

Help, why does the error: missing right parenthesis in Oracle?

I have the following query that shows me the name of RESPONSIBLE and ALTERNATE of a service the field TYPE RANGE, can have the values 1 or 2, where 1 = RESPONSIBLE and 2 = ALTERNATE SELECT E.NOMBRE_TRABAJADOR RESPONSABLE,...
asked by 08.10.2018 / 03:51
1
answer

redirect By htaccess with querys

I currently have this type of URL and it works fine:     www.example.com/flower The full path of the example is: www.example.com/indexmodelo.php?carpeta=flower But previously the route was conformed through the IP instead of the FOLDER:...
asked by 24.09.2018 / 17:19
0
answers

does anyone know how to execute deferred MYSQL queries in PHP?

I have two related tables (Employees with primary key AI and Role with primary key AI and foreign referenced to the primary Employees) and not to generate inconsistencies in the data or in the autoincrementable key I want to do in the same PHP:...
asked by 23.09.2018 / 05:00
1
answer

Join result of two queries in SQL Server without repeating records

Dear ones have a good day, my question is as follows. I want to join the results of two queries that coincide in columns and data type, as a first option I came up with a UNION, my first query is the following: SELECT T1.ArrivalDate AS...
asked by 15.09.2018 / 19:16
2
answers

Input shows the result on three selects

Good morning I'm doing the insertion of orders and I need some help. The idea is that according to two selects the result has to come out in an input. On the one hand we have the producto that is in the table productos +----+-...
asked by 13.09.2018 / 08:52
1
answer

UPDATE from a query with conditions

with this query: SELECT id AS wrcId, st AS wrcSt, detail AS wrcDetail, CONVERT(SUBSTR(detail,(LOCATE('#',detail) +1)), UNSIGNED INTEGER)AS ordenId FROM box_12.warehouse_rc WHERE LOCATE('#',detail)>0 AND id IN( SELECT id FROM box_12.esal...
asked by 08.09.2018 / 02:33