Questions tagged as 'query'

0
answers

Repeat Query in Access

I need to open a form when a query is executed automatically. I do not know how to do this, I found Macro AutoExec but I do not know if it has any relation     
asked by 19.10.2018 / 17:00
2
answers

SELECT Cursor using top1

I need to return only the highest value of one of the lines below, taking into account that I also need to submit the order code. I tried to run via cursor but without success. By the cursor would pass the 3 lines, but would need to con...
asked by 25.10.2018 / 23:42
0
answers

Error in query - Inconsistent data NCLOB

Hello, I'm trying to perform a query on an Oracle database and it is returning an error    ORA-00932: Inconsistent data types: expected - got NCLOB   00932. 00000 - "inconsistent datatypes: expected% s got% s"   * Cause:   * Action: T...
asked by 03.10.2018 / 20:52
0
answers

Parameter passing in JasperReport

I'm trying to pass the Id parameter to a query in the Jasper Report. The parameter is being passed, but I'm getting conversion error from the Conversion error: There was an unexpected error (type=Internal Server Error, status=500). java.lan...
asked by 24.09.2018 / 21:07
2
answers

Error fetching the result of a select

Someone can help me with this code. Give this error: Warning: mysql_fetch_array () expects parameter 1 to be resource, boolean given in /var/www/xxx/teste.php on line 14 Notice: Undefined variable: status in /var/www/santa/teste2.php on...
asked by 20.09.2018 / 14:58
0
answers

How to display the result of a mysql search where it returns more than 10mil result without crashing the browser?

I'm currently using the jquery table to display the results, but it takes a long time to display all the results and while the search does not finish the browser sometimes crashes. have some better way of showing results but without crashing you...
asked by 13.09.2018 / 15:27
1
answer

Change variable in UPDATE PDO PHPERRO: PDOStatement :: execute (): SQLSTATE [HY093]

@$c_matricula = $_POST['numero']; @$data_aa = $_POST['data_aa']; @$data_ff = $_POST['data_ff']; if(isset($data_aa)){ @$dataa = date("Y-m-d H:i:s"); $pdo = $dbconn->prepare("UPDATE contato SET c_data_andamento = :data_a WHERE c_matri...
asked by 15.09.2018 / 23:22
0
answers

SELECT MySql Filter Status

I need a select in which to search for tipo status and responsave l, only that it is catching by several Status, while only needing a count status A count(if(r.reponsavel mae,if(t.tipo=1 ir t.tipo =2)if(t.status = '...
asked by 02.09.2018 / 04:56
0
answers

Comparing two tables in MYSQL and limiting the result based on the current date

I am comparing the data of these two tables pontos and pontos_view in practice, in the pontos table there is a list of tasks that when executed by the user, saved in pontos_view thus causing the user to not execute th...
asked by 08.09.2018 / 21:03
0
answers

Get the percentage between 2 in a Dynamic SQL query

Good afternoon I'm trying to get the % between months compared to the year after, so in month 1/2016 value was 2115.00 month 01/2017 value was 3511.00 take the percentage between these 2 and make the margin / percentage the...
asked by 29.08.2018 / 17:26