Questions tagged as 'sql'

Tagged questions
0
answers

Doubt ORDER BY with INNER JOIN

Hi, I want to generate a classification of some equipment but I do not know how to do it so that they come out in a specified order, I do not know how to enter the ORDER BY. SELECT divisiones.id_eq1 AS Equipo_1, eq1.name_eq AS Nomb...
asked by 06.06.2018 / 11:39
1
answer

error when inserting a double value in a database

I try to make an insert of a double value into a database (MySQL) and it shows me the error: java.sql.SQLException: '∞' is not valid numeric or approximate numeric value Connection conexion = AdminConexion.getInstancia().obtenerConexion();...
asked by 17.06.2018 / 03:34
1
answer

help with SQL Server installation!

Hello, whenever I try to install sql server on my laptop I get the following error help please!     
asked by 04.06.2018 / 18:27
0
answers

Does not save image but inserts the name in the database

Good morning, I need to upload a file and save it in an "IMG" folder, when doing the process the insert in the database is correct but the image is not saved in the server, here is the code, I hope can you help. if(is_uploaded_file($_FILES['fo...
asked by 07.06.2018 / 16:48
0
answers

Why is the webSQL reading not executed?

I have this js on an asp page: <script type="text/javascript"> function onSend() { debugger; var paciente = {} var result = null; paciente.nhc = "151617"; result = getfingerPrint(p...
asked by 06.06.2018 / 04:08
0
answers

Add minutes in an SQL query

I have a "Programming" table with the following data (NOT MODIFIED): HoraInicio = 08:15 (Char 5), HoraFin = 12:15 (Char 5), TiempoPromedioAtencion = 15 (INT), IdProgramacion = 79647 (INT) I would like to know if there is any way to make a q...
asked by 05.06.2018 / 19:49
2
answers

How to modify this query in SQL

I have this query in SQL: SELECT datname FROM pg_catalog.pg_database WHERE LOWER(datname) = LOWER(BaseDatos); But I am running it from java with jdbc, and I need to pass the result of the query to a ResultSet, but the problem is that when t...
asked by 06.06.2018 / 04:37
0
answers

Content of sql table is not displayed in LookUpEdit Visual Studio

I have a LookUpEdit in which I want to show the contents of a SQL table. The code I have for it is: Sub mostrarLookUp() Try con.Open() Dim cmd As New SqlDataAdapter("select IDCON, Concepto from Concepto", con) cmd....
asked by 05.06.2018 / 00:46
1
answer

Help with select based on SQL criteria, and postgresql

I'm trying to make a query with sql under one criterion Well, let me introduce the code. include_once "conexion.php"; /* Ejecuta una sentencia preparada pasando un array de valores */ $id = 1; $sql = "SELECT * FROM users WHERE...
asked by 04.06.2018 / 03:35
2
answers

error when displaying PHP information [duplicated]

CONNECTION CODE <?php $cons_usuario="root"; $cons_contra=""; $cons_base_datos="test"; $cons_equipo="localhost"; $con= mysqli_connect($cons_equipo,$cons_usuario,$cons_contra,$cons_base_datos); if(!$con) { echo "<h3>No se ha pod...
asked by 05.06.2018 / 18:47