Questions tagged as 'sql'

Tagged questions
0
answers

Error making Group By in MySQL

I have a table which contains the places where different people have been, I'm trying to get the last place where each of those people was in a single table, for this I'm grouping by IdEmployed and looking for the major date, those two If I get...
asked by 04.09.2018 / 22:22
0
answers

Divide records by a column in a SQL Server view

I'm working with a view in SQL Server and I currently have the following: I get in a row the sum of the allocation of hours of the employees and the machines for each task. Example of a record: 0ba22dd5-0041-4a85-91622bc6f-3213-46c...
asked by 28.08.2018 / 09:29
0
answers

Error sending data to MYSQL via AJAX and PHP

I am sending the data of a form, through ajax and php to my database: If I try a single variable or 2, if it works, if I add the rest, it does not work. My Ajax code is as follows: $.ajax({ type: 'POST', url: 'php/enviar_pedido...
asked by 27.08.2018 / 13:27
0
answers

Sort MYSQL Concatenated values

I need to order some concatenated values with GROUP_CONCAT but the first concatenated value is not what I want to sort. This would be the SQL code SELECT objects.*, GROUP_CONCAT(mvalues.value SEPARATOR ', ') as value, GROUP_CONCAT(mdescriptor...
asked by 08.09.2018 / 15:48
0
answers

Function within an if else

I have the following function in PHP function verificar_status(){ global $db, $username, $usua, $ci_nro_cuenta, $monto, $nro_transf, $banco_emisor, $banco_destino, $fecha_transf, $status_pedido, $fecha_pedido, $status_pag...
asked by 08.09.2018 / 17:53
1
answer

Decimals in SQL

I need to know how to make prices go like this: 1,250.00€ Now in the BD I have it put like this, decimal(10,2) and it looks like this: 1250.00€     
asked by 27.08.2018 / 11:34
0
answers

MySQL Wildcards in Android Studio

I have made a query in MySQL and it works perfectly until the wildcard% is introduced in front of the text to be searched with LIKE (behind it goes well) This is the query: SELECT id_ave, DATE_FORMAT(fch_ave,'%d/%m/%Y') AS 'fecha', zon_a...
asked by 27.08.2018 / 10:02
0
answers

API - several records from a database with postman

I try to query a database using EJB using eclipse oxygen. At the time of making the request, GET , in postman, always brings me a record. When I consult SQL, it shows me the 3 existing records. Do you need to make a pre-request scr...
asked by 20.08.2018 / 17:13
0
answers

my Android application does not connect to my SQL Server

I am making an application for User Logging, when running the emulator I can register users, check the users' stock in my Database , but when I run the application on my phone, I do not know connect to my Database . This is my connection co...
asked by 18.08.2018 / 18:06
0
answers

Switch from hash to password_hash in sql

I'm having problems, at the time of making and passing the hash pass to password_hash () to do the validation using password_verify (); The fact is that I have changed the php version to the last one, and can not log in. Your registration has...
asked by 20.08.2018 / 10:25