Questions tagged as 'sql'

Tagged questions
1
answer

Error registering on form

When you select the value and I'm going to register, it tells me an error.    System.ArgumentException: The value "System.Object []" is not of type "BlogWeb.Models.Compra" and can not be used in this generic collection.   Parameter name: valu...
asked by 13.10.2017 / 19:26
1
answer

I can not see the elements of a table row

I'm trying to view elements of a row in my table, only separately. And I have not been successful. Follow the code: <?php require_once("conexao.php"); $id = $_POST['idlicita']; $query = "select * from licitacao where idlicita = $id";...
asked by 29.09.2017 / 17:40
1
answer

left outer join in a clause or

I have a problem with a query, which I need to do a left outer join of one table with another, or considering values as 0, if that's the case, basically what I was doing was as follows. select B.coluna from A, B where A.coluna = B.coluna(+) or...
asked by 09.10.2017 / 21:20
0
answers

Accentuation with multipart / form-data form and sql server using ajax

Hello. I have a problem that is making me sleepy. I am working on legacy code in classic asp and need to register a form that contains pdf file and data (like name, surname) and other fields. When the page is submitted to the server (iis8) via t...
asked by 09.10.2017 / 20:41
1
answer

SQL query too slow in OpenEdge bank, what can it be?

I am having difficulty running queries on the OpenEdge 11.6 database. Several queries take a long time to execute, sometimes almost 2 minutes. Here is an example query I'm trying to perform: SELECT docto_item.cod_fil, count(*) qtd_item, sum...
asked by 26.09.2017 / 21:00
0
answers

Error 1452 mysql: foreign key error

I have created two product tables with tbl_produto and tbl_adiciona , so instead of every time I want to update inventory, I do not have two equal data in the product table, but in an external table. <!-- language: lang-sql --&...
asked by 22.09.2017 / 21:13
1
answer

Select values from another table with more than one row in WebSQL

I'm using Ionic + Cordova + WebSql. I have basically these tables, partners and partnerEnderecos. The address table can contain more than one row for each partner. How do I return these values? I create the tables like this: databaseValues....
asked by 22.09.2017 / 17:38
0
answers

Best way to build a class to execute a SQL package

I am mounting a database access layer and need to access the functions inside a package on the oracle server. The orm already connects to the database and accesses tables and procedures through their respective repositories and entities. I...
asked by 22.09.2017 / 17:33
1
answer

Problems connecting Postgres with java [duplicate]

Well, I'm having a problem connecting to my java application with my database (I'm using pgAdmin4 which basically is postgres). Java code: public class ConnectionFactory { private static final String DRIVER = "org.postgressql.Driver"; pr...
asked by 06.10.2017 / 23:52
0
answers

Change MySQL query to work in SQL Server and Oracle

Would anyone know how to tell me how this MySQL query would look like in SQL Server and Oracle? SELECT COUNT(*) AS TOTAL, SUM(EVENTO = 7 AND RESULTADO = 0) AS QTD_RX_OK, SUM(EVENTO = 7 AND RESULTADO <> 0) AS QTD_RX_ERR, SUM(...
asked by 25.09.2017 / 16:48