Tomorrow

i know gets executed first in sas sql pass thru in code: connect oledb mydb ( %dbconnect( catalog = mydb ) ) ; create table mydb_extract select put(parent,$abc.) parent, put(pfx,z2.) pfx,* connection mydb ( select appointment,parents,children,cats,dogs mydb.dbo.flatrecord appointment between '20150801' , '20150831' , children > 2); disconnect mydb; since ms sql-server doesn't support put function query cause of records processed locally or resultant records dbms? the explicit pass-through query still process , return sas returns (however many records is). then, sas perform put operations on returned rows. so if 10000 rows in table, , 500 rows meet criteria in where , 500 records go sas , put ; sql handle 10000 -> 500. if had written in implicit pass through, it's possible (if not probable) sas might have done of work.

this question has answer here: how return response asynchronous call? 24 answers this code: document.getelementbyid('revealuser').onclick = displaydausers function displaydausers(){ pullallusersfromdb(); debugger; } function pullallusersfromdb(){ rootref.child('users').on('value', function(snapshot) { var users_array = []; var users_object = snapshot.val(); object.keys(users_object).map(function(key) { users_array.push(users_object[key]); }); // window.dateapp.allusers = users_array; return users_array }); } html: <input type="submit" id="revealuser" value="reveal user"> i put debugger in see problem not help. when go console , type in users_array uncaught referenceerror: users_array not defined(…) new code (edit): according stackoverflow answers should w...

i'm trying 1 of semigroup exercises in haskell book (chapter 15, "monoid, semigroup") i'm stuck. following given: newtype combine b = combine { uncombine :: (a -> b) } and i'm supposed write semigroup instance combine . and book says must behave following: prelude> let f = combine $ \n -> sum (n + 1) prelude> let g = combine $ \n -> sum (n - 1) prelude> uncombine (f <> g) $ 0 sum {getsum = 0} prelude> uncombine (f <> g) $ 1 sum {getsum = 2} prelude> uncombine (f <> f) $ 1 sum {getsum = 4} prelude> uncombine (g <> f) $ 1 sum {getsum = 2} so first started wrong solution type checks: instance semigroup (combine b) combine f <> combine g = combine f that not expected of course, step in right direction. , thinking following, in pseudocode: instance semigroup (combine b) (combine f) <> (combine g) = combine (something) that something being: f , g appended, whatev...

i writing stored procedure perform following operations: begin transaction perform tasks use service broker kick-off background process wait response message (with job status) service broker commit or rollback transaction, depending on response message the issue service broker communication not working inside transaction : the message queue has activation enabled, associated stored procedure not executed ( print statements in stored procedure not written errorlog file) receive command times out here's extract of code: -- comment out following line make work begin tran t1 declare @update_msg xml([sb].[service_broker_xxx_schemas]) = ' <request xmlns="xxx"> <table xmlns="xxx"> <fields> xxx </fields> </table> <requested_by>xxx</requested_by> </request>' declare @conversation_handle uniqueidentifier ,@message_body varbinary(max) ,@message_ty...

i see examples flow data in documentation , can't find means fields: { "rws": [ { "rw": [ { "fis": [ { "fi": [ { "tmc": { "pc": 6467, "de": "gladenbach", "qd": "+", "le": 12.52997 }, "cf": [ { "sp": 55.2, "cn": 0.73, "ty": "tr", "jf": 0, "su": 55.2, "ff": 52.6 } ] } ] } ], "li": "d01-06464", "de": "l3048", "pbt": "2015-08-20t08:27:45z", "mid": "ff3e7aab-eece-438c-818b-5920e4581330|" }, { "fis": [ { "fi": ...

i've opencart website , have 2 domain example.com , example2.com. first website in running example.com , working fine. when have copied code files , import database example2.com , running same code set , database. after time database truncating. note both domain on same server , i'm using godaddy cpanel hosting. please me figure out problem.

so have sheet i'd apply formula every 7th row. can't same formula, needs "offset" formula well. for example, first range formula "=(c4+c5)-c3"; second range, "=(c11+c12) - c10"; , on. this have far: sub applyformula() applycf range("c6") applycf range("c13") 'and on, every 7 rows 'is there other way can apply these ranges instead of typing them? 'with offset formula or that. end sub sub applycf(rng range) rng.formula = "=(c4+c5)-c3" 'i'd macro "offset" formula, 'so c13 range "=(c11+c12) - c10" end sub for applycf sub, this: sub applycf(rng range) if rng.count <> 1 exit sub ' in case range more 1 cell dim prevcell range, twoprevcell range, threeprecell range set prevcell = rng.offset(-1, 0) set twoprevcell = rng.offset(-2, 0) set threeprevcell = rng.offset(-3, 0) rng.formula = "=(" & twoprevc...

using sql server 2008 r2. i'm trying convert poor xml data stored 1 big string in column. right now, i'm extracting value using string parsing routines i'd use xpath , xquery , want create stored procedure requires instrumentid required input start , end dates optional parameters. here way i'm doing using t-sql: use mydb declare @first varchar(15), @second varchar(15), @datelow datetime, @datehigh datetime, @instrumentid varchar(15) set @first = '<instrumentid>' set @second = '</instrumentid>' set @datelow = '2003-04-01' set @datehigh = '2004-01-13' set @instrumentid = null set @instrumentid = 'sb2093780001' select * (select out_interface_id, msg_id, substring(xml_msg, charindex(@first, xml_msg) + len(@first), charindex(@second, xml_msg) - charindex(@first, xml_msg) - len(@first)) instrumentid, msg_type, xml_msg, cast(xml_msg ...

i have problem code, , have searched hours fix, no luck. tried many things myself, no luck. here's problem: i have js function creates new 'window', including div's, dynamically created. have ajax request in function, gets data php file, , supposed put data in corresponding div same function creates. error: uncaught typeerror: cannot set property 'innerhtml' of undefined my code: var prowindow = function(height,width,title,type,id){ this.max = false; this.name = title; this.mmain = document.createelement("div"); this.mmain.classname = "main"; this.appid = id; this.id = this.name + id; $.ajax({ url: 'includes/getappcontents.php', type: 'get', data: {thisappid: this.appid}, }) .done(function(result) { var result = $.parsejson(result); var code = (result['code']); this.mmain.innerhtml = code; }) .fail(function() { //console.log("failed retrieving code application"); }) .a...

i have 3 arrays: a, b, c length 15. a=[950, 850, 750, 675, 600, 525, 460, 400, 350, 300, 250, 225, 200, 175, 150] b = [16, 12, 9, -35, -40, -40, -40, -45, -50, -55, -60, -65, -70, -75, -80] c=[32.0, 22.2, 12.399999999999999, 2.599999999999998, -7.200000000000003, -17.0, -26.800000000000004, -36.60000000000001, -46.400000000000006, -56.2, -66.0, -75.80000000000001, -85.60000000000001, -95.4, -105.20000000000002] i trying find value of @ index b=c. t the problem there no place b=c need linearly interpolate between values in array find value of b=c. make sense? i thinking using scipy.interpolate interpolation. i having hard time wrappying mind around how solve problem. ideas on great! here's simpler variation of function another answer of mine : from __future__ import division import numpy np def find_roots(t, y): """ given input signal `y` samples @ times `t`, find times `y` 0. `t` , `y` must 1-d numpy arrays. lin...

this question has answer here: from program allocate memory? 5 answers object1 * test= new object1(); does "test" have absolute address on ram or absolute address in virtual memory has relative starting point ram's 0 adress? an example be, in fragmented memory started many applications each allocating , deallocating many times 10 hours, , 1 of applications ram error checking , benchmarking one. test ram addresses or runs on limited area? if reaches ram, how os able protect app other apps besides moving objects? when streaming non-pinned array pci-e , pci-e. most oses use virtual addressing, address seen program largely independent physical address of ram itself. some do, however, have special functions available allocate physical memory has fixed physical address. example, on windows can use allocateuserphysicalpages allocate physical pa...

i have dropdown list months. how can show last month default? example: month september, i'd set default month august. my view: the dropdown list <% @date = date.today @months = [] (0..11).each |m| @months << [@date.next_month(m).strftime("%b"), @date.next_month(m)] end %> <div class="col-md-8"> <%= f.select :datepay, options_for_select(@months), { :required => true, :onchange => "alert()" } %> </div> currently, @months array not contain previous month. so, include previous month in collection follows: @date = date.today @months = [] (-1..11).each |m| #mark here starting range -1 i.e august, 2016 @months << [@date.next_month(m).strftime("%b"),@date.next_month(m)] end like have used next_month next month, prev_month can used previous month. <%= f.select :datepay, options_for_select(@months, @date.prev_month), { :required => tr...

i have serialized json object follows: { "sender": "service", "type": "spiglassauditedorder", "data": "{\"header\":{\"id\":\"asdfdsa-8687689-asdfd\",\"eventtype\":\"order\"}" } in "data" path, want deserialize path. however, can't past one, of additional "\" , second, additional set of quotation marks before data -> header path. i used following sql statement has json_table function: with tmp ( select jt1.* schema.table t, json_table(t.payload, '$' columns sender path '$.sender', type path '$.type', data path '$.data') jt1 t.queue_config_fk = 37 ) select * tmp; but data returns null: what prefer return actual deserialized json object. any appreciated. json_table creates virtual table json. try use json_query select 1 or more values.

i following tutorial, uses mean stack. got point i'm supposed start using node. installed , i've put angular , bootstrap scripts in respective folder. problem none of these files found when try run application in localhost:3000. the errors i'm getting: the directory structure of project: this code i've got far : index.ejs <!doctype html> <html ng-app = "flappernews"> <link rel="stylesheet" type="text/css" href="../public/stylesheets/bootstrap.css"> <style> .glyphicon-thumbs-up { cursor : pointer; } </style> <head> <title></title> </head> <body> <div class = "row"> <div class = "col-md-6 col-md-offset-3"> <ui-view></ui-view> </div> </div> <script type="text/ng-template" id = "/home.html"> <div class = "row"...

i wonder if give few pointers on how proceed following. being newbie pandas, feel @ moment overall knowledge , skill level not sufficient @ moment able process request outline below. i have pandas dataframe has list of 2000+ part numbers. each part there years of sale parts, month number, quantity sold , sales value. each year, there occasional missing months. in example data shown below year 2007,month 11 missing there no sales during month. 2008, months 11 & 12 missing. insert missing months each year , insert row containing appropriate year, month , 0 value qty , sales within each part_id group. in total data approx. 60200, rows approx. 2000 part id's. not mind spending time on developing solution few pointers aid education. index part_id year month qty sales 60182 zzssl 2007 5 11.0 724.85 60183 zzssl 2007 6 7.0 537.94 60184 ...

i learning express , template using jade.i have written simple code getting below error.please let me know what's issue. error: 500 syntaxerror: unexpected token (41:5) at parser.pp$4.raise (h:\nodejs-lynda\chap-5\06\start\node_modules\jade\node_modules\with\node_modules\acorn\dist\acorn.js:2422:15) @ parser.pp.unexpected (h:\nodejs-lynda\chap-5\06\start\node_modules\jade\node_modules\with\node_modules\acorn\dist\acorn.js:613:10) @ parser.pp.semicolon (h:\nodejs-lynda\chap-5\06\start\node_modules\jade\node_modules\with\node_modules\acorn\dist\acorn.js:590:61) @ parser.pp$1.parseexpressionstatement (h:\nodejs-lynda\chap-5\06\start\node_modules\jade\node_modules\with\node_modules\acorn\dist\acorn.js:1002:10) @ parser.pp$1.parsestatement (h:\nodejs-lynda\chap-5\06\start\node_modules\jade\node_modules\with\node_modules\acorn\dist\acorn.js:767:22) @ parser.pp$1.parsetoplevel (h:\nodejs-lynda\chap-5\06\start\node_modules\jade\node_modules\with\node_modules\acorn\dist\acorn.js:6...

i using titan framework custom plugin wrote. there settings page has tab , on there text field: array( 'name' => 'slug', 'id' => 'my_slug', 'type' => 'text', 'default' => 'my-slug', 'desc' => 'the slug.', ), this text field allows user specify slug plugin's frontend ui. problem user can clear field out nothing , save settings results in error. i understand can trap condition in php code when setting option used. understand done using jquery enforce value being specified, seem there should best practice solution. can tell me proper way ensure field has value? the user can save empty , yes can prevent js. because there no "pre save" filter, 1 way address to method mentioned, add placeholder attribute field give illusion of value when empty (this better user experience). array( 'name' => 'slug', ...

the problem of windows uwp code: var devices = await deviceinformation.findallasync(gattdeviceservice.getdeviceselectorfromuuid(new guid("00001520-1212-efde-1523-785feabcd124"))); gattdeviceservice m_service = await gattdeviceservice.fromidasync(devices[0].id); is m_service null . ble device contains gatt service 00001520-1212-efde-1523-785feabcd124 uuid paired (the device visible in device manager no exlamation mark). how fix it? r. wang's can correct answer, hard , maybe impossible change package.appxmanifest correctly hand. in visual studio in solution explorer right-click on package.appxmanifest , select open. click capabilities , thick bluetooth , save packagemanifest (ctr + s). if not solution problem, need more of relevant code help.

def my_method(self): print self.my_field * 2 i'd able add parameter in other case can use different expression instead of self.my_field , maybe self.my_other_field or self.my_field + 1 . select self.my_field , refactor > extract > parameter. error saying "cannot perform refactoring using selected element(s)". it should able refactor, because my_method called self.my_method() or other_obj.my_method() . can change these self.my_method(self.my_field) or other_obj.my_method(other_obj.my_field) . in general i've been able extract parameter functionality work when expression simple, constant. if expression depending on value of existing parameter, doesn't work. guess self special case of existing parameter. limitation of extract parameter, or doing wrong? it seems trying refactor through renaming opposed extracting new parameter . you note intended function of parameter extraction modify existing calls include new parameter. however, ...

this website has loads of list items. code, when resize browser, other elements scale navigation bar , list items not , looks odd. here css: .top-nav{ display:inline-block; } .top-nav ul li{ display:inline-block; } .top-nav ul li a{ font-family: 'karla', sans-serif; color: #f8abbe; text-transform: uppercase; padding: 45px 25px; display: inline-block; font-weight: normal; transition: 0.5s ease; -o-transition: 0.5s ease; -webkit-transition: 0.5s ease; } .top-nav li.active> a, .top-nav li> a:hover { background: #f8abbe; color:#fff; } and here html: <div class="header"> <div class="wrap"> <div class="top-nav"> <ul> <li class="active"><a href="index.html">home</a></li> <li><a href="about.html">about</a></li> <li><a href="services.html...

i'm parsing string looks this: int num 1, num2, num3; //do other stuff in betwee lines, there \r\n. i'm looking replace \r\n \n, , got working fine, howerver, i'd multiple copies of /r/n in row. in other words: /r/n <-- found /r/n/r/n <-- found also /r/r/n/n/n <-- not found here current statement: mydata.replace (/(/r|/n)*/g, "somestuff"); do know way of how make * character apply multiple characters, repetitions of "/r/n"* rather (/r|/n)* finds either /r or /n number of times. this: (\r\n)+ the plus matches 1 or more times. or this: /(\r\n)/g the g matches occurrences of string depends on need or actual code, if can post it.

i'm piping curl output jq: https://stedolan.github.io/jq/ , works great until try use select filter. this filter works fine when in online tool: https://jqplay.org/ , in command line experiments after having downloaded file. this issue occurs when try directly pipe curl output jq. this fails: i71178@slcits-l2222:~/next-gen/mongodb$ curl 'http://fhirtest.uhn.ca/basedstu3/patient?_format=json&_count=50&_pretty=false&_summary=data' | jq-linux64 --unbuffered -r -c '.link[] | select(.relation == next) | .url' | head -3 jq: error: next/0 not defined @ <top-level>, line 1: .link[] | select(.relation == next) | .url jq: 1 compile error % total % received % xferd average speed time time time current dload upload total spent left speed 100 2421 0 2421 0 0 2413 0 --:--:-- 0:00:01 --:--:-- 2413 curl: (23) failed writing body (1675 != 2736)...

i've downloaded kafka connect http://docs.confluent.io/2.0.0/quickstart.html#quickstart i'm trying run hdfs connector. here settings: connect-standalone.properties: bootstrap.servers=lvpi00658.s:9092,lvpi00659.s:9092,lvpi00660.s:9092 key.converter=org.apache.kafka.connect.storage.stringconverter value.converter=org.apache.kafka.connect.storage.stringconverter internal.key.converter=org.apache.kafka.connect.storage.stringconverter internal.value.converter=org.apache.kafka.connect.storage.stringconverter offset.storage.file.filename=/tmp/connect.offsets # flush faster normal, useful testing/debugging offset.flush.interval.ms=10000 key.deserializer=org.apache.kafka.common.serialization.stringdeserializer value.deserializer=org.apache.kafka.common.serialization.stringdeserializer and quickstart-hdfs.properties: name=hdfs-sink connector.class=io.confluent.connect.hdfs.hdfssinkconnector tasks.max=1 topics=eightball-stuff11 hdfs.url=hdfs://localhost:9000 flush....

i'm trying use getorgchart library in page, browser keeps insisting not function: here's code: <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script> <script src="getorgchart.js"></script> <link rel="stylesheet" src="getorgchart.css"> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <link rel="stylesheet" href="https://code.jquery.com/ui/1.12.0/themes/base/jquery-ui.css"> <script> $("#orgstaffing").getorgchart({ theme: 'vivian', primarycolumns: ['name','division','project','email'], imagecolumn: 'image', gridview: true, add quote before second email 'jdoe@company.com...

i hoping may able assist me nodejs. iv started developing site using nodejs. the problem: im looking way send documents a header, content, footer style reduces repeating code each section. i have public folder setup can include js, css , common files etc... self.app.use(express.static(__dirname + '/public')); this works, im unsure how implement simple way join file content. every source iv looked @ online suggests "correct" way via package called ejs templates. so im looking similar implementation in ejs: <header> <% include ../partials/header %> </header> <footer> <% include ../partials/footer %> </footer> however, service im hosting on not support ejs, possible this? self.routes['/'] = function(req, res) { res.setheader('content-type', 'text/html'); res.send(self.cache_get('header.html')+self.cache_get('index.html')+self.cache_get(...

i'm following android developer's guide camera api (using v1 right now). can't find way overlap view (in case imagebutton/imageview on top of preview). i'm using framelayout. here's layout code. <?xml version="1.0" encoding="utf-8"?> <relativelayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" tools:context="com.blackfruit.camfilters.cameraactivity" android:orientation="vertical" > <framelayout android:layout_width="match_parent" android:layout_height="match_parent" android:id="@+id/camerapreview" android:layout_weight="1"> <imageview android:layout_width="wrap_content" android:layout_height="wrap_content" a...

i have .mdb database , i'm trying design report using jaspersoft studio 6.3.0 (eclipse plug-in). in java application have used ucanaccess jdbc driver build connection jdbc-odbc bridge no longer supported in java 8. when creating data adapter, chose "database jdbc connection", , then, ucanaccess not in default list of drivers, added .jar file ucanaccess driver. screenshot classpath: then, wrote driver class in jdbc driver (note: standard action choose 1 of drivers in combobox, had add manually, read somewhere in internet must write myself). screenshot driver setting: when test connection, stay loading forever , never end. note: database has no user/pass. connected database java application (using ucanaccess driver); problem connection report. what can do? suggestions? thanks! i managed solve question myself. had add 4 .jar in ucanaccess-x.x.x-bin>>lib classpath (commons-lang, commons-logging, hsqldb, jackcess)

i have mssql database id in form of hex values. for example, when viewed in management studio, typical id column looks like id, | username 0x8189cf203dea4a44b8adeff1c8246866, | john 0xaf4845c8a34a48ef8b6d481f2d20d561, | peter 0x70b1f5e3b3f8417bbb99912640c54520, | alan to query user table, need write like select * users id = 0x8189cf203dea4a44b8adeff1c8246866 i use lot of sequelize.query run bunch of sql statements directly. when such table read in sequelize, id gets converted buffer type in sequelize. question is, how can keep hex value? there config keep string hex value of these ids? did have convert these buffer type manually hex string hand, , attach 0x in front? for example, when viewed in management studio, typical id column looks like for me, typical id not this, i'm quite sure, hex-values uniqueidentifier s (=guid) (see option 2). option 1: hex-string you might store hex string string representation: ...

i missing fundamental have following html <div class="test-cont"> <div class="md-margin"></div> <div class="row"> <div class="col-md-12">test2</div> </div> <div class="md-margin"></div> <div class="row"> <div class="col-md-12">hello world</div> </div> <div class="md-margin"></div> <div class="row"> <div class="col-md-12">test2</div> </div> <div class="md-margin"></div> <div class="row"> <div class="col-md-12">hello world</div> </div> </div> and using following selectors .test-cont .row:nth-of-type(odd) { background: purple; } .test-cont .row:nth-of-type(even) { background: red; } which believe expres...

i'm using margins on individual labels align them centred , directly below buttons. hacky , inconsistent on different screen sizes. <div id="langbuttons"> <input class="btn-group langbutton" id="usejavascript" value="javascript" type="button"></input> <input class="btn-group langbutton" id="useruby" value="ruby" type="button"></input> <input class="btn-group langbutton" id="usepython" value="python" type="button"></input> <input class="btn-group langbutton" id="usehtml" value="html" type="button"></input> <input class="btn-group langbutton" id="usecss" value="css" type="button"></input> <input class="btn-group langbutton" id="useswift" value="swift" type=...

in script builds blob of text, there point block of "summary" text can prepended said blob. although script generates summary text once, gets prepended text blob multiple times. this powershell script: # # test_textappend.ps1 # $reportmessage = "body of report able ere saw elba"; # build "report" text $fruitlist = [system.collections.arraylist]@(); $vegetablelist = [system.collections.arraylist]@(); [void]$fruitlist.add("apple"); # generate "summary" includes contents of both lists function generatesummary() { [system.text.stringbuilder]$sumtext = new-object ("system.text.stringbuilder") $namearray = $null; [string]$namelist = $null; if ($fruitlist.count -gt 0) { $namearray = $fruitlist.toarray([system.string]); $namelist = [string]::join(", ", $namearray); $sumtext.appendformat("the following fruits found: {0}`n", $namelist); } ...

i using ensembles framework sync data icloud. working fine until migrated swift 3. the framework in objective-c , appdelegate functions have migrated swift 3; have had issues since. call appdelegate.syncwithcompletion throughout app when saving changes nsmanagedobjects . here's appdelegate functions // mark: ensembles var cloudfilesystem: cdecloudfilesystem! var ensemble: cdepersistentstoreensemble! func syncwithcompletion(completion:@escaping (_ completed:bool) -> void) { if !ensemble.isleeched { ensemble.leechpersistentstore { error in if error != nil { print("cannot leech \(error!.localizeddescription)") completion(false) } else { print("leached!!") completion(true) } } } else { ensemble.merge{ error in if error != nil { print("cannot merge \(error!.localizeddesc...

i building frontend symfony app project current folder structure: +---app | +---conf | +---lib | | +---ca | | | +---search +---frontend | +---app | +---bin | +---src | | \---publicbundle | | +---controller the app folder on root (non symfony app) located. php app. inside frontend folder symfony project being built. i trying load inside symfony app (from public controller) class other php app (a class inside ca subfolder) when try to, symfony returns namespace exception tip: did forget "use" statement namespace? it correct load class outside symfony project is, , if how done? thanks in advance,