Questions tagged as 'query'

Tagged questions
1
answer

Query in SQL Server

When doing the following query select * FROM conta It brings up the columns, with id_fornecedor coming from the fornecedor table id | id_fornecedor | conta_status 1 | 1 | S I'd like to bring the name...
asked by 25.05.2016 / 13:55
1
answer

C # - Display search results in DataGridView (SELECT SQL)

Hello! I'm starting effectively in C # and I already have small projects. I can already connect to the remote database, I can already execute queries, I just can not get the result of a Select and show in a DataGridView. Honestly, if there is a...
asked by 15.03.2016 / 22:33
1
answer

Concatenate in the PDO query

I've heard that concatenating a query using PDO can cause slowness and even make the system vulnerable, is that true? I want to concatenate in query and am afraid to take certain risks. public static function read($tabl...
asked by 19.02.2016 / 20:04
2
answers

How to perform a SUM in Hibernate

I'm trying to do a select via HQL but Java can not identify SUM by generating the following error: java.lang.NullPointerException at org.hibernate.dialect.function.StandardAnsiSqlAggregationFunctions$SumFunction.determineJdbcTypeCode(StandardA...
asked by 19.02.2016 / 23:02
1
answer

Doubt with query in SQL Server

I have the following query in SQL Server, to return me a list of cities that I need. select IDCidade as "ID", case UF when 'RS' then '1' when 'SC' then '2' when 'PR' then '3' when 'SP' then '4' when 'RJ' the...
asked by 13.12.2016 / 14:32
1
answer

Error in mysql query

I'm on the clock without noticing what's wrong with my query. I would like you to give me some help SELECT 'recargas'.'valor_recarga' as saldo FROM 'contas_pessoais' INNER JOIN 'contas' ON 'contas'.'titular' = 'contas_pessoais'.'titular' INN...
asked by 26.08.2015 / 16:13
1
answer

Show only positive delay days in SQL query?

I am making an appointment where I want to calculate the number of days of delay in a due date, I would like to show only if there are days of delay, at the moment I am showing days that are not due for expiration, which should have been zero....
asked by 20.04.2015 / 21:15
2
answers

Problem inserting double value in MySQL

query += txtServidor.Text + "',";<br> query += double.Parse(txtVencimento.Text) + ",";<br> query += int.Parse(txtBanco.Text) + ",'";<br> INSERT INTO tbl_associados VALUES(10,'testando','001.318.555-55','categoria','ativo',...
asked by 30.03.2015 / 14:58
1
answer

Handling of values returned in the query

I need to "handle" the return of a SELECT as follows: - value recorded in the bank: www.dominio.com.br or www.dominio.com - value treated on page: dominio ; That is, I need to have query "remove" before and after th...
asked by 07.04.2015 / 19:55
1
answer

"Escape" externally loaded file string

Problem: I am trying to pass to the database a String containing the bytes of an image that was loaded externally to put into a BLOB field. As always, the bytes in the image have single quotes ' , double quotes " and backsla...
asked by 29.08.2014 / 21:58