Questions tagged as 'sql-update'

Tagged questions
1
answer

Problem when performing update

I have on the site the system to register, list and edit users. Registering and Listing are ok, however, when trying to update a record, it does not change in DB and also does not return any errors. I already checked the connection and...
asked by 27.04.2017 / 22:13
1
answer

Delete or change sql data using php

I'm creating a page where some information will be uploaded, and that information will be transferred to a database and displayed on that same page, as follows: As highlighted in blue, I have created a list with options that the user can c...
asked by 13.05.2017 / 22:08
3
answers

Update with Laravel does not take the model id

I'm trying to perform a simple function to change the password of the user logged in using the code: $user = User::find(\Auth::user()->idusuario); $user->password = bcrypt($request['novasenha']); $user->save(); But, it does not wor...
asked by 06.09.2016 / 14:11
1
answer

Update object list via entity Framework

Good morning! I wanted to ask for your help just to see if there is a better way to do it. Today I have a list of objects of type    Formation_RelationLineDeletted and I make a foreach in this list, taking item by item giving the attac...
asked by 04.10.2016 / 17:22
1
answer

update multiple records with php mysql

I have a form that lists several records and I want to update the status field of these records but at one time but I can not. my for and code: <form id="form1" name="form1" method="post" action=""> <?php while($row_table = mysqli_...
asked by 18.07.2016 / 20:35
2
answers

When I do the UPDATE it saves in the bank correctly, but when I refresh the page the data comes out of the bank

I'm trying to retrieve data from a table inside an input where the user can be updated and save to the same table through UPDATE. I was able to do the UPDATE, but I edit the data by input and send, it saves in the right bank, but when I refresh...
asked by 02.08.2016 / 17:53
2
answers

How is crud to update records in SQL Server by Visual Studio C #?

I'm using this code, it does not error, but does not update the data public static int attLoja(LojaVirtual loja) { int resposta = 0; using (OdbcConnection conexao = ConexaoPadrao.CreateConnection()) {...
asked by 25.05.2015 / 19:17
1
answer

Error Code: 1406. Data too long for column 'txtContabilidade' at row 1

In MySQL .. I want to do UPDATE in a text field, it has about 300 characters and does not allow doing it, informed that it is too long. I have already tried changing the field type up to "Longtext", "VARCHAR (1000)" and did not allow it. Is t...
asked by 06.08.2014 / 20:24
1
answer

Update of holidays in SQL Server table

I have a SQL Server table called DM_Time. Her fields are: DtRef AnoRef MesRef DiaRef MesExtenso CodDiaSemana SemanaNumero IndFeriado And they already have in it days marked as holidays (in this case, IndFeriado = 'YES'). But what I was want...
asked by 17.08.2018 / 17:07
1
answer

Export Text field to Bytea in PostgreSQL

I could make an application to export the contents of a Text field to Bytea without problems, but as they are thousands of records I believe that if I do via SQL it will be faster. If this is possible of course. I have a table with a text...
asked by 27.06.2018 / 17:36