Search update

60548 results
3

votes
2

answer

Query update multiple rows

I have table with token, userName, StatusId. Before i insert any row in table for a specific user i would like to check if any rows with active status are there if so update it to inactive. I am unable to figure out how can i do this in LINQ. Currently iam retreving my values as the query below. va...
user1663996
3

votes
2

answer

JDBC SQLite Update

I'm new in jdbc sqlite. I would like to know how to execute an update. For example i have a table called people name, and occupation inside. Should i use PreparedStatement? PreparedStatement change = conn.prepareStatement('Update people set name = ? '); change.setString(1, 'John'); ResultSet rs = s...
Hoou
2

votes
1

answer

Eclipse RCP - Update

While creating the sample, I noticed very strange behavior and due to which I am somewhat stuck. I will explain the problem in 2 scenarios Scenario 1. Create two Plug-ins. Create two features. Create one product & include only one feature. Create a category and include both the features. Export the...
CuriousMind
2

votes
2

answer

Update with Subquery

i have a Problem with a query. I have a huge Table with Zipcodes from Germany called 'Postleitzahlen'. There is another table with Companies called 'Firmen' Structure is like this: Firmen ------ ID City State ZipCode Postleitzahlen -------------- ZipCode State Now I want, all empty ( '' or NULL ) St...
hubbl
2

votes
1

answer

Update TabLayout titles

I've got a TabLayout (from the Design Library) that is populated with 2 fragments (that both hold a list of items) through a FragmentPagerAdapter. The 2 lists are in connection with each other: They both hold a total of persons and in which list a person is, decides whether he/she is nominated or n...
Stefan de Bruijn
5

votes
4

answer

JavaFx ProgressBar doesnt update

I try to understand how to update a ProgressBar in a multithreaded environment. Iam doing something wrong here but I dont see what it is. This should simply fill up the bar every 3sec but it doesnt: Task task = new Task(){ @Override public Void call(){ for (int i = 1; i < 10; i++) { try { Thread....
Chromos
3

votes
1

answer

RethinkDB update transaction performance

I'm a newbie here and also newbie for rethinkdb. First of all, I'm sorry for my bad english and I have a questions about update transaction performance of rethinkdb. Im using Nodejs with Native JS API of rethinkdb. I need to handle with read file stream and get the data to update in rethinkdb. After...
Pikachu
2

votes
1

answer

OpenGL buffer update

Currently I'm writing a program that simulates water. Here are the steps that I do: Create water surface - plane. Create VAO Create vertex buffer object in which I store normals and vertices. Bind pointers to this VBO. Create index buffer object. Then I render this plane using glDrawElements and the...
Shot
1

votes
2

answer

Wix CustomAction update UI?

If I have a managed Wix Custom Action, is there anyway I can update a Control with the type of Text? I see that a progress bar can be updated by using the session.Message with InstallMessage.Progress, but I do not see a way for updating other UI.
Kyle
3

votes
5

answer

Android sqlite update row

Im trying to update a row in my table but the update function seems not responding. Is everything ok with my function, or i'm I somewhere wrong? public int editChild(int id, String name, String dob, int gender, double weight, double lenght, int color, int status) { ContentValues args = new ContentVa...
Darko
1

votes
3

answer

Java JScrollPane Update Image

I'm making a program that has an image that you scroll around on, and I can't figure out how to update the image if a button is pressed (For example: Adds a Green Ellipse to the image.) It already draws the image into the JScrollPane and you can scroll around, but when you click a button it doesn't...
Spencer H
2

votes
2

answer

MYSQLI UPDATE syntax error

I am receiving the error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'long='-96.7812', label='abc' WHERE id='2'' at line 1 Here is my code: $db=mysqli_connect($server,$username,$password,$dbname); if (mysqli_c...
Drew Z
2

votes
1

answer

Chrome update, AngularJS issue

I'm working on a kind of a big AngularJS project. After updating Google Chrome to version 33.0.1750.117, ng-show makes the whole page to blink. I mean, when it becames true, before the div becames visible (even if it's a small div) the whole page blinks. And in many cases it blinks every time I togg...
Bruno
6

votes
1

answer

Yii migration update

In a migration, I want to add an order column which defaults to the ID of the column. I tried the following: $this->update( 'item', // table array( // columns 'item_order'=>':item_id' ), '', // condition array( // parameters ':item_id'=>'item_id' ) ); But this just gives everything ID 0. (I'...
Michael Mior
2

votes
1

answer

Cannot update user

I'm using AspNetCore.Identity for manage the user registered on my application. I have two tables: AspNetUsers: is created by default UserDetails: new table which contains extra information for each registered user the UserDetails table contains an FK that point to UserId of AspNetUsers. The models...
Rockj
82

votes
7

answer

SQL Update with row_number()

I want to update my column CODE_DEST with an incremental number. I have: CODE_DEST RS_NOM null qsdf null sdfqsdfqsdf null qsdfqsdf I would like to update it to be: CODE_DEST RS_NOM 1 qsdf 2 sdfqsdfqsdf 3 qsdfqsdf I have tried this code: UPDATE...
user609511
2

votes
1

answer

Update Events Dynamically

i have a couple of queries regarding the fullcalendar by arshaw.. when i select a particular stretch of dates and give an appropriate title as shown here i get the event rendered in the calendar.. but when i want to save the event (I'm using asp.net) ie say after the user clicks on a save button,the...
anuguy
2

votes
1

answer

Update for JavaEE application

Our application are built on Spring boot, the app will be packaged to a war file and ran with java -jar xx.war -Dspring.profile=xxx. Generally the latest war package will served by a static web server like nginx. Now we want to know if we can add auto-update for the application. I have googled, and...
hguser
2

votes
1

answer

Conda cannot update - CondaHttpError

I've been trying to update my conda with the command line conda update --all -y but its returning an HttpError. I've tried several times even with fast internet but it still returns the following error. (C:\Users\User1\AppData\Local\conda\conda\envs\my_root) C:\Users\User1>conda update --all -y Fetc...
Mallan
2

votes
1

answer

update blob in java

when i want to update a blob column in my table i this error Result Set not updatable.This result set must come from a statement that was created with a result set type of ResultSet.CONCUR_UPDATABLE, the query must select only one table, can not use functions and must select all primary keys from t...
Javad Behrouzi
7

votes
2

answer

Fluent NHibernate - Unnecessary update

In a unidirectional many-to-many relationship between Registration and Item, where a Registration has an ISet ItemsPurchased and Item has no reference back to registrations (it's not a useful way to explore the object graph), when I look at the SQL being generated, I see INSERT INTO Registrations_It...
Carl Bussema
2

votes
1

answer

Mongodb update datetime field

I have written the following code to update a datetime field with today's datetime: User.update( {'email': email } , {'resetpwddateExpire' : new Date() }) The date part is updating correctly, but the time part is not. For example: if resetpwddateExpire starts as 2/14/2014 8:08:52 AM after the update...
sergioramosiker
3

votes
1

answer

TSQL A recursive update?

I'm wondering if exists a recursive update in tsql (CTE) ID parentID value -- -------- ----- 1 NULL 0 2 1 0 3 2 0 4 3 0 5 4 0 6 5 0 I it possible to update the column value recursively using e.g CTE from ID = 6 to the top most row ?
Tony
3

votes
2

answer

sqlite3 update row syntax

From the sqlite3 docs it looks like I should be able to use the following syntax to update a row in a database on my iPhone: NSString *dbFile = [[NSBundle mainBundle] pathForResource:@'database' ofType:@'db']; sqlite3 *database = NULL; if (sqlite3_open([dbFile UTF8String], &database) == SQLITE_OK)...
Iain Hemstock
3

votes
1

answer

OrmLite Update() vs Save()

When using OrmLite to add an entry into the database there seems to be two ways of doing it: dbConn.Insert(customer); and dbConn.Save(customer); When using Insert() the AutoIncrement ID field does not get updated, but when using Save() it does. If you use: dbConn.LastInsertId(); It will return the c...
Dru
3

votes
1

answer

Hibernate 4 schema update

I am migrating from Hibernate 3.x to Hibernate 4 in my Spring MVC project. In Hibernate 3 I used to have the following code: AnnotationSessionFactoryBean bean = new AnnotationSessionFactoryBean(); bean.setPackagesToScan(myPackages); bean.setHibernateProperties(props); bean.setDataSource(this.dataSou...
MChan
4

votes
3

answer

LocationManager.requestLocationUpdates add or update?

I am looking at LocationManager to get best location for periodical reporting location. I am curious about LocationManager.requestLocationUpdates method. What would it happen if I invoke this method several times with different minTime and minDistance without calling removeUpdates? Will it add new r...
sunghun
2

votes
1

answer

Knockout JS Update Color

I'm using Knockout observables to update span values located within table cells. I need to change the background color of the table cell when the new value is different from the old value. It seems when i subscribe to the observable i do not have access to the old value during an update. Is there...
sdowd
2

votes
3

answer

Laravel DB update exception

Im trying to get exception if update method failed i just check this try catch block it dont return any exception because this project id do not exist in my database i have only about hundred records. try { $project = DB::table('project') ->where('prj_id', '987654' ) ->update([ 'prj_status' => 'op...
2

votes
1

answer

WPF ComboBox update source

I have a ComboBox with country codes and phone numbers (+43.., ..) The ItemsSource is a list of Country objects with many properties (Code is one of them.) The DataContext in which the ComboBox is located is an object with the PhoneNumber property. When user selects a country in the list, I want to...
PaN1C_Showt1Me
2

votes
4

answer

Codeigniter method for update

$age=10; $id=1; $sql='update student set age=age+$age where sid=$id; I want to write this sql statement using Codeigniter how is that possible?Any native way in Codeigniter to do this? I am using Codeigniter active record
Reneesh Kurian
2

votes
2

answer

sql — select and update

I've being trying to amend the solution found in this tutorial to write an SQL query that both SELECTs and UPDATEs my table: enter link description here DECLARE @column1 varchar(2); SET @column1 = (SELECT `Id`, `Url` FROM `MyTable` WHERE `Retrieved` = 0); SELECT * FROM `MyTable` WHERE `AdId`, `Url`...
Baz
2

votes
1

answer

Update margin after RenderTransform

I have applied TranslateTransform on a control, but the control's margin remains the same. var margin = this.Margin; this.RenderTransform = new TranslateTransform(diff.X, diff.Y); if (diff.X != 0 && diff.Y != 0) { if (margin == this.Margin) MessageBox.Show('Margins are equal'); } I want...
Nikola Ninkovic
3

votes
2

answer

Update Multiple Firebase nodes

I need to update few nodes in firebase data which is posted from the server end.Need to update the node 'is_done' to 0/1 from the device end.I have tried with different solutions but all became futile i.e it is adding a different node outside the 'schedule' node. Code snippet I have tried private vo...
androlergic
3

votes
1

answer

Update ASP.NET panel asynchronously

I need some help with this problem: Situation: I've got a usercontrol (in SharePoint) that reads query string and processes it with an asynchronous event. While it's busy, a spinner is shown. After the event is finished, the updatepanel inside the usercontrol should update and show the message (+ hi...
RubenHerman
2

votes
3

answer

Bundle Update Unicorn Error

Rails 4.0.1 is available and trying to update to that version (currently on version 4.0) I'm running bundle update and it starts to work ok but then getting an error that seems to be about Unicorn so the whole thing is aborted. The error is as follows: Installing unicorn (4.7.0) Gem::Installer::Exte...
tommyd456
11

votes
3

answer

Update an existing JobDataMap

I have a Quartz job that has already been scheduled. I want to update the JobDataMap associated with it. If I get a JobDataMap with JobDataMap jobDataMap = scheduler.getJobDetail(....).getJobDataMap(), is that map 'live'? ie. if I change it, will it be persisted in the scheduler? If not, how do...
Paul Tomblin
2

votes
1

answer

d3.pack() transitions update

I am trying to apply a transition over a d3.pack(). Please check http://bl.ocks.org/3263043 I want to symbolize by a new paremeter, but when applying transitions, the new circles and its parents don't keep the structural 'harmony' anymore (some children circles are not contained anymore by its par...
user1249791
2

votes
0

answer

rich dataTable update issue

I have a problem with rich dataTable actually I populate that dataTable from a database and a made a column editable by putting an inplaceInput in it the problem is when i submit to the backing bean The values doesn't change the backing bean is populated with old values that initially populated the...
Diyae
4

votes
2

answer

UISlider Update inside UITableViewCell

I have a custom UITableViewCell that contains a UISlider control and a UILabel which shows the current text value for the slider position. I want to update the label as the slider knob is dragged. Here are the basic elements. cellForRowAtIndexPath: This routine takes data and updates the slider val...
Voripteth