Search update

60548 results
6

votes
3

answer

MYSQL INSERT or UPDATE IF

Been looking around the web for a while now and don't seem to be able to come across anything similar to what I want. I know it's something to do with the way I'm writing my query but any help would be appreciated. The basics of what I am trying to do is: Insert some items into a table if it does no...
roadkill247
5

votes
4

answer

Timestamp without change on update

In mysql I have a timestamp with the field name added_on. I created that for a table of leads for a crm. But it's getting updated whenever I update a lead. I only want the timestamp to show only the added time. I dont want that to get updated everytime when I update or make changed in the lead. Note...
Bala.C
2

votes
1

answer

pymongo update is not working

I try to perform a simple update but data is not updated in the db. In the following code snippet, I am: creating a new account and inserting it into the db (success), retrieving it (success), updating it (fail) It is all done at localhost, default instance, no replica involved. I followed documen...
Tzury Bar Yochay
2

votes
1

answer

How to update CloudKit Subscriptions

I am trying to make a messaging app using iOS, Swift, and CloudKit. I have successfully made it and I have push notifications sent whenever somebody adds another message. However, I would like for the push notification's text to say what ever was on the message. Here is what I have tried: Default co...
Pranav Wadhwa
2

votes
3

answer

Spring data mongo bulk update

Bulk updates are supported from spring-data-mongodb from 1.9.0.RELEASE. BulkOperations ops = template.bulkOps(BulkMode.UNORDERED, Match.class); for (User user : users) { Update update = new Update(); ... ops.updateOne(query(where('id').is(user.getId())), update); } ops.execute(); mongoTemplate has...
Shuying Zhang
3

votes
1

answer

MySQL Update Ranking and Ties

I have the following table: Rank RankTies TeamName WinningPercentage TeamA 1000 TeamB 1000 TeamC 500 TeamD 250 TeamE 250 TeamF 250 TeamG 0 I would like to use a stored routine to rank these by WinningPercentage DESC so the updated table should be: Rank RankTies TeamN...
user1822391
1

votes
2

answer

Update or change typeahead data

I'm using this typeahead library: http://twitter.github.io/typeahead.js/ I managed to create a sample same as they have on their page with having local values. $( document ).ready(function() { var globalResults = ['Alabama','Alaska','Arizona','Arkansas','California','Colorado','Connecticut','Delawa...
Ricsie
2

votes
0

answer

how visualize mysql update php

I am inserting images to mysql database from xml. is there any solution to visualize the process. for example loading percentage or some jquery Progress bar. i tried to change the progress bar value as each product updates but iti is not working.
Iva Kobalava
28

votes
4

answer

Update MongoDB collection using $toLower

I have an existing MongoDB collection containing user names. The user names contain both lower case and upper case letters. I want to update all the user names so they only contain lower case letters. I have tried this script, but it didn't work db.myCollection.find().forEach( function(e) { e.UserN...
sveatch42
5

votes
1

answer

EntityFramework CodeFirst Database doesn't update

One day ago I started using Entity Framework CodeFirst in simple Windows Forms project (C#). I created two models: [Table('SavesSet')] public partial class Saves { public Saves() { this.SkillsSet = new HashSet(); } [Key] public int SaveID { get; set; } public string Player { get; set; } public int A...
ahawkthomas
2

votes
1

answer

mongodb update (inserting new field)

I have a DB like: { 'a' : [ { 'name' : 'john', 'phone' : 111111 }, { 'name' : 'doe', 'phone' : 222222 }, ], 'b' : [ { 'name' : 'john', 'phone' : 111111 }, { 'name' : 'doe', 'phone' : 222222 }, ] } now I want to add a new field, 'state : 1' to all the entries (like name, phone) any suggestions on the...
Lem0n
1

votes
2

answer

sql update giving wrong results

I have the following sql statement in VB.NET Dim READER As SqlDataReader Try konneksie.Open() Dim Query As String Query = 'Update blokkeklaar ' & _ ' set Klaarvb = 'JA' ' & _ ' where KlaarEZY = 'YES'' & _ ' Update blokkeklaar ' & _ ' set Klaarvb = 'NEE' ' & _ ' where KlaarVB IS NULL' COMMAND = New...
Gideon
10

votes
3

answer

MYSQL - Update an entire Column

I wanted to ask if there is a way to update an entire column with the same value. I want to run '0' down a column or '1'. I can use a php loop to do it but it will involve multiple DB calls etc. Hopeing for a SQL statement that can run the same value down an entire mysql column. cheers
Adam
2

votes
1

answer

Why don't these DataBindings update?

I have created a class for adding numbers: public class Add { private int num1; public int Num1 { get { return num1; } set { num1 = value; } } private int num2; public int Num2 { get { return num2; } set { num2 = value; } } public int Result { get { return num1 + num2; } } } And created TextBox to...
mibtrex
2

votes
2

answer

Update SQL MS Access 2010

This is wrecking my brains for 4 hours now, I have a Table named BreakSked, and I this button to update the table with the break end time with this sql: strSQL1 = 'UPDATE [BreakSked] SET [BreakSked].[EndTime] = ' & _ Me.Text412.Value & ' WHERE [BreakSked].AgentName = ' & Me.List423.Value _ & ' AND [...
Serfreedshaft
3

votes
1

answer

iOS CoreData update entity object

I'm implementing a car manager for an iPhone app and I have trouble saving a new car. So I have a 'Car' entity (and per-loaded DB), containing multiples attributes. I have 2 booleans 'saved' and 'selected' to track which car the user added to his list (if added, saved = 1) and which car is currently...
Dachmt
2

votes
1

answer

Update application in windowsphone store

I have an application, made in cordova, in windows phone store, which is developed for WP7 OS. If my new, updated version is also developed for WP7 OS, then everything works fine. Files, cache, images are still in app sandbox after update. Problem appears when I'm trying to make exactly the same upd...
norbert
2

votes
3

answer

update with the latest date

I have a table as shown below: I need to update them into the latest last_order_date, which the table can be shown as below: I have 20000 plus records, I need a query to update them at once. Thank you for spending your time to look at it.
user3094424
2

votes
0

answer

Cordova 6.3.1 plugin update issue

I'm making a cordova 6.3.1 app with Kapsel plugins. Now I'm trying to customise the default Kapsel login screen in the plugin's view and controller files. However, on running cordova prepare the changes in the plugin files are not replicated in platforms/android/assets/www directory as well as the a...
Mini Bhati
1

votes
2

answer

Update DB without creating duplicates

I am trying to retrieve RSS feed from Yahoo SQL API and storing it in a file through PHP. Here is the code: if( filemtime($cache) < (time() - 10800) ) { if ( !file_exists(dirname(__FILE__) . '/cache') ) { mkdir(dirname(__FILE__) . '/cache', 0777); } $path = 'http://query.yahooapis.com/v1/public/yql?...
amit
3

votes
1

answer

Can't update Google Drive file

I'm trying to upload a file to Google Drive using the the v3 Google Drive SDK: $this->drive() ->files ->update( $this->report->getId(), $this->report, // This is a Google_Service_Drive_DriveFile instance [ 'uploadType' => 'multipart', 'data' => file_get_contents($this->getLocalReportLocation()) ] )...
siannone
2

votes
1

answer

Update Annotation API not working

I am using update Annotation API in skobbler maps on Android for offline purpose. I change the annotation view and update the annotation via updateAnnotation API. SKAnnotation currentAnnotation = mAnnotations.get(mSelectedIndex); SKAnnotationView currentView = currentAnnotation.getAnnotationView();...
Charan
2

votes
0

answer

Django multiple model update/create

I am a beginning programmer in Django/Python and I am now looking for a way to robustly create and update my models. I would expect this is a very common problem. Some example code of how to do this the right way would be very much appreciated. Problems which I struggling with is that I am not sure...
arne
3

votes
2

answer

XCode 7.3.1 Update Not Installing

It looks like XCode came out with a new update. This issue seems to be persistent where the iTunes Store does not render the update even though it posts it in the 'Updates Installed in Last 30 Days' section. After I restart, I am then prompted to update again even though I have already done it twice...
tccpg288
1

votes
3

answer

An SQL Update Query Problem

I have two tables like that: Products(productID,categoryID,price) MarginOfProfit(categoryID,rate) Anytime we want to change prices of products of a category, we look their change rate and aplly it to original price. For Example: ProductID | CategoryID | Price 1 1 105 2 1...
dreamend
2

votes
1

answer

Android database - recreate after update

I programmed an app which creates a database when its first started. If I published it to the Google App Store, and provided an update to the app which also included a change in the database schema, the app would probably crash, since it might want to write into a table that doesn't exist in the old...
deimos1988
2

votes
2

answer

Emitting an expression on update

I have an expression (model) which is set through property binding from a datepicker. This expression I want to emit to the parent component with EventEmitter. What is the best way to listen to updates of the expression? Or is there a better way of emitting it? @Output() date: EventEmitter = new Eve...
Kasper Sommer
2

votes
2

answer

iOS prevent date/time update?

a relatively simple question that I've not been able to find a clear answer to. My app is more complex, but answering this question will suffice. Suppose you're writing a stopwatch app. When the user taps 'start', the app stores the current date and time in startTime: startTime = [NSDate date]; Wh...
Tim123
5

votes
1

answer

Update layout with the animation

I have a custom View inherited from LinearLayout. It contains a Button and a EditText. EditText has initial visibility set to GONE. When Button is pressed I want EditText to appear with animation effect. So I've made an ScaleAnimation and when Button is pressed I set EditText#setVisibility(VISIBLE)...
fixxer
0

votes
1

answer

execute constraint on update sql

I have a constraint that return datetime for a column (date). On insert work it! Now I would like update column date with new value of getdate() when an update statement execute. Any idea? My constraint: ALTER TABLE [tablename] ADD CONSTRAINT [constraintName] DEFAULT (getdate()) FOR [column] MY D...
Jimmysnn
107

votes
5

answer

Documentation Update, February 6th [closed]

It is time for 2017's first major upgrade to Stack Overflow Documentation — a new Discussion feature plus some other improvements to menus, spam-prevention, review audits and the ever-popular vote split view. View Previous Update Shipped Discussion Every topic now has a discussion page. The discus...
Kevin Montrose
0

votes
1

answer

SQLite record update speed improvements

I currently have trouble updating SQLite database records at scale within a healthy amount of time. I have a small database of about 70,000 records and I have some office personal using Navicat to filter the records and make some bulk edits to commit. When trying to perform an UPDATE on a large amou...
Chris Guarino
0

votes
1

answer

React: Update Component in Array

I have a React component that contains an array of child components. The parent retrieves data from a service and stores it in state. It passes an item from the data array to each child component via props. The child component includes functionality that updates a value in its data item. When it do...
Paul Taylor
1

votes
1

answer

Angular Http Observable doesn't update

Hey Guys i wrote a little backend which returns some data. Now i want to fetch this data with Angular Http and show new values when i post them in the backend. So the first thing that came to my mind were Observables but currently i can fetch the data onInit but when Posting new Data to the Backend...
Henry Sachs
0

votes
1

answer

Angular - Update Accordion with results

I'm currently trying to update an accordion from a search that returns an array. On the first load, the full set of results are correctly shown from a service. However, when I search I get the correct values in the console but even with ngModel it is not being updated. Any suggestions? // Snippet of...
jmckie
0

votes
1

answer

Refresh gridview inside update panels

i have a page which is inside update panel.it contains two gridview which are also inside update panels.i m binding them in page load inside !ispostback as well as other parts of code.when i bind only first grid it works fine but when i bind the second grid it refreshes the first one and it shows n...
smita kapse
0

votes
1

answer

Update SSBO in Compute shader

I am currently trying to update a SSBO linked/bound to a Computeshader. Doing it this way, I only write the first 32byte into the out_picture, because i only memcpy that many (sizeof(pstruct)). Computeshader: #version 440 core struct Pstruct{ float picture[1920*1080*3]; float factor; }; layout(std43...
Blank
0

votes
1

answer

Lazy update on Segment tree

Im having a problem which need a structure that can handle 2 operations: Change values of nodes from position x to position y to newValue. Get the sum of values from position a to b. The number of nodes is 50000 and number of queries is 50000. Im trying to implement IT tree with lazy update but i ca...
Minh Nguyen Duc
4

votes
1

answer

Mobile Application Upgrade/Update Framework

I am developing a few mobile apps for different platforms including Blackberry, Windows Mobile, Android and Symbian S60. I want my mobile apps to have the capability of checking for updates before starting and in case a new version is available, prompt the user to upgrade. Moreover in certain cases...
sharjeel
0

votes
0

answer

Update derived persistence.xml in eclipse

I'm trying to make my first web application on Spring+GWT and I use Maven plugin for Eclipse to build it. persistence.xml file lies in src/main/resources/META-INF, but there is also a derived file persistence.xml in src/main/webapp/WEB-INF/classes/META-INF. The latter is obviously used to create th...
weide