Search update

60548 results
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
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
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
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
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
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
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...
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
2

votes
2

answer

Hibernate Update does Not Update Anything

In theory, this code should set the new lock status to the users and get that written to the database: transaction = sess.beginTransaction(); String hql = 'update User set locked=:newLockStatus where principalId in (:userIds)'; Query query = sess.createQuery(hql); query.setBoolean('newLockStatus', l...
malaverdiere
1

votes
2

answer

Update statement doesn't update my data

I would like to update/edit my user data in Employee table in access database. When i complete the fields that i want to change (name , last name, etc.), it gives me data updated but when i refresh the table, the data hasn't changed - been updated. Changes i want to perform for example - Change name...
fkr
1

votes
1

answer

Document update conflict with CouchDB design update

I am trying create an equivalent of create/update trigger used in traditional RDBMs. create_ts is being created fine, however update_ts part is not working for me. 'updates': { 'add_ts': 'function(doc, req) { if(!doc){ var result=JSON.parse(req.body); result.created_ts=new Date(); return [result, '...
bioffe
1

votes
1

answer

MySQL update automatically a column after update

As the title says, I have a table with a column named last_update of type DATE. I want to make a trigger that set it to CURDATE() every time I update a row(set it for this particular row). I tried this: delimiter $$ CREATE TRIGGER before_customer_update before update on customer for each row begin u...
Grec Mihai
1

votes
1

answer

Update JavaScript after C# UpdatePanel update

I have a dynamically created block of JavaScript which executes on page load. The JS is inside a UpdatePanel. When the UpdatePanel is updated, I need to update my dynamically created JavaScript. This all works fine as when I view the generated source of the page, I can see the updated JS. My problem...
Dan Ellis
1

votes
1

answer

UPDATE MySQL via Form but no update

I'v been beating my head in the wall for the past 10 hours trying to get a simple form to update sql table data by id. I'm sure its something simple right infont of my face. If someone can slap my with the stupid stick id appreciate it! haha Goal- To be able to fill out the form below and update a r...
Jaxchief
1

votes
0

answer

For update with separate select and update

I'm facing an issue regarding for update query. I have two methods as following: The first one select rows and return a map contains primary key and value. public Map method1() throws SQLException { String sql = 'select * from table where col1='someValue' for update'; // ... do something and constr...
Pu Chen
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
1

votes
2

answer

SQL update on duplicate key update

I have asked this question Grouping and update large database table, but I didn't get the answer for this. I have a table: name, date, detail, no, and name, date, detail are together as PK. Somehow I need to update detail, and it is possible that there are duplicate key. Thus I need to sum the no fo...
DrXCheng
1

votes
2

answer

UPDATE foreign key using UPDATE query

I'm trying to update a column, which is a foreign key, I'm trying to set it to a 'NULL' value but the error says 'ERROR 1452: Cannot add or update a child row: a foreign key constraint fails. ' try { con.Open(); MySqlCommand cmd = new MySqlCommand( 'UPDATE tblcdsummary set PersonalInfoID = '' +...
Ekko
1

votes
2

answer

Time complexity: UPDATE … WHERE vs UPDATE ALL

I am having a database table DuplicatesRemoved with possibly large number of records. I execute certain operations to remove duplicates of users in my application, and every time I remove the duplicates, I keep a track of the duplicate UserID's by storing them in this table DuplicatesRemoved. This t...
Shambhavi
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