I want to insert from java in postgresql.
By bringing (and casting) a java.util.Date to java.sql.Date , it works fine, but at the time of inserting it, it marks me this:
ERROR: the column "fechab1" is of type date but the expr...
I have an error, and PHP does not return the query sql well.
This is what I do:
$(document).on('click', '.editarCliente', function () {
var idc = $(this).attr("id");
console.log(idc);
$.ajax({
type: 'POST',
url: 'php/edit...
I come to you because I already exhaust the options. I already checked the answers and none of them answered my problem to see if you see the error ... This is my code:
$Clave=$_POST["f_Clave"];
$Cantidad=$_POST["f_Cantidad"];
$Catego...
I need to do the conversion java.util.Date to java.sql.Date . I have tried the following:
private long convertirDate(java.util.Date f1) {
java.sql.Date fechaSalida = new java.sql.Date(f1.getTimeInMillis());
}
The problem is...
Thanks for your attention I would like to ask what the problem is in my code, I am doing a query with Java but when going to the preparedStatement it tells me that the connection is closed and can not execute any more operations (MySQLNonTransie...
It turns out that I am trying to parameterize a querie , apparently it takes the data but returns an erroneous result for example.
Select campo from tabla where nombre ='pepito'
Does not return anything
select campo from tabla whe...
I have a dropdown that when the user selects it, he asks for a column of one db.
The problem is that I can do SQLinyection with the same options.
Next to the dropdown I have a field that also queries the db but it is parametrized, I wanted to kn...
I recently worked with a code that connects to a database in mysql. Its functionality is to insert data to the previously created table and then with a button to give functionality to empty TxtField in Jframe to refill.
The error is shown to...
Good afternoon:
I request the collaboration to solve the following problem that I have with two files in java, one is called test and the other connections, the test file has a table that brings the data from the mysql database and with a click...
I am adding columns dynamically from rows with the following prepared statement in mysql.
SET @sql = null;
SELECT
GROUP_CONCAT(DISTINCT
CONCAT(
'SUM(IF(PC.id_competencia='
,PC.id_competencia
,',PC.puntaje,0) ) AS P...