Search update

60548 results
1

votes
3

answer

update keys in scala

I have to update keys in a map based on certain condition. values will not be modified. I have ended up with this code, but doesn't look neat to me, is there any better alternative of doing this: val newOpt = inOpt('type') match { case 'mydb' => inOpt map { case (key, value) => ( if (key.contains(X...
Garipaso
2

votes
2

answer

Multi-table Update(MySQL)

I have a question regarding multi-table update(MySQL). Consider table t1 and t2. The PKEY for t1 is 'tid' which is a foreign Key in t2. There is a field 'qtyt2' in t2 which depends on a field called 'qtyt1' in table t1. Consider the following SQL statement: UPDATE t2,t1 SET t2.qtyt2=IF(( t2.qtyt2-...
smokinguns
4

votes
4

answer

MongoDB 2.6 Update Error

I am getting conflict when [[email protected] ec2-user]# sudo yum install mongodb-org Loaded plugins: priorities, security, update-motd, upgrade-helper Setting up Install Process Resolving Dependencies --> Running transaction check ---> Package mongodb-org.x86_64 0:2.6.0-1 will be installed --> Process...
Rahul
2

votes
1

answer

Yii2 Update Parent Child

I have a structure table like this I want to change record data field goid = 1, but I as you can see my code bellow, there's limit looping. Is there a better way to do it? public function actionShareGoid($folder) { $one = DokumenFolder::findOne($folder); $one->goid = '1'; $one->update(false); $model...
Yuki_Kurokawa
2

votes
1

answer

Update datatables using relation

I try to update two tables using a relation and table adapters generated in dataset designer. But unable to perform child table update, it is not inserted, the problem is that during child table update the identity column value is unknown. Table 'Users' has primary key and identity column UserId. Ta...
Lukas
2

votes
4

answer

SQL Update - Everything inside ()

I have a column of data containing a string with the following format: blablablabla(XYZ) and I would like to discard everything outside the () - and the parenthesis themselves - and to set update that field with the value inside the (). This implies that, in this particular case, the 'blablabla' wou...
João Pereira
5

votes
3

answer

Wrong update limits mysql

From this question: update multiple rows using limit in mysql? I made this code up for a MySQL query: UPDATE clientes SET telemarketer =1 WHERE telemarketer IN ( SELECT telemarketer FROM ( SELECT telemarketer FROM clientes WHERE telemarketer=0 ORDER BY telemarketer DESC LIMIT 0, 10 ) temporal ); Bu...
Gonzalo Acosta
6

votes
2

answer

SQL Server Update Trigger

I have never used triggers before in SQL server and I have looked around online but haven't found an answer to my question. Basically I am trying to write an Trigger that will run after a record has been updated in a table. This trigger will then update two additional tables based on the record th...
Taryn
3

votes
3

answer

Eclipse without update sites?

I just downloaded the 'Java' and the 'Classic' version of Eclipse 3.7 Indigo and in both cases there are no default update sites like the one from Indigo itself. What could have gone wrong here?
erikbwork
2

votes
0

answer

Update User Photo

I am trying to update the user photo for a G Suite user using the following code: require 'google/apis/admin_directory_v1' require 'googleauth' require 'googleauth/stores/file_token_store' require 'fileutils' OOB_URI = 'urn:ietf:wg:oauth:2.0:oob' CLIENT_SECRETS_PATH = 'client_secrets.json' CREDENTIA...
Morfinismo
2

votes
5

answer

update statement in Java

I have the following code to update a record. The code compiles however it skips everything in the try statement and displays the error message in the catch statement. I am not sure what it is that I am missing as it doesn't display any sort of syntax error. try { PreparedStatement st = d...
FatmaTurk
47

votes
7

answer

Bulk Update in C#

For inserting a huge amount of data in a database, I used to collect all the inserting information into a list and convert this list into a DataTable. I then insert that list to a database via SqlBulkCopy. Where I send my generated list LiMyList which contain information of all bulk data which I wan...
1

votes
2

answer

JTable auto-update help

Greetings, I have been understanding how DefaultTableModel will work on my problem. I had this JTable which already has the data from a query from my data using JDBC - MySQL. I the role is that the index0 of the JTable always displays the primary key. And there will always be an empty row at the end...
Cyril Horad
2

votes
5

answer

Novice SQL Update Question

Revised Query.. the [Id] column is unique to all records.. the query should return the correct value for CorEURUSD to both Symbol = EURUSD and Symbol = GBPUSD where the [Time] = [Time] values. CREATE TABLE [dbo].[Tck2]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [Symbol] [varchar](35) NULL, [Time] [date...
CraigJSte
2

votes
0

answer

Update matrixInput in Shiny

I would like to update the matrix input based on user-input values for the first row when the button 'fill matrix' is pushed. The matrix is updated correctly (as printed), but the input fields do not change accordingly. Any advice would be greatly appreciated! ui.R library(shiny) library(shinyIncuba...
Machteld Varewyck
2

votes
3

answer

Laravel account details update

I am still getting to grips with the Laravel framework but something that should be simple is turning out to be a troublesome issue for me. I have created a view inside account/update.blade.php Change password Update I have within AccountController.php public function postUpdate(){ $user =...
coder123
2

votes
1

answer

update row in DB

I'm trying to learn how to do CRUD operations, but I can't seem to figure out how to update an existing row in my DB. I've gotten the create and delete part working, but I don't really know how to solve the update part. I've googled a lot about it, but I can't find a explanation that I fully underst...
user2261654
5

votes
4

answer

FileLoadException after NuGet Update

After doing an update of all NuGet packages, one of my applications began crashing on start-up with a FileLoadException: Could not load file or assembly 'Microsoft.Practices.ServiceLocation, Version=1.2.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. This was after...
Charlie
1

votes
4

answer

multiple update query mysql

I have a table in which primary key is combination of two columns. I want to update multiple rows depending upon my Primary keys StationId ServerDate Status 1 2011-05-05 01:00:00 0 1 2011-05-06 01:00:00 1 2 2011-05-05 01:00:00 2 My update queries currently lo...
Gunjan Nigam
4

votes
2

answer

Update all wordpress posts

I need make all of my posts update. I use bulk upload for store, but in web page posts/products dont show, when i hit update, posts/products are showed up. I think use wordpress default update function: // Update post 37 $my_post = array(); $my_post['ID'] = 37; $my_post['post_content'] = 'This is t...
Foxsk8
1

votes
3

answer

Update Statement with subquery

MS Access Update Statement with subquery I have Order table and OrderDetails table. OrderDetails table has orderline items with quantity and subtotal. I would like to run a query to update 'Total Amount Before Discount' in Order table with the sum value of correspondent orderline subtotals. The quer...
Peter
16

votes
2

answer

Composer Update Laravel

A developer has sent me his project to work with, but when ever I try to update or install my vendors everything works great until the very end and it outputs the message bellow. C:\xampp\htdocs\BigWaveMedia\davinkit>php artisan migrate {'error':{'type':'Exception','message':'expected color value: f...
Brent
2

votes
1

answer

WordPress - update language files

I installed WordPress 3.8 in english language. I'm thinking about change default language (manual upload translation files). But there's something I don't know: does WordPress itself will be able to upgrade this files in the future?
Mateusz Jagiełło
2

votes
1

answer

JavaFX Canvas Update

I've been working on switching my applications from Swing to JavaFX. I've been working on a room escape game which displays a description of the item on which the user clicks. In Swing, I'd subclass JComponent and override the paintComponent(Graphics) method. I could draw the text there, knowing tha...
nrubin29
4

votes
2

answer

Linq2SQL using Update StoredProcedure

We use queries generated by Linq for data retrieval but for INSERT and UPDATE we do not allow generated SQL, but restrict to the use of stored procedures. I connected the Update and the Insert behaviour in the DBML to the stored procedures. The procedures are called, the data gets inserted/updated...
PeterFromCologne
6

votes
4

answer

Automatically update jar files

I am currently working on desktop software based on java.It's quite a big code base (more than 40 jar files). I wish to provide an automatic update functionality. The desktop software constantly checks one back end system to see if there are new versions of the jar files available. The problem now...
user381878
8

votes
2

answer

HBase update operation

I am new to HBase, I find in HBase client API, update operation is not supported? Is that correct? If so, what is the suggested best practices to update the values for a specific rowkey?
Lin Ma
4

votes
2

answer

update instead of delete

with cakephp, is it possible to have update sql action instead of delete (i would like to set some kind of flag, so it 'looks' like it is deleted)? tnx in adv!!!
user198003
1

votes
3

answer

UPDATE IF EXISTS error

Im try to update value (level) in in table people if userid exist in users table in table IF EXISTS (SELECT userid FROM users) UPDATE people SET level='1' What i am missing ! to get errors ?
Jecki
7

votes
3

answer

Conditional update in SQLite

Can I create in SQLite a statement like this? update books set (if number_of_pages > 0 then number_of_pages = number_of_pages - 1) where book_id = 10 Is there a working syntax for this?
xralf
3

votes
2

answer

Update timeZone f:convertDateTime

When I change timeZone of f:convertDateTime this doesn´t change. ` ` zone is a element java.util.TimeZone. I use primefaces 3.5
Mathew Rock
6

votes
3

answer

Synchronise/update sqlite databases

We've got an android app and an iPhone app (same functionality) that use sqlite for local data storage. The apps initially come with no data, then on the first run they receive data from a remote server and store it in a sqlite database. The sqlite database is created by the server and the apps do...
Aleks G
3

votes
1

answer

GridView update/delete crashes

I have a gridview of my table. I established a AccsessDataSource to my database. The Accsess datasource is configured so the sql scentance is: SELECT * FROM [Users] In the advanced settings I checked 'Generate INSERT, UPDATE, and delete statements' I enabled editing and deleting. My source code show...
GolanTheAce
2

votes
2

answer

Is this update lost?

I just want understand the meaning of 'update lost' which is solved by transaction. Please take a look at following two transaction, I use mysql 5.5.8 and innodb storage engine: create table counter (what varchar(5), id integer, count integer, primary key (id)); insert into counter values ('total',...
Chang
2

votes
2

answer

Arch Linux update error

Today I update the ArchLinux use pacman -Syu, but it reported some error. I didn't pay attention. Then I rebooted the machine and now it reports a kernel panic. I found the news But it didn't tell that the kernel could panic. I cannot even login to the system.
jasonz
2

votes
3

answer

Return Collection after update()?

Using Raw, how to return collection of updated row? For example: $updated = DB::table('users')->where('id', 1)->update(['votes' => 123]); I was expecting dd($updated) to return updated row of collection but it returned 1. {{$updated->votes}} should return 123
I'll-Be-Back
2

votes
1

answer

update image in web2py

I have a more special question. It is really simple to display an image in an html tag. I have done it by returning the sql file in a dict to the same named html file, which embed it in the tag with the following code: My problem is now, that i am really confused. I have an image database in model...
Ingeborg
2

votes
3

answer

JProgressBar wont update

I'm trying to add a JProgressBar to my program, but it wont update! The value only changes once it reasons 100%. Here's my method. public void downloadImages(List images) { if (errorCode == 0) { for (int i = 0; i < images.size(); i++) { if (errorCode == 0) { main.progressLabel.setText('Downloading i...
Jonathan Beaudoin
1

votes
3

answer

Regular expression value update

I had written the below regular expression string validnumber = @'^[a-zA-Z]{2}[0-9]{7}(?:-[0-9]{5})?$'; This will allow the numbers like 'AA1234567' and 'AA1234567-12345'. I want to allow below all formats AA1234567? AA1234567?? AA1234567??? AA1234567???? AA1234567-? AA1234567-?? AA1234567-??? AA12...
Triandh Velchuri
2

votes
1

answer

SolrCloud insert/update documents

presently i am working on a search application using solrcloud. I have tested many features of solrcloud which i was looking for.I want to know that if i insert/update/delete in to cloud using solrj client (Any flavor Http,embedded,cloud ...) or using lucene API directly to write to index directory...