Questions tagged as 'sql-update'

Tagged questions
1
answer

Check duplicate items and update a column in all but one

I have a table of products that bring information from an XML, and another table in the system that basically receives these products after approval (we have an interface to define what goes in or not, basically changing a value in the product s...
asked by 15.12.2016 / 16:19
1
answer

Update on a table row

I'm starting to use SQLite in a project and would like some help on how to update on a particular line, in this case, only one ID will be updated at a time. Follow the codes: View and where the update button is clicked: @Overri...
asked by 28.11.2016 / 17:07
1
answer

Error in the Change method - Java and MySQL

Java masters, I'm working on a college project, using MVC layers, and I'm having problems with the client-change method. When I click the Change button on the form, it sends a message saying that the client has changed successfully, but when sea...
asked by 13.10.2016 / 03:40
1
answer

CRUD U can not get ID and edit Update

People need a light to unfold a TIMESHEET. I have the following code. <form method="post" action="includes/input.php"> <button type="submit" class="btn btn-primary" onClick="send('login');" value="login" >Default</button&...
asked by 16.09.2016 / 00:45
2
answers

Update command does not update table

I have a problem with my CRUD. My code looks in the DB and returns the data to the screen correctly, the problem that when I save it, it does not update the DB and it also does not display any error messages. Here is the code for the data pag...
asked by 13.06.2016 / 13:22
1
answer

Error in UPDATE function

I'm having this error while trying to run this update:    Fatal error: Uncaught exception 'PDOException' with message   'SQLSTATE [42000]: Syntax error or access violation: 1064 You have an   error in your SQL syntax; check the manual that co...
asked by 03.06.2016 / 03:08
0
answers

Symfony2 - Problems with Doctrine2's PreUpdate

My entity Budget has some methods that run on PrePersist and PreUpdate . They are: /** * @return \DateTime */ public function generateNextPaymentDate() { if ($this->getStartsAt() !== null) { $date = new \Da...
asked by 02.11.2015 / 02:07
0
answers

Routine to validate if date is earlier than today if it is to change the state of the field to complete

I need to do a routine that checks if the end date of a certain event has already passed, ie if the date of the "end" field is less than today's date, it updates the "status" field to "finished". I'm working with codeigniter 3.0 The...
asked by 29.07.2015 / 18:41
1
answer

Test UPDATE in Postgres

The idea is to do a search with the result of BEFORE, execute UPDATE with the appropriate changes and perform a new search with the DEPOIS, then undo all changes, a test for UPDATE. SELECT id_evento, id_statusevento FROM syo_evento WHERE id_ev...
asked by 12.01.2018 / 12:17
1
answer

Get a value from another field other than id

I have the following tables: 1 - AssignmentsLogs with the following fields: Id, OrderNode, Contributor and DataAtribution. 2 - StateLoves with the following fields: id, StatusId, and Status. The OrderID is equal to the IdEst. Now I w...
asked by 05.01.2018 / 18:45