Questions tagged as 'sql'

Tagged questions
1
answer

ERROR when bringing an image with PHP for a HERO of a web

I am getting the following error when I bring a URL with PHP in local to show an image of a "hero". It seems that I am using something obsolete. I've been googling but I do not really understand where the problem is. Can somebody help me? [De...
asked by 18.01.2018 / 16:59
0
answers

bring an image from sql server to android

good afternoon people, the consultation, basically it is, I have an image in a sql server database (varbinary), and I bring it through a json with a restful service done with node, along with other data; when I bring it from the json, I treat it...
asked by 09.01.2018 / 17:23
0
answers

Select Query On MySql

Good afternoon in advance greeting and thanks for your time I am in a company with a system "semi open" so to speak that only lets me manipulate the select, from but not the where of my queries this brings as a consequence, informa...
asked by 14.01.2018 / 21:57
1
answer

Create a trigger for a bitacora in postgresql and get data from 2 different tables after a delete

Hello, my problem is as follows I have two tables which are called connection and this has the following columns boxnum (pk) | date | partnum boxnum is the pk then there is the market table that has the following fields boxnumm (PK)...
asked by 10.01.2018 / 23:59
0
answers

Transform a table in MYSQL relating elements of itself with different format.-

I am using a corporate ETL of MYABCM to transform some Excel spreadsheets to MYSQL, the problem is that I do not know how to transform the table on the left in the table on the right. The logic is that the element in column F of the table...
asked by 08.01.2018 / 23:31
1
answer

pass rows to columns

I wanted to see if you can help me with this.    My query is as follows: select O.idgoOperacion [Operacion] ,uuu.Etiqueta ,uuu.Valor from Operacion O docDocumentoArchivo Doa on doc.iddocDocumento = Doa.iddocDocumento [dbo...
asked by 11.01.2018 / 19:39
0
answers

The SelectCommand.Connection property has not been initialized. MySql

It turns out that I'm working with SignalR, where in the html view I make the following request to the client: var myHub = $.connection.myHub; var direccionWeb = $("#direccionWeb").val().toString(); $.connection.hub.url = dire...
asked by 27.12.2017 / 18:51
0
answers

Change value 0 to 1 in sql using checkbox in php

I have a form with a checkbox and fields of an sql query like this: checkbox - registry data The checkbox must be checked or not depending on the value it has in the database. It is a tinyint field that I have put a conditional on loading...
asked by 27.12.2017 / 19:26
1
answer

Native development environment for Firebird databases

I am looking for a native development environment for Firebird databases, ie SQL Server Management for SQL Server or MySQL Workbench for MySQL. I hope you can help me. Greetings     
asked by 03.01.2018 / 17:23
0
answers

Adapt a .PHP file to .HTML to insert Javascript and filter tables

var busqueda = document.getElementById('buscar'); var table = document.getElementById("tabla").tBodies[0]; buscaTabla = function() { texto = busqueda.value.toLowerCase(); var r = 0; while (row = table.rows[...
asked by 21.12.2017 / 21:13