Questions tagged as 'sql'

Tagged questions
1
answer

Error java.lang.ArrayIndexOutOfBoundsException: 0

I have this program Class UploadImage package Pruebas; import com.mysql.jdbc.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import javax.faces.application.FacesMessage; import javax.faces.bean.ManagedBean; im...
asked by 21.02.2018 / 20:25
1
answer

How to get the cumulative total value of a month in SQL

I have the following question with SQL: I want to take out the maximum month of purchase of a certain article. With this consultation, the purchase of the item accumulated in THE LAST 12 MONTHS: SELECT ARTICULO.ARTICULO, ARTICULO.DESCRIPCIO...
asked by 21.02.2018 / 15:56
0
answers

get data query sql

This is my database. link I'm trying to make a query that shows images and names of artists and I also want to get a list of all the songs or singles, all in the same query. SELECT a.* FROM discografica.cancion a INNER JOIN discografica.s...
asked by 20.02.2018 / 23:31
3
answers

How to optimize sql query?

I happen to have a table with n records ... 20 for example ... Of those 20, 5 records belong to 4 people, that is to say that there are 4 people who were registered 5 times in that table, for a total of 20 (by way of example) ... The query that...
asked by 22.02.2018 / 15:28
1
answer

Error in SQL order: Delete where id in list

I'm trying to delete the rows of a table that correspond to the id (varchar) '938110842071146496', '938110904666853378', '938195226333777920', '938309442671665152', '938777508123734017' For this I use the following SQL command: DELETE FROM...
asked by 04.03.2018 / 15:45
2
answers

How to fill gridview asp.net c # sql from behindcode? [closed]

I have a webform application in ASP .NET with C # and I want to fill a gridview from the webform.aspx.cs. There is some way to fill it "only" when entering the page, or it must be only with a click event. Could you tell me how to do it? I will g...
asked by 07.03.2018 / 18:37
1
answer

What is the correct way to deal with / avoid sql TimeOut error?

I was developing an application in which I launch queries automatically, consecutively, always the same. The problem comes when the DB is slow to respond, in some way, without knowing why, perhaps due to the traffic or the amount of informati...
asked by 12.02.2018 / 09:26
1
answer

Avoid session tracking in Java

How can I avoid session tracking ?. Since I have an application every time you enter the login page remember the password and contraseña . To go to the page of login I use response.sendRedirect("login.html");...
asked by 19.02.2018 / 16:22
1
answer

Replace Mysql does not work

When I try to replace all records in a field, it indicates a syntax error which I do not understand, this is the query. UPDATE tabla SET campo=REPLACE(campo,'\.',''); And I get two alerts 1 - A new declaration was found but there is n...
asked by 14.02.2018 / 14:04
2
answers

Apply interfaces in C # to link to database

I have this big problem and it's that besides being new to programming, it's quite difficult. The subject is the following, I need to apply MVP to a small desktop program that I am developing and for this I need to completely unlink the view lay...
asked by 10.02.2018 / 21:08