Questions tagged as 'sql'

Tagged questions
1
answer

How can I list with GridView avoiding duplicates?

Good morning, my problem is as follows. I'm making a system in which I have to add Containers, and those containers have materials in turn. The data when being registered are stored in a database. Choose to create a "material" table...
asked by 29.06.2017 / 19:23
0
answers

NullPointerException with Ucanaccess

I have a problem, which is that the following code throws me a NullPointerException in: pstm = connection.prepareStatement("SELECT * FROM usuarios"); I enclose the complete code: package com.gmail.brunodiazmartin5.banco.mysql; imp...
asked by 27.06.2017 / 22:01
0
answers

PHP Notice: Undefined index when generating report with PHPExcel

I am generating a report in Excel, however, when I try to add two columns and show them in: sumHoras = dateInput + dateExit a) The result is successful as long as the operation is carried out in this way: -> setCellValue ('I'. $ i, abs ($ dat...
asked by 27.06.2017 / 21:22
1
answer

Problem when creating query from Java

Yes, look at it I have it in the following way: public void borrarPersona(String dni) { Connection c = null; PreparedStatement preparedStatement = null; //Usando consultas preparadas, más seguras y más rápidas...
asked by 28.06.2017 / 12:56
1
answer

parametrize sql in asp classic

Good morning, I am doing a modification of a web written in asp classic and I need to make changes in that web to implement certain security until we move to a more current version and one of the things that I have been asked is to parameteri...
asked by 28.06.2017 / 08:57
0
answers

Script tracking in SQL Server Profiler

Because when I execute this stored procedure, it behaves like this: Since C # happens like this declare @p2 char(13) set @p2='AGB17920' exec sp_nuevo_codigo @CodGrupo='AGB',@vcodarticul=@p2 output select @p2 In Visual Fox Pro it goes lik...
asked by 22.06.2017 / 16:25
1
answer

It is possible to effectively use CREATE ROLE and its privileges, GRANT and REVOKE within a function in postgresql (version 9.4))

I have to build two functions to use in the creation of roles and in assigning a role to a group according to its category in postgresql. Here's the code: The first function is to create a user and call my second function that will assign t...
asked by 03.07.2017 / 22:20
0
answers

Doubt with Collate in SQL statement

I have a question with this statement when creating a table: 'uid' varchar(100) COLLATE utf8_unicode_ci NOT NULL, I am used to working with classes int auto_increment. I have read the documentation but I am not entirely clear about the us...
asked by 17.06.2017 / 10:25
0
answers

Does not save the value and the Empty query error appears

If there is a value in the sql query, it does not take the value of the query in the variable $acd0 while (true) { $t= "SELECT MAX(id) AS id FROM accidente"; $query2=mysqli_query($db,$t); while($acd=mysqli_fetch_array($query2)...
asked by 16.06.2017 / 18:48
0
answers

Subtract in PM and AM format in Sql Server 2008

Thank you in advance. I'm going around trying to subtract PM from AM The difference of format AM to PM the result is correct; however when rest of PM to AM the result is not the expected one The insertion in the BD I do it this wa...
asked by 21.06.2017 / 22:24