Search update

60419 results
5

votes
1

answer

UPDATE vs UPDATE WHERE

I have a table with many rows, where I periodically want to set one column to 0 using a cron. What is faster / less memory consuming, doing an UPDATE on all rows (ie. no WHERE clause) or doing an UPDATE only WHERE mycolumn != 0?
Eduard Luca
1

votes
1

answer

Update for update?

Is there any way of doing a SELECT ... FOR UPDATE but with a nested update returning rather than a select? The scenario I'm thinking of looks a bit like: UPDATE cars SET model='myModel', ownerID=( UPDATE owners SET cars_owned = cars_owned + 1 WHERE name = 'fred' RETURNING id ) WHERE id = 'abc123'; I...
tengbretson
4

votes
1

answer

Update tsvector update trigger

I have the following tsvector update trigger for a tsvector column 'user_tsv' on a table that allows me to perform full text searches, CREATE TRIGGER tsvector_user_update BEFORE INSERT OR UPDATE ON users FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(user_tsv, 'pg_catalog.english', firstnam...
DaveB
2

votes
8

answer

Update query update not work

I am doing Add, Update and Delete in Php. Everything is working fine but My Update query is not working. Can I know, where i am going wrong in Update query? Here is my update.php file code..
Rahul Barge
1

votes
2

answer

Update progress inside update panel

i have two buttons inside a update panel.i need to trigger update progress and show a .gif image for each button click.when i press a button1 only the associated update progress should be displayed and the other one should be invisible
chamara
3

votes
0

answer

Tree conflict on update Update

I'm getting this while taking update in xcode. 'The operation could not be performed because of one or more tree conflicts. The file XYZ.xcscmblueprint had a tree conflict.' How could I get the path of '.xcscmblueprint' file in xcode. What to do to solve this problem. Thankyou in advance.
Roshanboy4u
3

votes
2

answer

execSQL() with UPDATE doesn't update

I am trying to use rawQuery and execSQL methods for manipulating my database, instead of the .update, .insert, etc. I am trying to perform an UPDATE with the following code: db.execSQL('UPDATE configuration ' + 'SET number_fields = ' + number_fields + ', ' + 'frequency = ' + frequency + ', ' + 'ag =...
TronicZomB
1

votes
1

answer

Android app update, assets update

I have an app and it uses .txt files from assets folder. In assets folder are more directories in some depth. Later I will want to add new files to this assets folder so I'll have a new apk(cause files in assets are part of the apk). The question: So what happens when someone, who is using my app...
Kalla
1

votes
2

answer

update-alternatives : update java path

I want to update the java path.After running the command sudo update-alternatives --config java I get following : Selection Path Priority Status ------------------------------------------------------------ 0 /usr/lib/jvm/java-6-openjdk/jre/bin/ja...
rachana
3

votes
2

answer

Using .update to update values

If we have a hash and we want to update one of the values or keys we can easily use the .update method like the following def foo(params) params+=1 end hsh = {:a=>1,:b=>2,:c=>3} hsh.update(hsh) do |key,oldVal| foo(oldVal) end p hsh However suppose a new hash, and I want to copy its properties into a...
bill
2

votes
1

answer

Core Data Update/AppStore update

I have an app in the AppStore which includes its own database. This database can be updated by the user. My question is, if I update with a new version y app, via AppStore, how can I mix old data with new data? I don't need to change the model, only mix data. Do I need to do a 'Lightweight Migrati...
jcpp7
1

votes
1

answer

PHP Update Query wont update

I'm trying to create a brute force protection on my login script. Although the query that's supposed to update the database that the account is locked wont work. I'm starting to get frustrated since I've been looking at this code for the last half hour.. Anyway here is the code: if(isset($_POST['sub...
Jake Snake
4

votes
2

answer

update div asynchronously ---update comments

i have a textarea as below @Html.TextArea('txtComments', new {@style = 'width: 450px;',@placeholder = 'Enter Comments here' }) and when user hits add am saving(user entered comments and time) to DB using JQUERY AJAX. After this i need to show the data in div above the textarea whatever user entere...
user2067567
7

votes
2

answer

update on duplicate key update

I have a table that contains a shop id and a player's id, and a player's points. What I want to do is transfer points from a shop to the other, the thing is that shop id and players id form a unique index. What I want to do is on duplicate key update, instead of let it fail, to add the points of one...
Deus Deceit
1

votes
2

answer

Update SubmitChanges() - does not update

With this code there is no change in my database. when the above code is run there is no longer a new entry created neither is an entry updated. public void UpdateCallback(callback cb_) { callback call = context.callbacks.Single(c => c.callbackID == cb_.callbackID); //call.callbackID = cb_.callback...
Sreedhar
0

votes
2

answer

Update Dropdownlist on listview update using update panel asp.net c#

I want to re-populate data of a dropdownlist using sql data source when i insert or update data using the Listview control. Is there a way that i can do this without having to refresh my page manually? pid: type: description: Priceday: Priceweek: Pricemonth: Pricesem: Priceyear: pid: type: descripti...
Mr.Turtle125
3

votes
1

answer

javascript update lost on first async update

I have an update panel that has a button with a handler: protected void btn_Click(object sender, EventArgs e) { ScriptManager.RegisterStartupScript(Updater, this.GetType(), 'Hash Update', 'UpdateServerData('' + avalue + '');', true); } and a javascript function: function UpdateServerData(val) { pare...
Charles
2

votes
1

answer

sql trigger perform update on update

I am trying to write an sql trigger that will update another table whenever an update is executed. This is actually used to replace replication (replication exists on our production environment but not on dev environment because it causes problems on dev). I've written following trigger to achieve t...
laureysruben
4

votes
2

answer

Sql server after update vs for update?

Im trying to understand whats the difference between after update and for update triggers? I know that istead of triggers can just override my current action. But I dont see any difference between after update and for update
Royi Namir
3

votes
0

answer

Nuget update did not update csproj file

When I update a Nuget package, it seems that my csproj file did not update properly. In this case, I'm updating NLog from 2.1.0.0 to 3.2.0.0, but after updating the package and building the solution, I'm still getting this in my csproj file: False ..\packages\NLog.3.2.0.0\lib\net40\NLog.dll The Refe...
Dhinnesh Jeevan
8

votes
4

answer

Update Panel PostBackTrigger, Update Progress not displaying

I have an update panel and update progress with a PostBackTrigger Event. But update progress is not showing when i am clicking on the button. please find the below sample code My code behind HttpResponse Response = System.Web.HttpContext.Current.Response; Response.ClearHeaders(); Response.AppendHe...
Bhuvan
3

votes
1

answer

Update join vs Update with sub query

I have 2 tables : Table A ID int, Name varchar, Address varchar Table B ID int, Name varchar, Address varchar, Col1... ... Col100 I want to update A.Name with B.Name based on both table's ID. UPDATE A SET A.NAME = B.NAME FROM A JOIN (SELECT ID, Name from B) AS B ON A.ID = B.ID UPDATE A SET A...
EagerToLearn
1

votes
2

answer

Kentico page update not update Physical table

I Have Kentico web site which has scheduler task that synchronise data with external Database. Basically few pages created from external database table. We have two methods for both create and update record in Kentico table. For create we use TreeNode page = TreeNode.New(Helper.ClassName_Campus);...
Mahesh
2

votes
1

answer

jsblocks update view upon data update

there is an object in my application , lets call it myObject , so myObject has some keys , and is being rendered in my html using jsblocks library. Due to lack of full documentation , I still can't figure out how to update my view upon updating this object from server side , for example : function f...
ProllyGeek
2

votes
1

answer

ClickOnce manual Update completes but doesn't update

I have a VSTO Excel Template project that is Installed/Updated by ClickOnce. If I run an automatic update it updates fine, but I would like to give the user the option of a manual update. The problem is that executing ApplicationDeployment.CurrentDeployment.UpdateAsync (or .Update) does not result...
QuinRiva
1

votes
1

answer

Update SqlCommand- Does not update in Database

this doesn't update in my database table. Have I over-looked something? The values are in the textboxes fine. No errors show, weird. using (SqlConnection connection = new SqlConnection(@'Data Source = UKMAN1NB10038\SQLEXPRESS; Initial Catalog = TheVets; Integrated Security = True')) { SqlCommand...
elszeus
1

votes
2

answer

update function failed to update record

I'm trying to execute the update action but I keep getting the error 'This specialize already exist' even though I put the name completely different. It appears that there's something wrong with my nested if in the Update action, but I used the same condition in the Create action but it works fine....
Acoustic Mike
1

votes
2

answer

Datamapper “Update” does not update record

I am having trouble with datamapper not updating a model. I can create and save models without issue. I have enabled raise_on_save_failure and checked the return value of update but see no errors. Here is the model: class UserProfile include DataMapper::Resource attr_accessor :id, :wants_hints...
nathan
1

votes
1

answer

composer update vs composer update --dev

composer --version Composer version 1.4.1 2017-03-10 09:29:45 and Composer version 1.4.2 2017-05-17 08:17:52 As per the composer documentation when you run composer update it runs by default composer update --dev --dev: Install packages listed in require-dev (this is the default behavior). But in m...
0

votes
0

answer

Bokeh - Update charts on database update

EDIT : I fixed the TypeError by using ColumnDataSource.data in the update function, the question is now if this is the right approach to solve the problem. I want to display a dashboard with info coming from a database, I'm new to Bokeh but I understood I need to run a Bokeh server application. My...
Alessandro Gaballo
1

votes
1

answer

wp-cli update plugin update deployment process

Extremely happy with wp-cli so far. One issue: I can't seem to update plugins locally, commit the changes to the remote repo and see the plugin status as updated on the remote server. This deployment process seems correct to me (git learner), but it seems to me now that updating the plugins via wp-c...
Jackson
1

votes
1

answer

combine multiple update statements into one update

I have a sql server 2012 database that has a table with a column called 'gameRoomText' with data that looks something like this: I need to get rid of all the rows that contain text like this: src='../images/nothing_null.png' So I start by getting rid of the string ' (media placeholder image)' : upd...
SkyeBoniwell
1

votes
1

answer

Room update query only update one row

I have a Book object with 3 primary keys (id, belongToTab, propertyOfUserId) Say, I have a database of book like this: book1(id = 10162, belongToTab = 1, propertyOfUserId=896) book1(id = 10162, belongToTab = 0, propertyOfUserId=896) In my BookDao interface I made a method like this: @Query('UPDATE B...
Tran Hoai Nam
2

votes
2

answer

Update Android Listview after Asynchronous update

I am converting my HTTP calls to asynchronous calls from synchronous ones. Because the connection is running in the background the data isn't there when I originally set my list adaptor. How can I get the list adaptor to update after my HTTP call? I've tried a few things like not setting the adaptor...
centreee
35

votes
1

answer

d3 update data and update graph

I have the following simple line in d3 but haven't an issue trying to figure out how to pass it data2 and update the line to reflect the change. D3 Line Chart Demo Update var data = [3, 7, 9, 1, 4, 6, 8, 2, 5]; var data2 = [3, 7, 9, 1, 4, 6, 8, 2, 15]; var width = 600; var height = 400; var max = d3...
Mike
2

votes
1

answer

Grails Foreign Key Update - Performance Update Object

I am creating a lot of objects and I am trying to get a bit of a performance boost. Currently I have an assignment for a gorm object attribute that I could get better performance out of if I could set the foreign key manually. For Example def oldBook = Book.findByTitle('Of Mice and Men') def newBoo...
davelt
12

votes
2

answer

package.config update does not update the references

I have multiple projects referencing the same NuGet Package. When I got latest code, I realized that one of the projects had an updated package.config and also updated reference to the Dll that is provided by that package. Now, I also updated package.config on other prjects hoping the as soon as I d...
Lost
2

votes
7

answer

Auto update your applications through Windows Update

Here is a scenario: User installs .NET application that you have made. After some time, you find a security issue in it and create a patch for it. When patch is ready, you post it 'somewhere', and when next Windows update is run on user's machine (automatically or manually), that application is upda...
1

votes
3

answer

Pre-update and post-update in Hibernate

I want to use preupdate and postupdate concepts in my application. The purpose is i want to get all values of a particulra record which is being updated and insert these values as a record along with new values in a table named audit. Can any one give some suggestions or pointers on this. Thanks,...
Narendra
2

votes
1

answer

Update scope value after dynamically update textbox

in AngularJS I have scenario that the user selects a value from a grid in a popup and selected value is displayed in textbox in container page. After the user select a value, popup raises an event which is captured in container page. Now I can set the value of textbox using .val() but how do I updat...
Haris