FAQ Database Discussion Community
sql-server,sql-server-2008,table,triggers,updates
I have the following table with this structure: CREATE TABLE [dbo].[Tasks] ( [TasksID] [int] IDENTITY(1,1) NOT NULL, [CommitteeID] [int] NULL, [TransactionDateTime] [datetime2](7) NULL, [inspectionStatus] [nvarchar](50) NULL, [Latitude] [nvarchar](50) NULL, [Longitude] [nvarchar](50) NULL, [acceptanceState] [nvarchar](50) NULL, [comments] [nvarchar](350) NULL, [ScheduledDateTime] [datetime2](7) NULL, ) What I want exactly is to create a...
ruby,ruby-on-rails-3,updates,put,undefined-function
I'm getting the error in the title. I am not sure how exactly to write the routes, controller, and index. I am trying to create a 'Refresh' button in an index.html.erb view shown below: ... <td><%= link_to 'Refresh', refreshProfile_affinity_path(a), method: :put %></td> ... It is using this route in routes.rb:...
c,file,updates
Can somebody help me with this code. When I try this code it doesn't work at all. I've very less experience in working with files in C Language. Please help me to solve this Here is the structure struct passenger { char airline[20]; char name[20]; int age; char gender; char...
cassandra,nosql,conditional,updates,cql3
I have a list of unordered events and my task is to store first and last occurrences for them. I have following column family in Cassandra: CREATE TABLE events ( event_name TEXT, first_occurrence BIGINT, last_occurrence BIGINT, PRIMARY KEY (event_name) ); So if I have an event with the name "some_event"...
java,sql,updates
I'm working on database containing 2 columns (NOM (String) ,TMP(integer)). But when I tried to update it , the first row became the last. Can I update it and maintain the same order? Statement state = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet result = state.executeQuery("SELECT * FROM cities"); result.absolute(1); result.updateString("NOM", "xxx"); result.updateRow(); Here's...
ios,swift,uiviewcontroller,updates
Hi I use a Menu of "code4app.net" for my app and I have a problem. Source is here : click here I update a global var in one controller: func sendGlobalData(){ globalCurrentUser = currentUser } and I use it in another: override func viewDidLoad() { super.viewDidLoad() setBackButton() self.setNavigationBarItem() userProfilePicture.profileID =...
linux,command-line,installation,command-line-arguments,updates
I am attempting to update my Ubuntu Natty Narwhal (11.04) to Precise Pangolin (12.04). When I checked the Update Manager, I was told I couldn't do that. I had to get to 11.10 first, if I want it safely. Sounds like a plan. And so I've ran through the Update...
wordpress,workflow,updates,core,bulk
I am many wordpress sites developed locally. Once the site is finished, I upload to remote. Now the problem is that there are too many sites and its plugins that needs to be updated. It has been time consuming and error prone to update those sites and plugins one by...
sqlite,table,join,updates,multiple-tables
I have 3 tables on SQLite and like to update table1 based on the values from table3. On MySQL: UPDATE table1 t1 JOIN table2 t2 ON t2.id = t1.id_t2 JOIN table3 t3 ON t2.id_t3 = t3.id SET t1.name = 0 WHERE t3.name = 0; I know, that SQLite no support...
database,listview,updates
I can't update listview with custom adapter and database handler. Items are updated in the database handler, but listview is updated only when I leave the fragment and come back. I would like to see changes just after adding new item. @Override public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState)...
swift,save,app-store,updates
I created an iPhone game in Swift and I want to submit it to the app store. My question: when I create an update for the app how can I make that after the update the "highscore" integer has the same value as before? Do I need to save the...
java,variables,for-loop,updates
How do I find the value of a 'high score' of brackets? 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++;...
html,jmeter,response,updates,hidden
Where is hidden HTML response renderer option? This happened to me after update jMeter to 2.13 r1665067. ...
mysql,select,updates
I am going update table Transaction CREATE TABLE `transaction` ( `id` int(11) NOT NULL auto_increment, `amount` decimal(15,2) NOT NULL default '0.00', `rate` decimal(9,7) NOT NULL default '0.0000000', `amount1` decimal(15,2) NOT NULL default '0.00', `date_time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;...
mysql,updates
I have two tables, TableA and TableB. Common column is the ID. Table_A Table_B ID | Tshirt | Jeans | ID | Jeans | ------------------------- ---------------- 1 | small | (empty) | 1 | medium | 2 | medium | (empty) | 2 | small | 3 | large |...
function,updates,theano
Theano function's parameter updates take a list of pair, in which each pair specifys a shared symbolic variable and its new expression after the calculating the function outputs. I wonder whether there is any order for the updating procedure. The order will matters if two symbolic variable's new expression relies...
sql,postgresql,triggers,updates,ddl
This is a follow up question on : old example. CREATE TABLE "x"."y"( "z" timestamp NOT NULL, "a" Timestamp NOT NULL DEFAULT z + 18 months, ); I wish to specify a trigger where a is updated as soon as z is updated. Something on the lines of CREATE TRIGGER...
xcode,updates,clang-format
Today I updated to Xcode 6.3.2 and I can't run the Clang code formatting – it seems like it's not even installed. Everytime I update Xcode, I have to reinstall Alcatraz and most of the packages (why btw?) to make them work on the new version of Xcode. This time...
python,user-interface,tkinter,updates,trace
I'm having a bit of trouble figuring out why the following code doesn't update even though I'm using a tkinter variable, the .trace method and the .update method. from tkinter import * from math import sin, cos, pi master = Tk() people_size_var = IntVar() PeopleSize = Scale(master, from_=1, to=50, bd=3,...
kernel,debian,packages,updates,exclude
I always use 'sudo apt-get update && sudo apt-get dist-upgrade' in Raspberry Pi but I need to keep my kernel current version. I want to upgrade all packages except kernel ones. Is it possible? Can I use an option in this command? Thanks
wordpress,docker,updates
I installed a Wordpress website with the wordpress Docker image, and then installed my themes. All works well, but when I want to update Wordpress later on, I get this message: To perform the requested action, WordPress needs to access your web server. Please enter your FTP credentials to proceed....
javascript,mongodb,updates
I am doing an update in mongodb but not very familiar with how to get things done in mongodb. Todo.update({}, {$set : { tags : []}}, false, true); How do I get WriteResult? I want to know the nMatched and nModified value. I tried the following but it doesnt work....
dynamics-crm-2011,updates,options
I have on a page an option set that has been valorized with a value. I would like to update this value and set it to null. I am trying in this way Crm.Context.Account myAccount = new Crm.Context.Account(); myAccount.Id = "1af43..."; myAccount.Name = "bla bla bla"; myAccount.psw1_TipoSoc= null; OrganizationRequest request...
swift,drawing,updates,nsview
I have a custom NSView with some drawing: class ViewController: NSViewController { @IBOutlet weak var mainView: LineDrawer! var time = NSTimer() override func viewDidLoad() { super.viewDidLoad() self.view.needsDisplay = true // Do any additional setup after loading the view. } override var representedObject: AnyObject? { didSet { // Update the view,...
node.js,mongodb,updates
I am trying to $pull from an array within a mongodb document. The document has the structure: { "_id" : ObjectId("54ee62ef688b41ff072b934b"), "pictures" : [ { "url" : "...", "_id" : ObjectId("54ee6303688b41ff072b934d") }, { "url" : "...", "_id" : ObjectId("54ee6304688b41ff072b934e") }, { "url" : "", "_id" : ObjectId("54ee6304688b41ff072b934f") } ] }...
jboss,weblogic,updates,java-web-start
We are developing a software that runs on a client pc and is loaded via webstart (JNLP) from an app server. As app server our customers have the choice between weblogic and jboss ( wildfly). All the jars, the webstart client loads via webstart, are packed within a WAR file...
triggers,salesforce,field,updates
Is there way to create trigger on salesforce custom object that will be fired only if we update one custom field and not every time we update the whole object
ruby-on-rails,ruby,time,updates
I have a Rails 3 Application that needs to use the current time. Every time an admin uses a function populateTable, the lastPopulation variable needs to update to the current time. Two questions: 1) How can I initially set the lastPopulation variable to the current time right now? 2) Is...
c#,deployment,updates,excel-dna,xll
I am developing an Excel XLL Add-In using Excel-DNA and C#. The Add-In is called MyAddIn.xll. The Add-In has been saved to the users local machines, and it has been installed/added to Excel by the following procedure: Excel Options --> Add-Ins --> Manage Excel Add-Ins --> and then adding MyAddIn.xll....
ios,updates
In iOS files of bundle in .app directory are not available for writing. But some application (for example Plants vs Zombies 2), always updates by passing AppStore (screenshot below). What are the approaches do you know to implement it? How they do it? Screenshot "Plants vs Zombies 2" updating: ...
ios,notifications,updates,watchkit
I've been reading the Apple Watch Programming Guide and I made some examples of requesting data from the WatchKit extension to the containing app and getting back the result. But what if I want to communicate in the opposite direction? I mean, let's say I have my iOS app in...
perl,module,updates,cpan,cpanm
I try to install/update Perl module with cpanm. But, it failed for every modules. for example: cpanm Config::General --> Working on Config::General Fetching http://www.cpan.org/authors/id/T/TL/TLINDEN/Config-General-2.56.tar.gz ... OK Configuring Config-General-2.56 ... OK Building and testing Config-General-2.56 ... OK Successfully installed Config-General-2.56 (upgraded from 2.52) 1 distribution installed So, i expect that version...
javascript,d3.js,charts,updates
I have a relatively simple barchart. I want to .transition() between datasets with an .on("click") event. What I'm getting is a complete redraw of an additional chart appended to the DOM id, instead of removing the original chart and transitioning or replacing it. I think I'm misunderstanding how to correctly...
updates,drools
I am getting inconsistent data in the List, the data in the list added in the Rule 1. Rule 2 modifies the object which holds the list, due to the update/modify the Rules get called repeatedly. rule "Rule 1" dialect "java" no-loop true when $notification:NotificationVO(); $snrData : SensorDataVO(getOffsetChngesInterval()!=null, getOffsetChngesInterval().size()>0); $pestWeight:Integer()...
ios,xcode,swift,nsarray,updates
In my apps I was using this piece of code and it worked perfectly: var data3: NSArray = [] //1 for gg in data3{ //2 var hh:String = gg["percentage"] as String //3 perchomerec = hh.toInt()! //4 } Now I updated my xCode and OSx version and now this same piece...
c#,.net,json,api,updates
I come from a Ruby on Rails API background, but am currently working on a .NET C# WebAPI. I am familiar with C# and .NET webforms. I'm attempting to set up a PUT request that will update a record in the db. The scaffolded method overwrites all the fields, whereas...
collections,meteor,user,updates
I'm building a Meteor application and want users to be able to update/set their name. I've got the code set up, and everything seems to be working except that it mysteriously fails on the update. Here's my code: Template <template name="_editName"> {{#ionModal focusFirstInput=true customTemplate=true}} <form id="updateName"> <div class="bar bar-header bar-stable">...
php,onclick,updates
Please help.. I'm abit on trouble with this code. I'm confuse! I use the <form> <input type="submit">. The ID is identified however if i click the one to be submitted the other ID appeared. Please Help! Thank you in advance. <?php if(isset($_POST['ADD'])){ $dvlbid=$_POST['dvlbid']; $docstate=XXX; $query="UPDATE dvlog set docstate='$docstate' where dvlbid='$dvlbid'";...
function,swift,slider,calculator,updates
Sorry to do this again, but my code has yet ANOTHER problem. When I run the program in the simulator, if I move the slider from its default position and hit the submit button, it will calculate the mpg. However, if I leave the slider at its default position of...
dependencies,monitoring,updates,dependency-management,software-release
I think everybody uses some third party software (dependencies) in his projects. Often you drop in one version at a time and never update it, cause you don't know there is a new version and if there is you may have some migration work. Most of these 3rd party projects...
django,python-2.7,deployment,openshift,updates
I'm learning to deploy Django on Openshift. Right now I have a python-2.7 cartridge up and running with Django 1.6 The git repo cloned in the cartridge is, git://github.com/rancavil/django-openshift-quickstart.git (Github) How can I update the Django version of a running webapp? I've looked at this question that just explain about...
android,updates
How can I make the following code to activate only if there update.apk downloaded file. If that is not downloaded, do not try installing it. In current mode installs and activates instant erroare occurs if there update.apk. Thank you very much for the advice given and for your time. public...
ios,objective-c,uilabel,nsdate,updates
Set a date in UILabel. The click on "next" and "previous" buttons should change date inside this label. I'm trying this code but next button click and show date next day date for e.g 01/05/2015 and previous button click and set date 29/05/2015 and next button click not display 02/05/2015...
android,menu,settings,updates
@Override public boolean onCreateOptionsMenu(Menu menu) { // Inflate the menu; this adds items to the action bar if it is present. getMenuInflater().inflate(R.menu.menu_main, menu); return true; } @Override public boolean onOptionsItemSelected(MenuItem item) { // Handle action bar item clicks here. The action bar will // automatically handle clicks on the Home/Up...
amazon-web-services,docker,updates,amazon-cloudformation,offlineapps
I am wondering what would be the best approach for baking an AMI. Although it offers a lot of consistency, it is hard to achieve a level of consistency when you need to re-bake your AMI because of a small security update or new package version because more than likely...
arrays,swift,dictionary,nested,updates
I have the following code : var TabActions: Dictionary<String, Array<Dictionary<String, String>>> = [:] TabActions = ["EVENT1" : ["TARGET1" : "ACTION1"], ["TARGET2" : "ACTION2"]] I want to add ["TARGET3" : "ACTION3"] to the list but I can't figure how to do this. I've tried : TabActions["EVENT1"] = [["TARGET3" : "ACTION3"]] but...
updates,bourbon,neat
I installed Neat prior to the most recent gem update to 1.7.1. Now I'd like to update the files in my site install, but I'm not sure how to accomplish that. gem list indicates neat (1.7.1) I tried neat install in my sass directory, but I get the message Neat...
c#,.net,forms,updates,flicker
I have made a Brain-Computer-Interface in C#, there is flickering pictureboxes on each of the forms. However it is only in the main form where the flickering occurs. Any one know how to get the updateframe to work on the other forms as well? Program.cs using System; using System.Collections.Generic; using...
c#,asp.net,sql-server,database,updates
I need to be notified of specific changes that happen in my database, e.g. when a specific value becomes null or when an integer changes to a value between a certain range. I was looking into using triggers, but I'm not sure if that is what I need. Is there...
python,replace,updates,lines
I am new to python. I am trying to use a file with new data (newprops) to replace the old data on a second file. Both files are over 3MB. File with new data looks like this: PROD 850 30003 0.096043 PROD 851 30003 0.096043 PROD 853 30003 0.096043 PROD...
android,ios,updates
This question already has an answer here: Is there a way to automatically update application on Android? 7 answers I will deploy my app to Google Play/App Store, and I will have some new update function in the future, how can I make my app can automatic update when...
java,hibernate,many-to-many,updates
I have two entities - Category and Attribute. Category can have multiple related attributes, and Attribute can be related to any number of categories. Association should be available only on Category side - Attribute objects are not aware of categories they are related to. So I model this association as...
mongodb,updates
user = users.findOne({ "$or": [{ 'local.email': '[email protected]' }, { 'google.email': '[email protected]' }, { 'facebook.email': '[email protected]' }] // do stuff with user object So I have the user object. This is fine, after I'm finished with what I need from it property wise I wish to update some of the fields...
c#,linq,list,updates
I would like to know if you can suggest me an efficient way to update a list of items in c#. Here is a generic example: If CurrentList is [ {Id: 154, Name: "George", Salary: 10 000} {Id: 233, Name: "Alice", Salary: 10 000}] And NewList is [ {Id: 154,...
magento,caching,updates
we are devoloping magento site. when we update the code in magento site, it's not displaying in frontend. cache has been cleared, but still some colors are not updating. please help me to find solution. thanks in advance....
mysql,arrays,comparison,updates
I'd like to know how can I make a unique query to find which values exist and which values do not. I explain. What I have I've got a database table with a structure as follows: +----+--------+-----------+-----------+ | id | action | button_id | type | +----+--------+-----------+-----------+ | 1 |...