sqlite,table,join,updates,multiple-tables
You need to find id of row you want to update without using table on which update will be run. You could find those id's from only two tables 'table2' and 'table3'. Simple subquery will help you: UPDATE table1 SET name = 0 WHERE id_t2 IN ( SELECT t2.id FROM...
database,ms-access,ms-access-2010,updates
This query displays the results you want in Access 2010. SELECT m.[Document#], m.[Revison#], IIf( m.[Revison#]=DMax( "[Revison#]", "MyTable", "[Document#]='" & m.[Document#] & "'" ), "Yes", "No" ) AS [Latest?] FROM MyTable AS m; My [Document#] and [Revison#] fields are both numeric fields. I presumed you want text as the type of...
ruby,ruby-on-rails-3,updates,put,undefined-function
You need to add an as: to your route, this is what specifies the prefix for the helper method and is why you're currently getting an undefined method error e.g. put 'affinities/refreshProfile/:id' => 'affinities#refreshProfile', as: 'refreshProfile_affinity' refreshProfile_affinity_path would then work, or you could give it a shorter, snappier name e.g....
The answer to your main question is NO. That message appears because the setup-x86_64.exe file has been updated. You need to download a recent version at http://www.cygwin.com/setup-x86_64.exe. Mirror sites are updated on a schedule, so the updates at mirrors are always behind the main Cygwin site by a certain amount....
jboss,weblogic,updates,java-web-start
I'm not sure why it would be different between Weblogic and JBoss but you should do the following in your JNLP file: Specify a version for every jar like: <jar href="my.jar" main="true" version="1.0"/> Specify JNLP version enabled <property name="jnlp.versionEnabled" value="true"/> This should ensure that the versions are checked and only...
android,mobile,updates,reset,android-4.4-kitkat
Factory reset only deletes the user data - not the OS. You cannot revert to an older OS version by Factory Reset. Second question: it generally depends on the changes. But typically you directly go to the latest version....
Solved by installing all optional updated through windows update
For the update, it always use the previous value (the value before the Theano function call). So you found the right thing. For momentum, I think it is normal that there is a delay....
You need to put the NSBezier stroke in the drawRect, not in the mouseDragged. Save the coordinates in mouseDragged in an instance array and then do the final drawing with Bezier in drawRect. drawRect is called by the OS when the view needs display (either being told by needsDisplay =...
They only download assets. You are not allowed to download code to run on your device, therefore they leave the update content assets on the server so that you can download those images to your device through https requests. These images are then saved in a documents or some other...
use "array binding" with a simply update statement. http://www.oracle.com/technetwork/issue-archive/2009/09-sep/o59odpnet-085168.html...
php,symfony2,doctrine2,routes,updates
updateParcs_form: path: /manageparcs/update/form/{name} defaults: { _controller: MySpaceManageBundle:Manage:update } requirements: methods: GET # route for processing form with update updateParcs_process: path: /manageparcs/update/form/success defaults: { _controller: MySpaceManageBundle:Manage:update } requirements: methods: POST Your second route doesn't specify a name parameter as the first one does. The cause is that the method is expecting...
linux,command-line,installation,command-line-arguments,updates
You can download the hardware specific package of ubuntu 12.04 directly http://releases.ubuntu.com/12.04/ or http://howtoubuntu.org/how-to-install-ubuntu-12-04-precise-pangolin There is no such option in the standard installation medium....
collections,meteor,user,updates
I've checked your code and I found multiple issues which need your attention. Please get the fixed project from here and follow the instructions to get and run it. The main issues were: In your collection's schema definition you first specified the UserSchema and referenced the UserProfile schema. Since the...
try like this: public static ABCDE form; public static BCI1 form1; [STAThread] static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); form = new ABCDE(); form1 = new BCI1(); form.Show(); form1.Show(); Application.Idle += new EventHandler(Application_Idle); Application.Run(); } static void Application_Idle(object sender, EventArgs e) { Message message; while (!PeekMessage(out message, IntPtr.Zero, 0, 0, 0))...
ios,notifications,updates,watchkit
To notify Watch App from the iOS application for data changes, you can do so manually by using the Darwin notification center. More reference here: https://devforums.apple.com/message/1082630#1082630 Darwin notification center: https://developer.apple.com/library/mac/documentation/Darwin/Conceptual/MacOSXNotifcationOv/DarwinNotificationConcepts/DarwinNotificationConcepts.html...
ruby-on-rails,ruby,time,updates
You can write after_filter to set the lastPopulation, Like after_filter :set_last_polulated, :only => ['populateTable'] def set_last_polulated @lastPolulation = DateTime.now end ...
vb.net,timer,updates,streamreader
You can use a timer to refresh the text in the label. In the form designer, drag a Timer from the toolbox onto your main form (Form1). Add a FilePath property to your preferences form (Preferences1) and use it to store the path selected in the OpenFileDialog. When you show...
You can consider using the PATCH HTTP verb and a Delta<T> object. [AcceptVerbs("Patch"), ResponseType(typeof(void))] public IHttpActionResult PatchUser(string id, Delta<Team> changes) { User userToUpdate = db.Users.Where(u => u.id == id).FirstOrDefault(); if (userToUpdate == null) return NotFound(); changes.Patch(userToUpdate); try { db.SaveChanges() } catch (DbUpdateException) { ... } return StatusCode(HttpStatusCode.NoContent); } See also...
wordpress,wordpress-plugin,updates,wordpress-mu
We find out it was a problem with the config. We needed to keep define('AUTOMATIC_UPDATER_DISABLED', true); and we commented define( 'DISALLOW_FILE_MODS', true );. But DISALLOW_FILE_MODS need to be set as false, not just commented otherwise default value is true i guess....
ios,xcode,swift,nsarray,updates
data3 seem to be of type [[String:Int]] based on your responses on my comments. So by changing NSArray to [[String:Int]] or just simply removing NSArray completely and letting Swift determine the type by itself. I guess your question is in pseudo-code so my guess is how you set that data3's...
mongodb,updates,mongodb-query,aggregation-framework
You'll never get this in a single query operation as presently there is no way for MongoDB updates to refer to the existing values of fields. The exception of course is operators such as $inc, but this has a bit more going on than can be really handled by this....
Oftentimes, the following helps: Re-install Alcatraz, restart Xcode, de-install and re-install your plugin. Sometimes it helps to restart Xcode again. This worked for me. If your plugin still does not show up, the problem is probably that the the compatibility key of your new Xcode is not yet included in...
c#,deployment,updates,excel-dna,xll
The .xll file will always be locked by Excel, so you can't update that file while the add-in is loaded. You might be able to structure your add-in so that the .xll does not change with the updates, but the .dll file(s) that you use do change. There are two...
java,variables,for-loop,updates
try this code private static boolean basicSweep(String input) { int noOfClosingParentheses = 0; int noOfOpeningParentheses = 0; int highScore = 0; for (int i = 0; i < input.length(); i++) { Character currentCharacter = input.charAt(i); if (currentCharacter == '(') { noOfOpeningParentheses++; } else if (currentCharacter == ')') { noOfClosingParentheses++; if(noOfOpeningParentheses...
python,user-interface,tkinter,updates,trace
I don't think you need to use update() method here. You already have an infinite loop running, the main(event) loop. You can just use it. Since you want to draw whole thing on every scale change, you need to put drawing stuff in your callback but be sure not to...
kernel,debian,packages,updates,exclude
You can prevent a package from being automatically installed, upgraded or removed by running the following command: sudo apt-mark hold package_name To cancel the hold, just run: sudo apt-mark unhold package_name I'm not sure, however, it's a good idea to do this with some packages. In your case, holding the...
You need to flush magento cache and storage cache. If you are using apc or varnish cache you must be refresh. If not worked then you need to change your css file with new name and give new css file name in your xml file.
The $pull operator acts as a query document in itself and is also considered against every element of the array so $elemMatch is not needed: var update = { "$pull": { "pictures": { "_id": new ObjectId(req.params.picid) } } }; You also need to cast your "string" from request params to...
windows-services,windows-installer,updates,msiexec
In the right circumstances (signed MSI and MSP patch files) you don't even need to be admin to install a patch update, a non-admin can do it: https://msdn.microsoft.com/en-us/library/aa372388(v=vs.85).aspx...
sql-server,stored-procedures,sql-server-2012,updates,coalesce
You are updating the variables not the columns in CreditCard table. ..... SET @CardType = COALESCE(@CardType,CardType), -- here you are updating the @CardType variable ..... Try this. CREATE PROCEDURE UpdateCreditCard @CreditCardID INT, @CardType nvarchar(50) = NULL, @CardNumber nvarchar(25) = NULL, @ExpMonth tinyint = NULL, @ExpYear smallint = NULL AS BEGIN...
ruby-on-rails,ruby-on-rails-3,devise,routes,updates
I think this should do it: <%= simple_form_for(resource, as: resource_name, url: registration_path(resource_name), html: { method: :put }) do |f| %> ...
redirect,ruby-on-rails-4,updates
redirect_to **user_path**, notice: "Successfully updated!" You are redirecting to the user_path. You want to redirect to the post_path. Unless what you want is directing to the user_path. Then, you need to pass it the user id: user_path(current_user.id)...
postgresql,table,sql-update,updates
This query should produce the same results, but avoids the CASE -- EXPLAIN ANALYZE UPDATE table_a a SET rebuilding_costs = drie.rebuilding_costs FROM ( SELECT COALESCE(b.address, c.address, d.address) AS address , COALESCE(b.rebuilding_costs, c.rebuilding_costs, d.rebuilding_costs) AS rebuilding_costs FROM table_b b FULL OUTER JOIN table_c c ON c.address = b.address AND c.rebuilding_costs BETWEEN...
php,mysql,sql,sql-update,updates
You just need to execute the update statement you have: $sql = "UPDATE logs SET FinalAnodThickness = $FinalAnodThickness WHERE EXISTS (SELECT id FROM logs)"; if ($conn->query($sql) === TRUE) { echo "Records updated successfully"; } else { echo "Error updating records: " . $conn->error; } ...
dynamics-crm-2011,updates,options
SOLVED: It must be set to -1; not to null...
opengl,graphics,driver,updates
Your graphics card must support the OpenGL 4 version to develop with it. It is mandatory that the hardware (graphic card) is compatible with the OpenGl version you want to develop and the driver installed in your system allows the graphic card to use that version. Supported cards for openGL...
c#,asp.net,sql-server,database,updates
There is a function of SQL Server, called Query Notifications, that can be used by an app to know when some data changes. In .NET it's used through the SqlDependency class and/or the SqlNotificationRequest class.
java,hibernate,many-to-many,updates
Finally done. Changes that affect behavior: <bag name="relatedAttributes" table="category_attribute" fetch="select" inverse="false" cascade="save-update"> ... </bag> and do not forget to call session.flush() after operations....
scripting,server,powershell-v2.0,updates
You can run the code on a remote host via Invoke-Command: Invoke-Command -Computer 'someserver' -ScriptBlock { $Criteria = "IsInstalled=0 and Type='Software'" $Searcher = New-Object -ComObject Microsoft.Update.Searcher $SearchResults = $Searcher.Search($Criteria).Updates $SearchResults.Count } Change the last line to $env:COMPUTERNAME, $SearchResults.Count if you want hostname and number of updates returned instead of just...
ios,objective-c,uilabel,nsdate,updates
Check this - (void)viewDidLoad { [super viewDidLoad]; NSDateComponents* deltaComps = [[NSDateComponents alloc] init] ; NSDate* tomorrow = [[NSCalendar currentCalendar] dateByAddingComponents:deltaComps toDate:[NSDate date] options:0]; NSDateFormatter *myDateFormatter = [[NSDateFormatter alloc] init]; [myDateFormatter setDateFormat:@"dd-MM-yyyy"]; NSString *stringFromDate = [myDateFormatter stringFromDate:tomorrow]; dateLabel.text = stringFromDate; // Do any additional setup after loading the view. } -...
cassandra,nosql,conditional,updates,cql3
What version of cassandra are you running? Support for non-equal conditions with LWTs was added in 2.1.1 via CASSANDRA-6839: cqlsh:test> UPDATE events SET first_occurrence = 123456 WHERE event_name='some_event' IF first_occurrence > 1; [applied] ----------- True ...
When you distribute an app with a database, that database is stored in the bundle. If the user needs to update the database, the app cannot programmatically update the file in the bundle, so you generally copy the database from the bundle to the Documents folder (if you haven't already...
android,mobile,updates,remote-access,server
What we do is sync periodically to a remote server during data entry on the app. During this sync, we check to see whether the device has the latest version of the software. If it doesn't, the new apk is downloaded and the user is prompted to install the software....
mysql,loops,stored-procedures,insert,updates
I suggest you run an UPDATE statement that replaces the old value with the new value. The easiest approach would be to run a separate statement for each column you want to update. For example: UPDATE mytable t JOIN old_new s ON t.string_column = s.old_value SET t.string_column = s.new_value UPDATE...
You will need to store them somewhere extra. Or you can create your custom map implementation which would either extend Java's hashmap or use an hashmap internally and would additionally remember the last date of any action performed on your dataset, you seek to remember. This would have the advantage...
When you create your application, in your manifest file you give it a version number. For example version 1. If you create a second version of your app, you change that number (increment usually) and then re-publish your app on the Play Store. Then the users that already have your...
The key is to make sure your web server is the owner of the directory WordPress is installed in (and its sub-directories). You're seeing an error because your web server doesn't have the proper privileges to write to your directories. I recommend running a chown -R user:group /path/to/wordpress, substituting the...
arrays,swift,dictionary,nested,updates
If you do really need a dictionary of arrays of dictionaries as presented, then Antonio's answer is correct, append will do the job: var TabActions: Dictionary<String, Array<Dictionary<String, String>>> = [:] TabActions = ["EVENT1" : [["TARGET1" : "ACTION1"], ["TARGET2" : "ACTION2"]]] TabActions["EVENT1"]?.append(["TARGET3" : "ACTION3"]) On the other hand if you can...
I would do something like this: (for ordinairy lists) // the current list var currentList = new List<Employee>(); currentList.Add(new Employee { Id = 154, Name = "George", Salary = 10000 }); currentList.Add(new Employee { Id = 233, Name = "Alice", Salary = 10000 }); // new list var newList =...
It's not just an issue with Go, but in general we can divide the problem into two separate ones: Making sure current requests do not get terminated and affect user experience. Making sure there is no down-time in which new requests cannot be handled. The first one is easier to...
homebrew,updates,homebrew-cask
No. There is no brew cask upgrade.
asp.net,vb.net,ms-access,updates
This seems to be a well know effect of forgetting to test for postbacks in the Page_Load code. Every time your user triggers an event to be handled on the server (runat="server" and/or AutoPostBack="true" ) then the Page.Load event of your page is called BEFORE calling the event handler activated...
You have added the item to your database, but not to the list used to create the adapter. ITEM_DATA.add(item): itemAdapter.notifyDataSetChanged(); ...
wordpress,workflow,updates,core,bulk
I am using InfiniteWP to manage updates remotely. You set "the server" up on your own webhost and install plugins in the sites you want to manage. From then on you can log in on your webhost, add sites which have the plugin installed and can then choose which updates...
perl,module,updates,cpan,cpanm
Your are instructing the module installers to install modules in /home/hacklionex/perl5 (via PERL_MM_OPT and PERL_MB_OPT), but you don't tell Perl to look for modules there (it's not in @INC). Add the following to your login script: export PERL5LIB=/home/hacklionex/perl5/lib/perl5 Or add the following to your script: use lib '/home/hacklionex/perl5/lib/perl5'; ...
amazon-web-services,docker,updates,amazon-cloudformation,offlineapps
I just answered a similar question about baking resources into an AMI vs. using a configuration management tool like Chef, Puppet, etc. Short answer is to try and not bake software into the AMI but rather build on top of base images with repeatable "recipes" (Chef term). As for the...
listview,titanium,refresh,updates
You have to first get the item that you have to update the update only this item ... myListView.addEventListener('itemclick', function(e) { //get the item to be updated var user= e.section.getItemAt(e.itemIndex); //edit this user here user.name.text="Coyote"; //then update the listview with the new data : e.section.updateItemAt(e.itemIndex, user); }); ...
sql-server,sql-server-2008,table,triggers,updates
You just needed to add an IF UPDATE check and join deleted table in your trigger: CREATE TRIGGER [dbo].[TransactionDateUpdate] ON [dbo].[Tasks] AFTER UPDATE AS BEGIN IF UPDATE(acceptanceState) --add this line UPDATE dbo.Tasks SET TransactionDateTime = GETDATE() FROM INSERTED i JOIN DELETED d on i.TasksID = d.TasksID --add this line WHERE...
triggers,salesforce,field,updates
In General, the triggers are fired whenever there is a change to any/all fields in the object. What you can do is compare the value in trigger.old with the value in trigger.new eg: trigger TestTrigger on Account (before update) { for(Account a : Trigger.new){ if(a.Active__c != Trigger.oldMap.get(a.id).Active__c) System.debug('change in Active...
mongodb,date,mongodb-query,updates
You need to use new Date() instead db.drinks.update( {}, { $set: { 'date': new Date() }}, false, true ) ...
Android Studio 0.8.12 introduced some changes to the patching mechanism. Because of this, it is not possible to patch from pre-0.8.12 to post-0.8.12 at all. You need to download and install a full copy. Your settings should be preserved by default, however.
android,updates,android-preferences,migrate
You could add a simple method in the first activity which'll open, to update the preferences values for you. Also, add a check so that it executes only for the first time.
Does HomepageActivity extends ActionBarActivity (and not Activity)? EDIT: Check if HomepageActivity starts with: public class HomepageActivity extends ActionBarActivity { .... } If not (and it extends Activity), fix it and you should solve the problem....
You need to create 1 form to each tr. The way you are doing its generating many dvlbid values to the same form and theres no way to the browser know what you submit. I rewrite your code, creating one form for each tr, which I believe will work (although...
content-management-system,updates,expressionengine
EE doesn't make it quite as easy as it is in WordPress. You could check out the Lamplighter extension to see what's still in need of an update then download from the respective source. This is getting into opinion a bit but when I did a lot of EE dev,...
to update it to Version 6.1.1 In your Web browser, sign into the Apple developr site and then click this link: https://developer.apple.com/downloads/index.action?name=Xcode Xcode 6.1.1 is the first link, at the top of that page. Click it!...
function,swift,slider,calculator,updates
I'm a doofus. I just had to change miles to 500, instead of zero. Now it works. Sorry, guys.
It's quite simple: whenever a fact is modified, all rules referencing that fact are evaluated again, and if the condition is true, they result in another activation. To break this vicious circle, you have several options, but using no-loop on both rules isn't one of them. First, you can add...
javascript,d3.js,charts,updates
Your reDraw function appends the svg, this means every time you call redraw a new svg is appended, hence the double chart. I would suggest to put the lines var stepbars = d3.select("#steps-bar") .append("svg:svg") .attr("width", width) .attr("height", height) above the reDraw function. Furthermore, your redraw function does not call remove....
django,python-2.7,deployment,openshift,updates
The easiest way to achieve this is to change the setup dependencies (install_requires parameter for setup ()) in setup.py. Instead of packages = ['Django<=1.6',] as in the cartridge default you could write packages = ['Django>=1.7,<1.8',] to get the latest version of Django 1.7. More details of how to specify values...
ruby-on-rails,ruby-on-rails-4,routes,updates
You can simply use <%= form_for @supply do |f| %> for edit.html.erb file. Reason is: When you instantiate @supply in edit method in SuppliesController, Rails will automatically post the form to update method, you do not need to tell it explicitly. Same way, in new.html.erb, you will also use the...
Try this, update transaction set rate = rate * 0.95 where <Datetime condition> ...
c++,protocols,protocol-buffers,updates
Protocol buffers are actually designed such that concatenation is the same as merge, and that the last field wins when merging (except for repeated, which are added). In your case, you should actually be able to serialize a blob containing just the phone-number set, and append this data, and it...
dependencies,monitoring,updates,dependency-management,software-release
libraries.io is a great project. It supports a couple of commonly used platforms, although their search algorithm could be improved. I have not found any better option than this till now.
zend-framework2,composer-php,updates,apigility
Why do you think the latest version of Apigility is 1.1.1? https://packagist.org/packages/zfcampus/zf-apigility shows 1.0.3 (which you already have) as the latest version, as does the Github repository. It's the skeleton application, that's at version 1.1.1....
ios,swift,uiviewcontroller,updates
viewDidLoad() method its automatically called during view controller lifecycle and you should not call it manually. To update your label from other view controller you should use notification center. If you are unfamiliar with it a good starting point might be this tutorial
Instead of neat install, try neat update.
sql,postgresql,triggers,updates,ddl
Since a in your scenario should always be 18 months after z there's no point in actually storing it anywhere. It would be much easier to just have it as a calculated column in a view: CREATE VIEW y_view AS SELECT z, z + INTERVAL '18 MONTH' AS a FROM...
First off, it's important to understand that Todo.update is an async function which delivers its results to a callback function rather than returning it. But the Mongoose update function also takes its parameters in a different way than the shell. So your code should look something like this instead: Todo.update({},...
You are opening a text file, and writing the contents of a struct *, that may not work the way you intended. I do not know what your file format is, you have not specified it. Assume a comma separated variable formatted file with one record per line. It could...
This was the better suited solution. user.local.email = '[email protected]'; users.update({ "$or": [{ 'local.email': '[email protected]' }, { 'google.email': '[email protected]' }, { 'facebook.email': '[email protected]' }] }, user); ...
You can check if the apk file exists like this: String sdcard = Environment.getExternalStorageDirectory().getAbsolutePath(); String path = sdcard.concat("/updates/update.apk"); if (new File(path).exists()) { Intent promptInstall = new Intent(Intent.ACTION_VIEW) .setDataAndType( Uri.parse("file:///sdcard/updates/update.apk"), "application/vnd.android.package-archive" ); startActivity(promptInstall); } ...
android,android-linearlayout,updates,programmatically-created
No, there is no substitute for notifyDataSetChanged(), you have to manually inform your ImageViews of that change. You could iterate like this, as soon as you have a change: for(int i= 0; i < ll_ethnicity.getChildCount(); i++){ ImageView iv = (ImageView) ((ViewGroup)ll_ethnicity.getChildAt(i)).getChildAt(0); // new background because something has changed // check...
You should be using an UPDATE query UPDATE Table_A a JOIN Table_B b ON a.id = b.id SET a.jeans = b.jeans; ...
mysql,arrays,comparison,updates
To do that in a single query would be very cubersome. Here is a solution that is not exactly what you are looking for but should do the job. Let's say your table looks like this : CREATE TABLE htmlComponent ( id int auto_increment primary key, action int, button_id int...
This sequence is satisfactory you don't need to change.
android,google-play,updates,uninstall
For an application, once you upload it to the Google Play Store, it is uniquely identified by the package name you gave it. I've found an article that details what can't change once an app is uploaded. From that post: Once you publish your application under its manifest package name,...
c++,visual-studio-2012,updates
It seems that you are trying to compile a Visual Studio 2013 Project (as it uses ToolsVersion=12.0) on Visual Studio 2012 (uses ToolsVersion=11.0). So here is the solution to Your problem. #TestedSuccessfully In your Project Folder open the .Vcxproj file and change ToolsVersion=12.0 with 11.0 You have to change 12.0...
You can do like this let highscore: Int = 1 NSUserDefaults.standardUserDefaults().setObject(highscore, forKey:"highscore") NSUserDefaults.standardUserDefaults().synchronize() ...
Assigning to a local variable like that (result in your case) doesn't work with the way RethinkDB's driver builds up the query object to send to the server. When you write code like above, you're storing a literal string in the local variable once on the client (rather than once...
You can use a dict to index the new data. Then write the original file to a new file, line by line, updating data from the index as you go. It looks like the first three items should be the key ("PROD 850 30003") and they can be pulled out...
The results are displayed ordered by primary key. Since you changed the primary key nom field the ordering changed as well.