Questions tagged as 'mysql'

Tagged questions
0
answers

Illegal hour value '58' for java.sql.Time type in value

I have a doubt with this problem apparently when doing the select and doing the operation with the method TIMESTAMPDIFF of MySQL I get the following error: java.sql.SQLException: java.sql.SQLException: Illegal hour value '58'...
asked by 04.05.2018 / 08:18
1
answer

Problem with mysql, node and module.exports

Eh. . . hello all over the world, they'll see I've been learning one day so if I come to say nonsense and be stupid sorry. I have a small site that I am connecting to mysql with node, but to unburden code I wanted to use module as in java but I...
asked by 12.05.2018 / 05:51
0
answers

problem when retrieving folder image to show it, not inside

My problem is that when I load an image even in a folder if it is saved in the folder from the form, but when I want to read it, it does not locate it and it is not the problem if in my bd the folder's address is being saved where my image is ho...
asked by 12.05.2018 / 13:30
0
answers

Problems to compare dates and send results in real time with AJAX and PHP

I'm trying to make a script to process a payment after a while. The idea was to keep the date of the moment in which the request for payment was sent and the date on which that payment should be processed. When that date is met, the system shoul...
asked by 04.05.2018 / 02:42
1
answer

Group by variable start and end date variable states

I'm working on a graphic of the Timeline type with the google charts API but I depend on a script that creates a new table ("new_tbl") but I do not want to depend on the creation of this one since I have to do it manually every time I want updat...
asked by 04.05.2018 / 00:18
1
answer

Fill a listview with an API

I have been trying to fill out a ListView with a MYSQL query but I do not have any favorable results, I want to implement the use of adapter and assign in the listview only the Name and Surname for each element but when I try to assign my data c...
asked by 05.05.2018 / 05:37
1
answer

Jquery library does not work correctly

I have this nested combobox that works with php and mysql: <script language="javascript"> $(document).ready(function(){ $("#bl3").change(function () { //$("#bl3 option:selected").each(function () { $("#bl3")...
asked by 02.05.2018 / 05:28
0
answers

Trigger error SQL 1242 (Reserved words NEW & OLD)

Next I am going to attach an image about the database on which I am working to perform the trigger and I begin to tell you Well, the idea was to create a trigger that, when I put all the data in an order, gave me the subtotal, with the fol...
asked by 03.05.2018 / 10:51
0
answers

VB.NET - MYSQL - Use 2 queries with an executequery?

I wanted to see if you can help me with the following: I have a method that updates the data of a table, it works well for me, but the issue is that I also need to update another table at the same time (the data is in common in both tables, a nu...
asked by 02.05.2018 / 12:50
3
answers

How to preload while loading something

When you load the page, there are things that take time to appear; so while loading a preload appears, it is not necessary to write the code of a preload, just put // Preload here. Pliz for example this sector with php. <section id="post"&g...
asked by 03.05.2018 / 04:36