back soft

Vote count: 0 I want to see the number of customers who only shopped in one specific store during a specific period, so I wrote the following SQL: SELECT COUNT (DISTINCT CARD_NUMBER) FROM WHERE DATE BETWEEN ‘XXXX-XX-XX’(DATE) AND ‘XXXX-XX-XX’(DATE) AND STORE_NUMBER = 1234; What if these customers (card holders) shop in other store chains? I couldn’t use AND CARD_NUMBER NOT IN… Because we have too many stores. Any syntax that could be used here to solve this problem? asked 50 secs agoYuan Yuan Let's block ads! بخوانید...

Vote count: 0 I am trying to achieve page navigation (Next and back button) using Angular UI-route. I am changing the state from controller and it is getting changed on view as well but is not redirecting me to that page. I have achieved it using button click using $state.go('stateName') but I want use Bootstrap page for this . here is my code $stateProvider .state('settings', { url: '/settings', templateUrl: 'templates/settings.html' }) .state('settings.profile', { url: '/profile', templateUrl: 'templates/profile.html', controller: 'ProfileController' }) .state('settings.account', { url: '/account', templateUrl: 'templates/account.html', controller: 'AccountController' }) .state('settings.p...

Vote count: 0 I am working to create a a matrix of missingness for a SQL database consisting of 5 tables and nearly 10 years of data. I have established ODBC coectivity and am using the RODBC package in R as my working environment. I am trying to write a function that will output a count of rows for each year for each table, a count and percent of null values (values not present) in a given year for a given table, and a count and percent of missing (questions skipped/not answered) values for a given table. I have written the code below, trying to get it to work on one variable then tuing it into a function once it works. However, when I run this code, the count for total, missing and null va...

Vote count: 0 For a given ActiveCell in Excel how can VBA retu the Table Name that appears in the properties grouping that becomes visible when the Table Tools Design tab is activated. So for example in the immediate window: ?ActiveSheet.ListObjects(2) Table3600 but if I select a cell (potentially within a table) I can't seem to find a property that will either retu the selected cell's containing table's name. I am trying to either store the retu value or to state that the current cell is not in a table. TIA (This seems very fundamental yet I am nowhere) asked 37 secs agoStumpedObject Let's block ads! بخوانید...

Vote count: 0 The method setId, setGravity, setMargins works fine but method setBackground, setColor, setLayoutParams, setTextColor, setTextSize is not working on api 19 the app get crashed but works in api 21 how to solve this issue. asked 1 min agodaya nidhi Let's block ads! بخوانید...

Vote count: 0 I need to authenticate the user using asp.net identity then need to use the social login to get there profile detail. Owin does't allow two login at the same time. please help me out of this. thanks in advance. asked 1 min agoNitin Singh Let's block ads! بخوانید...

Vote count: 0 is it possible to do this , im trying to validate a form then, it will redirect using header() if TRUE.. but it seems not to be working? or my method is completely wrong ? if ($_SERVER["REQUEST_METHOD"] == "POST") { $email = $_POST["clientEmail"]; if ($email != $sentEmailClients) { echo 'Please enter a valid email'; } else{ $newURL = "http://www.myurl.com"; header('Location: '.$newURL); } } asked 40 secs agojmv Let's block ads! بخوانید...

Vote count: 0 Elasticsaerch's documentation only covers loading a complete index to Spark. from pyspark.sql import SQLContext sqlContext = SQLContext(sc) df = sqlContext.read.format("org.elasticsearch.spark.sql").load("index/type") df.printSchema() How can you perform a query to retu data from an Elasticsearch index and load them to Spark as a DataFrame using pyspark? asked 1 min agoGeorge Lydakis Let's block ads! بخوانید...

Vote count: 0 I want to scroll listview horizontally in my android application. I found many solutions on inteet but that doesn't work for me. Anywhere i found a solution to use gallery instead of listview. But now problem is that, the distance between two consecutive textviews is very much, as shown in image. So i want to reduce it. So that i can scroll and view text effectively. Screen shot of current view MainActivity import android.os.Bundle; import android.support.design.widget.FloatingActionButton; import android.support.design.widget.Snackbar; import android.support.v7.app.AppCompatActivity; import android.support.v7.widget.Toolbar; import android.view.View; import android.view.Menu; ...

Vote count: 0 I have the message type nav_msgs/Odometry constantly publishing linear and angular velocity. I am calculating linear distance by taking Velocity at X and Y, multiply them by 1/rate(Hz) and summing them together. Is this calculation right? Also, I am a bit skeptical about calculating the tu using angular velocity. Any guidance here is appreciated. I am visualizing the path in RViz. It would be great if you could point me to relevant source code that I could look into. asked 29 secs agouser3792934 Let's block ads! بخوانید...

Vote count: 0 In terms of performance and good practice, is it better to create a new row for every new json object or just append objects to an json object array all within one row? I'm building a NodeJS application that will let the user create, read, update and delete data from the json objects. Also, how would you go about appending a new object to a specific json object array in NodeJS and PostgresQL? I couldn't find any examples online. What is the insert command to do it for this example where the table name is "myData", "data" is the column name and I want to insert 5 into "b": data {"a": 1, "b": [1, 2, 3]} asked 1 min agouser3226932 Let's block ads! بخوانید...

Vote count: 0 I have built a Wikipedia dictionary using the following code: from gensim.corpora import WikiCorpus, wikicorpus articles = "enwiki-latest-pages-articles.xml.bz2" wiki_corpus = WikiCorpus(articles) wiki_corpus.dictionary.save("wiki_dict.dict") Now I have a set of text sentences. I want to run a query of these texts against certain words (set of affinity categories), where the definition of these words can be taken out from the wiki corpus. So for example: This is the set of text: ["make a lot of money through magic millions website" , "travel through virgin mobile", ...] This is the set of affinity categories: ["Foodie", "Cooking", ...] So affinity categories are the words that ...

Vote count: 0 I am using xhr to make a call to server and it retus a blob. have set the respnoseType='blob' and it all works fine in chrome and firefox even in ie10+ but doesn't work in safari. if (navigator.appVersion.toString().indexOf('.NET') > 0) { window.navigator.msSaveBlob(blob, fileName); } else { var downloadUrl = URL.createObjectURL(blob); var a = document.createElement("a"); a.href = downloadUrl; a.download = fileName; document.body.appendChild(a); a.click();} what is the right way to do this, as this looks like a hack!. asked 33 secs agouser1861140 Let's block ads! بخوانید...

Vote count: 0 I've been using Renci.SshNet in C# to check some info about a server using an SSH coection. I am trying to use the command: sshClient.RunCommand("show ports").Result; to generate a string and check if all the ports on a server are enabled. The RunCommand().Result method has worked perfectly with every other command but for some reason refuses to print anything when I try to run "show ports." Does anyone know why this could be the case? asked 32 secs agoJpskida Let's block ads! بخوانید...

Vote count: 0 I have 2 Apps which have the same package name but different package IDs(set in gradle config). An activity is started by setting an intent's action string in both the apps which are same in both Apps. This means that if I have both the Apps installed on the same device then starting an Activity shows me a Complete action using.. dialog which asks the user to choose an activity to complete the action with. My question is as to how I can separate them without going through changing the string itself in the manifest files (a lot of them due to multiple modules) and the setting of action string before using startActivity() itself in the codebase so that the actions are limited to ...

Vote count: 0 I'm unable to find an answer to this, or I'm not looking in the right place, but I'm trying to find a way where I can group a number of elements (panels) inside one large panel using both AngularJS and Bootstrap. So for example, I have around 60 or so mini panels that represent customer contact forms. All of these forms sit inside one large panel with an ng-repeat. I am wanting to somehow group my contacts by different criteria (e.g By State code or by Company Type, etc.) from a dropdown control. I would like all contacts to be shown in the one panel but segregated by a .page-header (a similar setup to the example below): Has anyone seen any examples of this anywhere, or have a...

Vote count: 0 I wont start service at specific time everyday and also start when the device boot complete. For example.. at 13.00 Pm everyday the service started and show a Toast ("Service started"). not only that, but the service has to start also at boot complete but if you are not the 13.00 pm should not show the toast but must started Sorry for my english =) asked 23 secs agoEdoardo Goffredo Let's block ads! بخوانید...

Vote count: 0 I am trying to use HTMLUnitDriver in my selenium test to understand how HTMLUnitDriver works. Kindly help me with resolving the issue. I have added the below jars to the build path in eclipse selenium-java-2.53.0 jars TestNG jar Added the below jars as these were mentioned in other posts as a solution to the error I encountered. However, the issue remains. selenium-htmlunit-driver-2.52.0 jar selenium-server-standalone-2.53.0 Hi, I am trying to use HTMLUnitDriver in my selenium test to understand how HTMLUnitDriver works. Kindly help me with resolving the issue. I have added the below jars to the build path in eclipse selenium-java-2.53.0 jars TestNG jar Added the below jars as ...

Vote count: -1 I am new to python and I have to design a Python API(version - 2.7) similar to an existing Java API Python version - 2.7 The Java API is as follows There is a Process interface public interface Process { Future create(Client client) } There are two implementations of Process . For simplicity I have shown the implementation of one 1) FirstProcess2) SecondProcess public class FirstProcess implements Process { Future create(Client client) { } } There is a ProcessFactory public interface ProcessFactory { Process createProcess() } There are two implementations of ProcessFactory1) FirstProcessFactory2) SecondProcessFactory For simplicity I have just shown the implementation of one p...

Vote count: 0 I am making a simple game that involves users pressing unbuttons. Each time the user presses a button I want a sound to play. The sound file that I want to play is 3 seconds long. However it is highly likely that the user will press 1 or more uibuttons onscreen within the 3 second window that the sound is playing. So at the moment if a second UIButton is press while the sound is playing than the sound will not play. How can I have it so that the buttons play the sound even if the the original sound is playing? import UIKit import AVFoundation class ViewController: UIViewController { var player:AVAudioPlayer = AVAudioPlayer() override func viewDidLoad() { super.viewDidLoad() let...