Image

i have simple sql query inner join between tables , b, filtering. table large, whereas table b small. want return rows match filter, e.g., table_b.some_col in ('a', 'b', 'c', 'd'). of course, have filter clause. however, recommended me duplicate same filter, table , put in join. example, select * table_a inner join table_b on table_a.pk = table_b.pk , table_a.some_col in ('a', 'b', 'c', 'd') table_b.some_col in ('a', 'b', 'c', 'd') it claimed doing improves query plan. unfortunately, due security restrictions on machine, cannot inspect query plans. claim true? adding filter @ and or where clause doesn't make difference.. here tests .. query used.. select * orders o join hr.employees h on h.empid=o.empid filter @ , clause.. , empid=4 execution plan : set statistics io: table 'orders'. scan count 1, logical reads 20, physical re

i've got d3 bar chart created i'm uncertain how update it. data being updated when try run through .enter() , .exit() stuff different errors commonly .exit() function doesn't exist. point being not proper way update chart's svg. i've provided codepen here relevant code below. var b_margin = {top: 20, right: 20, bottom: 30, left: 100}, b_width = 450 - b_margin.left - b_margin.right, b_height = 200 - b_margin.top - b_margin.bottom; var x = d3.scale.ordinal() .rangeroundbands([0, b_width], .1); var y = d3.scale.linear() .range([b_height, 0]); var xaxis = d3.svg.axis() .scale(x) .orient("bottom"); var yaxis = d3.svg.axis() .scale(y) .orient("left"); var barsvg = d3.select("body").append("svg") .attr("width", b_width + b_margin.left + b_margin.right) .attr("height", b_height + b_margin.top + b_mar

i have table , want make dots-button cell's width equal button width. how can make possible? , make entire cell no border , no background color, don't know how can. think there's bootstrap class interfering. <div class="col-md-12 column table-responsive" id="tablapagos" style="padding-right:0;"> <table class="table table-bordered table-hover" id="tabla_cobros_programados"> <thead class="thead-gray"> <tr> <th class="col-md-2 text-center"> fecha </th> <th class="col-md-3 text-center"> concepto </th> <th class="col-md-3 text-center"> monto </th> <th class="col-md-3 text-center"> detalle

i trying have workbook current work ticket data updated new ticket data. have nested each loops @ bottom check equality in ticket number. if finds match, supposed update cells new data. if ticket not in list of tickets, it's supposed add new ticket bottom. keeps happening tickets in spreadsheet, keeps adding tickets newdata bottom of currentdata. think problem lies logic in these nested loops can't figure out i'm doing wrong. sub getnewdata() dim newdata workbook dim ndlastrow long dim currentdata workbook dim cdlastrow long dim ndrangetocheck range dim cdrangetocheck range dim ndrow long dim cdrow long set newdata = workbooks.open("c:\users\<user>\documents\newdata.xlsx") set currentdata = thisworkbook ' assign last row , range compare each workbook newdata.worksheets("incident list").range("a2").select activesheet ndlastrow = .cells(.rows.count, "a").end(xlup).row end set ndrangetocheck = newdata.worksheets(&q

i'm trying use document.write javascript function set external css file in template, but, want via twig this: document.write('<link href="{{ asset('bundles/activos/css/app-orange.css') }}" rel="stylesheet" >'); but not work. why document.write function not working? can put twig code in there? or best way pass css route twig document.write javascript function? sorry if english not good. hope understand. thanks. try this {% stylesheets "@activosbundle/resources/public/css/app-orange.css" "%kerner.root_dir%/resources/css/main.css" %} <link type="text/css" rel="stylesheet" media="all" href="{{ asset_url }}" /> {% endstylesheets %}

i have requirement must email list of failed tests within maven spring batch application po in daily manner. unfortunately not have access deployment tools teamcity set-up such warning emails. must in codes. , trying avoid leave trails of of test assertion failed exceptions in logs have repeated test piece of test codes and email noted failed test list , otherwise abandon email if tests have been passed. can achieve this?

i'm having hard time using following typings file in project: https://github.com/definitelytyped/definitelytyped/tree/master/log4javascript apperantly, file missing module declaration, causing typescript complain can't find module 'log4javascript' when put following statement in typescript file: import * log4javascript 'log4javascript'; when manually edit index.d.ts file installed running command typings install dt~log4javascript --global --save and add module declaration: declare module "log4javascript" { import test = log4javascript; export = test; } at end of file, compiler no longer complains , code works without using import * statement. so how supposed use typings file can use log4javascript typescript? update i've managed work around creating custom.d.ts file declares log4javascript module alongside generated root index.d.ts of typings , added ///<reference path="..." /> statement in mai

i'm trying protactor test running. when making use of module throws below. i'm quite new es6 how configure it. export { getfreeport }; ^^^^^^ syntaxerror: unexpected token export @ object.exports.runinthiscontext (vm.js:76:16) @ module._compile (module.js:513:28) @ module._extensions..js (module.js:550:10) @ object.require.extensions.(anonymous function) [as .js] (c:\dev\code\jg.crowdfunding.website\node_modules\babel-register\lib\node.js:156:7) @ module.load (module.js:458:32) @ trymoduleload (module.js:417:12) @ function.module._load (module.js:409:3) @ module.require (module.js:468:17) @ require (internal/module.js:20:19) @ object. (c:\dev\code\jg.crowdfunding.website\protractor.conf.js:4:18) my babelrc file has { "presets": ["es2015"] } the imported file error occurs looks like var freeport = require('freeport'); var getfreeport = function () { return new promise((

i need run grails 3 app against mysql / hibernate , mongodb . (had running on grails 2.5 without hitch). i tried many different combinations, searched , tried related answers, no luck. used latest mongodb plugin doc configuration. using grails 3.1.10: grailsversion=3.1.10 i started following details in build.gradle: buildscript { ext { grailsversion = project.grailsversion } repositories { mavenlocal() maven { url "https://repo.grails.org/grails/core" } } dependencies { classpath "org.grails:grails-gradle-plugin:$grailsversion" classpath "com.bertramlabs.plugins:asset-pipeline-gradle:2.8.2" classpath "org.grails.plugins:hibernate4:5.0.10" } } ... dependencies { compile "org.springframework.boot:spring-boot-starter-logging" compile "org.springframework.boot:spring-boot-autoconfigure" compile "org.grails:grails-core" compile "org.springframework.boot:s

am sorry if there's question out there, don't know how put question , i've searched others looks mine can't find same problem mine. i designing responsive web design site works fine taste on mozilla firefox because design tried opening site on google chrome , opera, navigation leaves space can filled either adding padding or height , doing it'll affect page on mozilla. website: http://hwebtest.orgfree.com the website located on free hosting server because it's on development. thanks taking time read post. reviews appreciated.

how can show webpage in center of webview(match parent width , height) if webpage's height less screen's height? content rendering on webview comming epub files. for example if screen's height 1000px , web page's height 600px.then content should take padding 200px bottom , top. thanx in advance..

i need create function interpolate noise values on landsat image time series mean on time span of 2 (xt+1 , xt-1). i´m using fmask product detect cloud , shadow, interpolation applied. for 1 time series: since c2 vector of fmask time series (2 cloud , 4 shadow), , t2 vector of evi time series: (i in 2:(length(t2)-1)){ if (c2[i]==2 | c2[i]==4) t2[i]<-mean(c(t2[i-1], t2[i+1]))} but not possible using calc function of raster package, because not works functions 2 parameters. any suggestion how deal , apply interpolation pixels of raster time series? i´m trying this, still not working: for (i in 2:(length(stacklist)-1)){ re<-raster(stacklist[i]) re1<-raster(stacklist[i+1]) re0<-raster(stacklist[i-1]) rc<-raster(stacklist2[i]) if (rc[i]==2 | rc[i]==4) re[i]<-mean(c(re0[i],re1[i])) writeraster(re,filename =paste0(substr(stacklist[i], 48, 59),"_filtered.tif"))} i believe following meet needs. i'm assu

below code wrote mocha, chai , supertest. have question regards segment of code below works, focus on token. describe('authenticated usertest', function () { var token; before(function loginauth(done) { request(app) .post("/login/local") .send("username=testname") .send("password=qwe123qwe") .expect(function (res) { should.exist(res.body.token); token = res.body.token; }) .end(done); }); it('should give me defined token', function(done) { console.log("token " + token); done(); }); }); apparently, token defined , here. however, when remove done function follows: describe('authenticated usertest', function () { var token; before(function loginauth() { //done removed here request(app) .post("/login/local") .send("

i have 15 million datas. , each datas has name, title. , datas in text file. how can find datas contains text. search text: hi example data: peter|just text. brown|hi, nice meet john|hello, world! hi|hello hello|this not matched data. ... result data: brown|hi, nice meet hi|hello ... when searching. spends 7 seconds. but, want faster database. how can do?

i have created sample angular 2 application , converted hybrid app using cordova. works fine , apk/ipa size 33mb. didn't use large images/files. guess it's due node modules present.another problem in ios takes more time build (around 10 - 15 minutes). can suggest how reduce apk/ipa size app can build , run fastly??

i trying simple multiplication application , public virtual int multi(int a, int b) { return * b; } i trying mock using moq. in namespace unittestproject1 { [testclass] public class unittest1 { [testmethod] public void testmethod1() { int = 5; int b = 10; mock<webform1> titi = new mock<webform1>(); // webform1 obj = new webform1(); //int real= obj.multi(a, b); // titi.setup(x => x.data()).returns(true); titi.callbase = true; var data= titi.setup(x => x.multi(a, b)).returns(50); assert.areequal(true, titi.object); //assert.areequal(50, titi.object); } } } where in mocking output getting assert.areequal failed. expected:<true (system.boolean)>. actual:<castle.proxies.webform1proxy (castle.proxies.webform1proxy)> it means actual & expected not matching, why gettin

is possible on drawable xml file? <stroke android:width="1dp" android:color="xamarin.forms.color.red.toandroid" /> i want able have list of colors on shared project , able use them on xml files on android? thanks. via code, can use xamarin.forms.platform.android.colorextensions convert xamarin.forms color android.graphics.color . within xamarin.android project (custom forms renderers, etc...): android.graphics.color acolor = xamarin.forms.color.blue.toandroid() xamarin.forms.color based on w3c standards can use these android color xml resource file provide same colors within custom axml -based drawables/layout/etc... <?xml version="1.0" encoding="utf-8"?> <resources> <color name="white">#ffffff</color> <color name="yellow">#ffff00</color> <color name="fuchsia">#ff00ff</color> <color name="red">#ff0000</color>

i images base64 encoded string front end , have decode them , save them images in server. image can of format- png,gif or jpeg. part works fine. images uploaded users can of large size, i'm trying compress them backend , part failed miserably. i have 2 functions. 1 converting base64 string image , other 1 compressing it. this function converts string image. function uploadtimelineimage($base64img) { $data= array(); $upat=date('ymdhis'); if (strpos($base64img, 'data:image/png;base64') !== false) { $img = str_replace('data:image/png;base64,', '', $base64img); $img = str_replace(' ', '+', $img); $data = base64_decode($img); $extension= 'png'; } if (strpos($base64img, 'data:image/gif;base64') !== false) { $img = str_replace('data:image/gif;base64,', '', $base64img); $img = str_replace(' ', '+', $im

in knockout can put data-bind in object isn't view model? trying make available whole page common settings or theme related values. don't want add them every view model. i.e. data-bind="myglobalsingleton.prop" yes can, property binding to, needs knockout observable within object. otherwise won't able use benefits of two-way binding.

i designing (farly big) application company. application users can generate content in form of xml documents, might want share among each other. it might seem trivial question @ first, need default location when user clicks save button. unfortunately there different operating systems , haven't worked of them, don't know common thing do. .jar executed anywhere , current execution directory doesn't seem professional solution. neither desktop. there way proper system depended location use? on windows c:/program files/application_name or c:/users/user/appdata/application_name used. in research stumbled upon c:/documents , settings/all users/application data/

this question has answer here: picturebox , dispose 1 answer link previous question, gives background situation i answered own question above programmatically changing images tempory folder attachments saved. caused new issue me when fixing own problem feel separate former. as program closes, delete images temporary directory. since have got preview work fine upon clicking on different images. following error when trying close program (the deleting of images happens on event): the process cannot access file 'c:\temp\digitalarchive\filename.jpg' because being used process. so have attempted resolve clearing picture temp folder before hand via: if (picattachpreview.image != null) { picattachpreview.image.dispose(); picattachpreview.refresh(); } //runs through each file in temporary directory , remov

i'm trying write simple unit test , have problem mocking/substitutes. the method want test looks this: public override void execute(object parameter) { var openfiledialogviewmodel = new openfiledialogviewmodel { addextension = true, defaultextension = "xxx", filter = "xxx files|*.xxx" }; bool result = mfiledialogservice.openfile(openfiledialogviewmodel); if (result) { mdatabaseloadingservice.loadfile(openfiledialogviewmodel.filename); } } for test want set filename, call execute method , check whether file loaded or not. in test used 'nsubstitute' tell 'openfile' method of 'filedialogservice' return true this: mfiledialogservice.openfile(arg.any<iopenfiledialogviewmodel>()).returnsforanyargs(true) but how set 'filename' property of 'openfiledialogviewmodel'?

let's have product class, how can tell php want accept array of product ? in other words, there way method?: private function method(product[] $products) { // ... } i thought doing this: private function validate($products) { foreach ($products $product) if (!is_a($product, 'product') return false; // ... } it work, don't idea of adding bunch of lines make sure it's " product[] ". you can type hint whatever container is. have private function method(array $products) php can validate argument in given type hint, , not argument might contain. the best way validate array loop said, make slight change private function validate(array $products) { foreach($products $product) if (!($product instanceof product)) return false; } the benefit here avoid overhead of function call another idea make wrapper class class product_wrapper { /** @var array */ protected $p

i make website facebook notifications. tried send notification account. here code: require 'facebook/autoload.php'; $facebook = new facebook\facebook(array( 'appid' => fb_app_id, 'secret' => fb_app_secret, )); $post = $facebook->api('/' . $user['uid'] . '/notifications/', 'post/v2.2/', array( 'access_token' => fb_app_id.'|'.fb_app_secret, 'href' => "http://mydomainlink.com", //this link app's root, don't think works, seems link app's canvas page 'template' => 'max 180 characters', 'ref' => 'notification sent '.date("y-m-d g:i:s") //this facebook's insight )); and result: fatal error: uncaught exception 'facebook\exceptions\facebooksdkexception' message 'required "app_id" key not supplied in config , not find fallback environmen

i use mysql -u root -p connect mysql on osx terminal. works fine , can create , view databases. but these databases different ones can see on mysql workbench phpmyadmin. ones of latter 2 same. how open mysql databases can see on terminal on workbench or other gui? also when connect laravel db, db_connection=mysql db_host=127.0.0.1 db_port=3306 db_database=somedb db_username=root db_password='abcd' it connects dbs on mysql terminal, not ones on phpmyadmin & workbench. do have different sqls running? .. , how fix it? i think command can check if there 2 instances of mysql running on machine or not. ps aux | grep mysqld

i working on amcharts donut chart. i able create chart , giving events both slice , labels. for chart added rolloverslice event. then added script lazyload chart in order create chart once page scrolls particular section. now chart creating lazyload, roll on event label not working. following script used create chart , lazyload. script /*lazy load code starts here*/ amcharts.lazyloadmakechart = amcharts.makechart; // override makechart function amcharts.makechart = function(a, b, c) { // set scroll events jquery(document).on('scroll load touchmove', handlescroll); jquery(window).on('load', handlescroll); function handlescroll() { var $ = jquery; if (true === b.lazyloaded) return; var ht = $('#' + a).offset().top, hh = $('#' + a).outerheight() / 2, wh = $(window).height(), ws = $(window).scrolltop(); if (ws > (ht + hh - wh)) { b.lazyloaded = true; amcharts.lazyloadmakec

i'm working on newsletter have make 2 columns , used 2 divs @ 50% of width it. problem div on right goes above content. how fix please? thank's here fiddle #yellow { background-color: rgb(214, 196, 0); width: 100%; margin-bottom: auto; } #yellowl { float: left; width: 50%; } #yellowr { position: relative; float: right; width: 50%; } #h1v2 { color: rgb(67, 153, 186); background-color: rgb(214, 196, 0); } <div id="yellow"> <h1 id="h1v2">geschäftsverlauf / déroulement des affaires</h1> <div id="yellowl"> <h1 id="h1v2">offerten</h1> <p> </p> <h1 id="h1v2">projekte</h1> <p> </p> </div> <div id="yellowr"> <h1 id="h1v2">offres</h1> <h2>bruit</h2> <p> </p> <h2>sols<

i display pet owners (clients) using list_display , each owner comma-separate list of of pets (patients). the foreign key in patient table, such owner can have many pets, pet can have 1 owner. i've got following work advise whether acceptable approach. from .models import client, patient class clientadmin(admin.modeladmin): list_display = ('first_name', 'last_name', 'mobile', 'patients') def patients(self,obj): p = patient.objects.filter(client_id=obj.pk) return list(p) this looks like: thanks guidance. update: here's i'm @ far: here's i've managed working far class clientadmin(admin.modeladmin): list_display = ('first_name', 'last_name', 'mobile', 'getpatients') def getpatients(self, request): c = client.objects.get(pk=1) p = c.patient_fk.all() return p this following docs re: following relationships backwards . of course

my aim make slider has 2 divs. 1 text , 1 image alongside each other. however, have been unable trying own code @ home or cycle2 support pages. did manage find jsfiddle had been having similar issue. updated jsfiddle here , seems work , shows want achieve. bizarre thing if try same code on computer or if set own jsfiddle same code , external resources cannot make slider work. the html: <div class="cycle-slideshow" data-cycle-fx="carousel" data-cycle-timeout="3600" data-cycle-slides="> div.home-block" data-cycle-carousel-visible="1" > <div class="home-block"> <div class="brief"> </div><div class="examples"> </div> </div> <div class="home-block"> <div class="brief"> </div><div class="examples"> </div> </div> </div> and cs

i using lucene.net index , search pdf on local system. how can index , search pdf on amazon s3. is possible? i did research, there many ways can achive this. 1 way cloudsearch , indexing service provide functionality

i have trivial classes dependency: class { ... // constructor omitted public: const std::string str1; }; class b { public: std::shared_ptr<a> a; } boost_python_import(wrapped) { class_<a, std::shared_ptr<a>>("apy") .def_readonly("str1", &a::str1); class_<b>("bpy") .def_readwrite("a", &b::a); } in python import wrapped wr b = wr.bpy() s1 = b.a.str1 // apy wrapper created s2 = b.a.str1 // new apy wrapper created though object same is there way create apy wrapper once object? especially, because inner object immutable(in particular case). otherwise, there considerable overhead of creating lots of such temporary objects. the apy wrappers temporaries because s1, s2 strings. once s1 created, python doesn't care if setup created used create s2 . b.a gets discarded because isn't stored. same thing happen when like a1 = b.a s1 = a1.str1 s2 = a1.str1 ? u

i'm working orion context broker , i'm trying add new subscription i'm getting error callback missing though have provided one. here entities have $ curl localhost:1026/v2/entities -s -s --header 'accept: application/json' | python -mjson.tool [ { "id": "room1", "pressure": { "metadata": {}, "type": "integer", "value": 720 }, "temperature": { "metadata": {}, "type": "float", "value": 23 }, "type": "room" }, { "id": "room2", "pressure": { "metadata": {}, "type": "integer", "value": 711 }, "temperature": { "metadata": {},

suppose want declare const member function via typedef : typedef int fc() const; typedef int f(); struct { fc fc; // fine, have 'int fc() const' const f fc; // not fine, 'const' ignored, have 'int fc()' }; since const ignored program compiles fine. why const ignored function? since can form const pointer in way thing can think of 'c heritage'. standard it? c++ 14 standard, [dcl.fct] pt. 7: the effect of cv-qualifier-seq in function declarator not same adding cv-qualification on top of function type. in latter case, cv-qualifiers ignored. [ note: function type has cv-qualifier-seq not cv-qualified type; there no cv-qualified function types. — end note ] example: typedef void f(); struct s { const f f; // ok: equivalent to: void f(); }; so, correct behavior.

so little complicated explain, i'll try best. i want have excel file cell call count, purpose of number gets set manually when read data in worksheet reads data row, , @ end of test want add 1 onto number. public string[] readnewhiredata() { string ex2[] = new string[100]; try { simpledateformat sdf = new simpledateformat("dd/mm/yyyy"); file file = new file("c:/users/saahme/documents/filepath.xls"); workbook workbook = workbookfactory.create(file); sheet worksheet = workbook.getsheetat(1); row rowcount = worksheet.getrow(1); cell count = rowcount.getcell(11); thecount = new bigdecimal(count.getnumericcellvalue()).toplainstring(); row row1 = worksheet.getrow(integer.parseint(thecount)); cell firstname = row1.getcell(0); ex2[0] = firstname.getstringcellvalue(); } catch (filenotfoundexception e) { e.

i have string : data = "[\"super\", \"cool!\", \"bien écrit\", \"first!\", \"why speaking french here?\"]" i transform : data = ["super", "cool!", "bien écrit", "first!", "why speaking french here?"] parse json. try require 'json' data = json.parse data

i'm creating .csv-files every worksheet in workbook excel macro. works fine if run macro clicking on macro in developer-tab , run macro there. if run macro form-button inside excel-file, creates csv-file every worksheet, no content. here vba-code: 'this method generates csv-files every worksheet in workbook. sub btngeneratecsv_click() dim ws excel.worksheet dim savetodirectory string dim intresult integer on error goto heaven 'disable script unnecessary things. application.screenupdating = false application.enableevents = false application.displayalerts = false 'opens file dialog choosing destination folder intresult = application.filedialog(msofiledialogfolderpicker).show if intresult <> 0 'if selection made, selected path saved variable. savetodirectory = application.filedialog(msofiledialogfolderpicker).selecteditems(1) & "\" each ws in thisworkbook.worksheets

i have requirement download file url, post site via single js call. use case: user enter file url click re-upload button conditions: the file either audio/wav, audio/mp3, or zip file multiple wav , mp3 i need post using multipart/form-data questions: how create multipart/form-data request via js manually? correct me if wrong, think need store file content input field once download it. how encode file content string comes byte[] when uploaded?

i'm using eclipse neon (4.6) papyrus (2.0) , created 2 sequence diagrams. i'm struggling set different properties in them. instance if change name in diagram 1 name changed in diagram 2. cannot find way set different name! have gates on both diagrams although drew them 1 diagram , cannot rid of them anymore. can removed or added in both diagrams! after few restarts of eclipse created new sequence diagram , noticed problems don't occure anymore.

in angular 1, if wrote component, make sure that: dependencies, such services being mocked. unit tests written methods within component. the component calling service retrieve data expect(service.method).tohavebeencalled() the component updating view given updated model. i've been doing research on angular 2 component testing, , articles can find, seems testing being done follows; create service mock returns fixed result (ex: 'test quote') expect view contains result coming mocked service (ex; there's div somewhere has <div>test quote</div> ). here few examples of such articles (basically top results on google 'angular 2 component testing') http://chariotsolutions.com/blog/post/testing-angular-2-components-unit-tests-testcomponentbuilder/ http://blog.rangle.io/testing-angular-2-applications/ http://www.itsmycodeblog.com/angular2-unit-testing-a-component/ https://developers.livechatinc.com/blog/testing-angular-2-apps-depende

every time build cordova project, build process stuck 8 minutes. last line in log when happens : incremental java compilation incubating feature. has seen happen before? i'm using visual studio 2015 , running on windows 10 build 14393.10. my question why build proccess takes long? update: here build logs: 1>------ build started: project: bazimtest, configuration: release android ------ 1> environment has been set using node.js 4.4.7 (x64) , npm. 1> ------ ensuring correct global installation of package source package directory: c:\program files (x86)\microsoft visual studio 14.0\common7\ide\extensions\apachecordovatools\packages\vs-tac 1> ------ name source package.json: vs-tac 1> ------ version source package.json: 1.0.42 1> ------ package installed globally @ correct version. 1> ------ cordova tools 6.3.0 installed. 1> ------ build settings: 1> ------ build settings: 1> ------ platformconfigurationblddir: c:\users\poury\d