select first three values order by a column
◷
تاریخ انتشار: 1395/4/4 | ساعت: 7:47
Vote count: 0 i have 2 tables : med CREATE TABLE med (id_med INT AUTO_INCREMENT PRIMARY KEY, name_m VARCHAR(50), su ame_m VARCHAR(50), spec VARCHAR(50), UNIQUE (su ame_m,name_m)); viz CREATE TABLE viz (id_m INT NOT NULL, id_p INT NOT NULL, id_c INT NOT NULL, dt DATETIME) i need to select the first 3...
How do I convert 2.0E-6 to 0.00000200 in PHP?
◷
تاریخ انتشار: 1395/4/4 | ساعت: 6:18
Vote count: 0 How do I convert 2.0E-6 to 0.00000200 in PHP ? I try to multiply 0.00000100 by 2 and I need the exact value. asked 28 secs agoJohn Book Let's block ads! (Why?)
Select the first JSON array child value
◷
تاریخ انتشار: 1395/4/4 | ساعت: 6:18
Vote count: 0 I want to get the value that holds the first child of a JSON array. This is the array : var sms = { '1' : { 'address' : '+123', 'body' : 'SMS1' }, '2' : { 'address' : '+123', 'body' : 'SMS2' }, '3' : { 'address' : '+123', 'body' : 'SMS3' }, '4' : { 'address' : '+123', 'body' : 'SMS4' }...
Is it possible to build this query in SQL or With PL/SQL?
◷
تاریخ انتشار: 1395/4/4 | ساعت: 6:18
Vote count: 0 I have This Tables: 1- Users Table ╔════════╦═════════╗ ║ UserID ║ Name ║ ╠════════╬═════════╣ ║ 12345 ║ Scott ║ ╠════════╬═════════╣ ║ 54321 ║ Jeffry ║ ╠════════╬═════════╣ ║ 98765 ║ Larry ║ ╚════════╩═════════╝ 2- ScoreTypes Table ╔══════════════════╦════════════╗ ║ ScoreTypeID (PK) ...
search through an array of hashes
◷
تاریخ انتشار: 1395/4/4 | ساعت: 5:17
Vote count: 0 @users = [ {id:"0", name:"Thomas One", email:"thomas@fake.nl", password:"adkdjaso"}, {id:"1", name:"James Five", email:"j4@fake.nl", password:"jdajdlae"}, {id:"3", name:"Gordon Four", email:"g4@fake.nl", password:"adsldsae"} ] def getId puts "what is your email address?" @account = get...
How do you access the element HTML from within an Angular 2 attribute directive?
◷
تاریخ انتشار: 1395/4/4 | ساعت: 5:17
Vote count: 0 The Angular 2 docs provide an example for creating an attribute directive that changes the background color of an element: https://angular.io/docs/ts/latest/guide/attribute-directives.html <p myHighlight>Highlight me!</p> import { Directive, ElementRef } from '@angular/core'; @Directiv...
XML dummy file generator form XSD schema
◷
تاریخ انتشار: 1395/4/4 | ساعت: 5:17
Vote count: 0 I want to generate dummy xml files from XSD schema. Is this possible? Any heads up how to do it. Thanks asked 32 secs agoOmar Rana Let's block ads! (Why?)
MissingKeyMapError that just began occurring with Google Charts + displayMode = text
◷
تاریخ انتشار: 1395/4/4 | ساعت: 4:10
Vote count: 0 Same problem as described in ERROR: Google Maps API error: MissingKeyMapError, except that: this is with Google Charts instead of Google Maps unlike for Google Maps, there seems to be no documentation on how to get a key or use a key when it comes to charts / visualization (e.g. var ma...
Adding counts based on flags by dates
◷
تاریخ انتشار: 1395/4/4 | ساعت: 4:10
Vote count: 0 Could you please advise some direction on how to achieve the below format? I am at lost thinking solution for this problem.. date: 6/20/2016 1 0 5 6/20/2016 2 0 6 6/20/2016 3 1 4 6/20/2016 4 1 2 6/20/2016 5 0 4 6/20/2016 6 0 6 6/21/2016 1 0 4 6/21/2016 2 0 3 6/21/2016 3 1 7 6/21/2016 4...
SQL Partition Dates
◷
تاریخ انتشار: 1395/4/4 | ساعت: 4:10
Vote count: 0 I have data such as this: ID|From Date |To Date 1 |01/01/2014 |04/01/2015 1 |04/01/2015 |01/01/2016 1 |01/01/2016 |12/31/2016 But I would like this as the end result: ID|From Date |To Date 1 |01/01/2014 |12/31/2016 I tried partitioning, but I'm not quite familiar with how it works. Any...
Image Capture Intent makes image file different permission
◷
تاریخ انتشار: 1395/4/4 | ساعت: 3:04
Vote count: 0 I'm trying to give the user the option to either supply a photo they've taken in the past, or take a new photo right now. The issue is that when I try to use the image, I get a "permission denied." This is where I make the chooser intent: final File root = new File(Environment.getExte ...
CreatePolygonRgn and const POINT *
◷
تاریخ انتشار: 1395/4/4 | ساعت: 3:04
Vote count: -1 I give you only the lines conce ing my problem. I don't know why this does not compile : POINT ptVertex[5]; ptVertex[0].x = 180; ptVertex[0].y = 80; ptVertex[1].x = 100; ptVertex[1].y = 160; ptVertex[2].x = 120; ptVertex[2].y = 260; ptVertex[3].x = 240; ptVertex[3].y = 260; ptVertex[4...
Is this type punning well-defined?
◷
تاریخ انتشار: 1395/4/4 | ساعت: 3:04
Vote count: 1 Reading quote in this answer about strict aliasing rule, I see the following for C++11: If a program attempts to access the stored value of an object through a glvalue of other than one of the following types the behavior is undefined: ... an aggregate or union type that includes one o...
How to execute two different directives with $parsers and $validators on a same element?
◷
تاریخ انتشار: 1395/4/4 | ساعت: 0:46
Vote count: 0 Issue is that only the first directive is working and other one is not. Provided below are the two directives. Both works fine when working alone. .directive("restrictInvalidInput", function($rootScope, utils) { retu { restrict: "A", require: "ngModel", priority: 1, link: function(scop...
JSONObjectWithData failing in Swift
◷
تاریخ انتشار: 1395/4/4 | ساعت: 0:46
Vote count: 0 I am using REST api's (from HERE maps) for various services. I am trying to parse JSON results. One works and the other doesn't. The first one is a direction service that will spit out a direction between 2 locations. This is the JSON output: {"results":[{"waypoints":[{"id":"1 Infinite...
(SQL) Creating an uncorrelated query
◷
تاریخ انتشار: 1395/4/4 | ساعت: 0:46
Vote count: 0 I had to write an SQL-Query for a given Database (it's huge, I won't be able to post it here, but its about artists with albums and release dates, genres etc.). The Task was to find all artists involved in albums which contains the word "drop". I had to write an correlated and an uncor...
T-SQL with external script execution for in-database R integration
◷
تاریخ انتشار: 1395/4/3 | ساعت: 23:20
Vote count: 0 I'm trying to convert a scaleR script into T-SQL (with exte al_script execution) for in-database R analytics in SQL Server. The scaleR script that I'm working with is on the DeepDive Data Science Tutorial on Fraud data by MSDN.All my data is in SQL Server now (from the tutorial), and a...
MySQL - SELECT words composed only by specified letters
◷
تاریخ انتشار: 1395/4/3 | ساعت: 23:20
Vote count: 0 I'm trying to write a MySQL query to select words composed only by specified letters. For example given the sequence 'by' would be selected words like 'b', 'y', 'byb', 'bbyy', 'byyybb', 'yy' and so on. So only words composed by 1 or more occurrence of 1 or more of those letters, kind o...
Windows background service to kill processes by name on demand
◷
تاریخ انتشار: 1395/4/3 | ساعت: 23:20
Vote count: 0 I want to write a simple background service that can kill all instances of a certain process for all users on demand. The process will always be the same (Microsoft Access). The idea is that users without administrative rights are able to execute a script, which tells the background se...
pass variable to controller via ajax MVC 5
◷
تاریخ انتشار: 1395/4/3 | ساعت: 20:02
Vote count: 0 I load a partial view through ajax action link. @Ajax.ActionLink(" ", "adduser", "users", new { use ame = item.UserName }, new AjaxOptions() { UpdateTargetId = "add_research" }, new { @class = "glyphicon glyphicon-link" }) I pass it to controller like public ActionResult AddUser(string...