Posts

sql server - GeneralDetailReportQuery key field -

we use generaldetailreportquery customer "transactions" quickbooks desktop , save them mssql table. query called passing from/to date filter params changes only. try report changes each day , keep our table in sync qb data. tranid, customer listid , trantype seem fields can uniquely identify each record returned report query. problem starts happen when users change 1 of key fields, customer listid example. must have been change of customer in transaction... ? anyway, how keep data in sync, report have kind of primary key field, not changed , can use track changes ? thanks, slava

mysql - SQL: Stacking columns by bucketed metrics -

so i'm using sql charting tool, , can't buckets of metrics reflect proportions of total in y-axis (as stacked columns) metrics in x-axis. example: metrics (x-axis values) should "job count", "visits", "apps", , "spend". each 1 should have stacked column based on following bucket of visits metrics: 1-2 visits, 3-4 visits, 5-7 visits, 8-10 visits, 11-15 visits, 16-25 visits, , 25+ visits. my query follows: select alias.grp bucket , count(alias.jobid) number_of_jobs_by_bucket , sum(alias.total_visits) visits_by_bucket , sum(alias.spend) spend_by_bucket , sum(alias.total_applications) apps_by_bucket ( select analytics.jobid , case when sum(analytics.visits) >= 1 , sum(analytics.visits) <= 2 'a: 1-2 visits' when sum(analytics.visits) > 2 , sum(analytics.visits) <= 4 'b: 3-4 visits' when sum(analytics.visits) > 4 ...

opencv - can I create a slider in console c++ and how -

i using stereosgbm match correspondences create disparity map can create slider on window change parameters of algorithm? , note using c++ console application. if yes, how ? no, cannot. console window not made mouse input. chop little ascii art looks vaguely slider , reacts keyboard input, other that, need gui toolkit.

scope - Should variable bound in SELECT clause be accessible in ORDER BY? -

should valid sparql? select ("text" ?astring) {} order ?astring i have tried 2 different engines. 1 returns "text" ?astring, other errors, saying ?astring not defined in order by. sparql spec cover case? or implementation detail, happens work in engines, not strictly portable? sparql.org's query validator says it's legal. pretty important case, since want able things like: select ?min ?max ((?max - ?min) ?range) { #-- ... } order ?range

css - Google Maps with height=100% and margin top -

i'm coding wordpress plugin should display fullscreen google map. if logged in in wordpress, toolbar displayed @ top using margin-top. google maps apparently needs div height=100% display fullscreen map, if logged in , admin toolbar of wordpress displayed, have unnecessary scrollbars. absolute positioning not possible because of floating sidebar , mobile support. all solutions "100% margin" problems either use absolute positioning or "min-height", not working google maps. has solution me? if want full height of viewport 100vh . so remove size of bar. height: calc(100vh - 100px)

javascript - Swagger: first enum value overwrites type -

i using swagger doc generate api app. doc written in yml , in place going define props enum (we use mysql). looks like: properties: type: enum: - "first" - "second" - "example" type: "string" title: type: "string" ... // , on , on i expecting this: { "type": "string", "title": "string", } as can see, type field going string defined in config file, receiving 1 instead: { "type": "first", "title": "string", } swagger sets first value data type , absolutely incorrect. question how value "string" "type" field. i have been writing swagger documentation in json. below example of how have "enums" set up. maybe can translate yml better idea. "parameters":[ { "name":"userid", ...

Not able to format in jekyll -

can me code block (by prettify plugin) , headline seperated? googled lot didn't find solution. have written blog in jekyll , used prettify plugin highlight code. below configuration there in config.yml file markdown: kramdown highlighter: pygments redcarpet: extensions: ["no_intra_emphasis", "fenced_code_blocks", "autolink", "tables", "with_toc_data"] kramdown: input: gfm use_coderay: true auto_ids: true footnote_nr: 1 entity_output: as_char toc_levels: 1..6 smart_quotes: lsquo,rsquo,ldquo,rdquo enable_coderay: false i not able post image please check below url .md file snippet http://i.stack.imgur.com/yhrow.png i expect headlines out of code block below output of blog http://i.stack.imgur.com/beqve.png if want highlight code in jekyll, useless try 2 years old plugin. just use hightlight tag : {% highlight java %} import java.toto; public cla...