Posts

Showing posts from August, 2010

codeigniter - Form dropdown is giving me index and not the text -

can out new learner of codeigniter? reason form dropdown giving me index input->post. need text selected. model function get_items(){ $this->db->select('item_name'); $this->db->from('commissary_items'); $query=$this->db->get(); $result=$query->result(); $item_names=array('-select-'); for($i=0;$i<count($result);$i++){ array_push($item_names,$result[$i]->item_name); } return $item_names; } view <div class="form-group"> <div class="row colbox"> <div class="col-lg-4 col-sm-4"> <label for="item_name" class="control-label">item</label> </div> <div class="col-lg-8 col-sm-8"> <?php $attributes = ...

r - How to apply big data on this p-value corrgram? -

Image
i studying didzis' p-value corrgram different input data examples, insignificant p-value (p < 0.05) corresponds perfect curve fit, strange, see fig 1-3. fig. 1 output of "extreme" input data #1, fig. 2 output minimum input data #2, fig. 3 output didzis' input data #3, statistical inspection. fig. 1 p-values high when r small, fig. 2 p-values high confidence intervals wide, not sure if drawing graph there appropriate, fig. 3 low p-values when curve fitting perfect - observation can confusing input data test cases real live data example #1 "extreme" example , application output in fig. 1 ## 1 make list of lists set.seed(24) a=541650 m1 <- matrix(1:a, ncol=4, nrow=a) str(m1) a=360; b=1505; c=4; m2 <- array(`length<-`(m1, a*b*c), dim = c(a,b,c)) res <- lapply(seq(dim(m2)[3]), function(i) cor(m2[,,i])) str(res) res <- lapply(res, function(x) eigen(replace(x, is.na(x), 0))$vectors[,1:1]) str(res) minimum exampl...

javascript - Is using compose to add routes and middleware to an Express app an anti-pattern? -

i working on small server used boilerplate future servers. since order can matter middleware, reached compose pipe them in obvious order. goal add 1 level of abstraction middleware , routes can swapped out later without many changes entry point. given info, seem anti-pattern use compose since middleware/routes impure , modify (app) gets passed in? 'use strict'; import { createserver } 'http'; import express 'express'; import { flowright compose } 'lodash'; import { system, environment } './config'; import routes './routes'; const setup = compose(routes, system); const app = setup(express()); createserver(app) .listen(environment.port, environment.ip, () => { console.log('server running!'); });

eclipse - Sending integer output to another activity -

suppose, have added 2 integers in activity. want arithmetical operations , want show output in activity clicking button. should do? n.b. : want take values in numbers(decimal) can take values dynamically , added button also. you can add key bundle object , send bundle intent. code while sending intent. intent intent = new intent(context, sendmessage.class); intent.putextra("result", 10); intent.startactivity(); code while receiving intent bundle extras = getintent().getextras(); string receivedvalue; if (extras != null) { receivedvalue= extras.getstring("result"); }

mysql - Will a binary operator used in group by prevent the use of an index for optimization? -

i.e. there index invoke_statistics.method select max(`t0`.`method`) `d0`, sum(`t0`.`success`) `m0` `invoke_statistics` `t0` group binary `t0`.`method` limit 20000 will binary operator used in group by sentence prevent use of index optimization? if yes, then, recommended way group by string field via strict string comparation instead of using binary , considering have no permission change table definition? this bit long comment. i don't understand query. why not write: select binary t0.method d0, sum(t0.success) m0 invoke_statistics t0 group binary t0.method; the initial max() shouldn't doing (how can 2 values in column the same in binary representation different in representation?). then, answer question, mysql take collation account when creating indexes -- has to, because collations define ordering. because binary changes collation, expect preclude index usage. not 100% certainty; expectation.

math - Catch if variable overflow in delphi -

Image
i'm working on program shows narcissistic numbers 0 max. max value typed user. got code trying improve it. due have few questions. i need check every digit of number , make them n-th power. decided create tab[0..9] contains indexoftab n-th power , when sum digits number works that: sum := sum + tab[x]; //where x digit checked now wondering if comparing faster this: sum:= sum + power(x,n); i want catch if sum overflow. , know how if .. then . wondering if there way not checking on every operation if sum change sign, program catch variable overflowed , code. edit: while (tmpnum>0) //tmpnum - digit of currenlty checked number(curnum) begin try suma:= suma+tab[tmpnum mod 10]; //suma =0 //tab[x] = x^(curnum.length); except suma:= 0; tmpnum:=0; //here more end; tmpnum:= tmpnum div 10; //divide number next modulo end; first of method of using table of values far fastest method use. far overflow concerned, come...

r - Using purrr::map for recursive function call -

i have list within data frame on want use purrr::map() test whether there null elements , rid of them. while able using sapply, map doesn't work. read https://cran.r-project.org/web/packages/purrr/purrr.pdf , can't figure out what's missing. here's sapply code --this works well: p_trans<- p_trans[!sapply(p_trans$group,is.null),] here's few things tried purrr::map , don't work. here 4 things tried: a) p_trans %>% purrr::map(.,~is.null(group)) b) p_trans %>% purrr::map(.,~is.null(.$group)) c) p_trans %>% purrr::map(~is.null(.$group)) d) p_trans %>% purrr::map(~is.null(group)) can please correct mistake, , let me know doing wrong above 4 options? data: dput(p_trans) structure(list(transactionid = c("a1", "a1", "a1", "a2", "a2", "a2", "a3", "a3", "a3", "a3", "a4", "a5", "a5", ...

linux - RPC to get Windows event logs using Python -

i'm absolute newbie might explain why i'm having trouble, haven't been able find information on using python make rpc calls microsoft windows systems can event log information. i'm on verge of giving up. maybe it's because don't understand of rpc. thought googling me required information, it's been week , i've made absolutely no progress. here please point me in right direction? lot.

javascript - massive-js limit columns from result -

the following code returns id, title , content fields. need id , title. db.laws.search({columns: ["title", "content"], term: req.params.text}, function(err,laws){ res.contenttype('application/json'); res.send(json.stringify(laws)); }); i need , equivalent of "select id, title laws where...". can not find in docs . i avoid loop filter out unwanted columns, less efficient. as can see in massive.js code, have not option remove id result row in search method. advice use inline sql

select - SQL WHERE ID IN (id1, id2, ..., idn) -

i need write query retrieve big list of ids. we support many backends (mysql, firebird, sqlserver, oracle, postgresql ...) need write standard sql. the size of id set big, query generated programmatically. so, best approach? 1) writing query using in select * table id in (id1, id2, ..., idn) my question here is. happens if n big? also, performance? 2) writing query using or select * table id = id1 or id = id2 or ... or id = idn i think approach not have n limit, performance if n big? 3) writing programmatic solution: foreach (id in myidlist) { item = getitembyquery("select * table id = " + id); myobjectlist.add(item); } we experienced problems approach when database server queried on network. better 1 query retrieve results, better lot of small queries. maybe i'm wrong. what correct solution problem? option 1 solution. why? option 2 same repeat column name lots of times; additionally sql engine doesn't know w...

javascript - Aurelia app "Hello World" not working at all -

Image
i creating sharepoint framework webpart, , trying use aurelia javascript framework. basically created sharepoint framework webpart, when created yeoman, creates folder structure . then files (just simple hello world): app.html <template> ${message} </template> app.js export class app { message = 'hello world'; } main.ts import {aurelia} 'aurelia-framework'; export function configure(aurelia) { aurelia.use .standardconfiguration() .developmentlogging(); aurelia.start().then(a => a.setroot()); } index.html <div aurelia-app> <h1>loading...</h1> <h2> ftw </h2> <script src="jspm_packages/system.js"></script> <script src="config.js"></script> <script> system.import('aurelia-bootstrapper'); </script> </div> and helloworld webpart: import { baseclientsidewebpart, ipropertypanesettin...

How to implement Google Sign In with Firebase and Custom Button in Swift? -

i'm having lot of trouble presenting sign in screen google sign in. keep getting variation on application tried present modally active controller here appdel code: @available(ios 9.0, *) func application(application: uiapplication,openurl url: nsurl, options: [string: anyobject]) -> bool { if twitter.sharedinstance().application(application, openurl:url, options: options) { return true } if (fbsdkapplicationdelegate.sharedinstance() != nil) { return fbsdkapplicationdelegate.sharedinstance().application(application, openurl: url, sourceapplication: options[uiapplicationopenurloptionssourceapplicationkey] as! string, annotation: options [uiapplicationopenurloptionsannotationkey]) } if (gidsignin.sharedinstance() != nil){ return gidsignin.sharedinstance().handleurl(url, sourceapplication: options[uiapplicationopenurloptionssourceapplicationkey] as? string, ...

tensorflow - ImportError: cannot import name learn -

i followed below url creating docker , install tensorflow on vm. http://www.netinstructions.com/how-to-install-and-run-tensorflow-on-a-windows-pc/ everything gone fine. when tried run below code, see error message below import tensorflow tf tensorflow.contrib import learn importerror traceback (most recent call last) <ipython-input-9-e8c8ddf46f14> in <module>() 1 import tensorflow tf ----> 2 tensorflow.contrib import learn importerror: cannot import name learn please let me know how solve issue. you should not import manually. once have done import tensorflow tf , can use tf.contrib.learn . please follow examples .

java - why does it not follow the if statement -

package com.example.firstapplication; import android.content.intent; import android.support.v7.app.appcompatactivity; import android.os.bundle; import android.view.viewgroup; import android.widget.textview; import static com.example.firstapplication.mainactivity.extra_message; public class displaymessageactivity extends appcompatactivity { @override protected void oncreate (bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.activity_display_message); intent intent = getintent(); string message = intent.getstringextra(mainactivity.extra_message); if (extra_message.equals ("h")) { textview textview = new textview(this); textview.settextsize(40); textview.settext(message); viewgroup layout = (viewgroup) findviewbyid(r.id.activity_display_message); layout.addview(textview); }else { textview textview = ne...

performance testing - Why is this lisp benchmark (in sbcl) so slow? -

since i’m interested in c++ in lisp, tried reproduce benchmark presented here written guillaume michel. benchmark daxpy blas level 1 operation performed multiple times on big arrays. full code thankfully posted on github , in both languages 1 page. sadly, discovered not possible me reach velocity of calculations lisp. for linux, got similar results c++ lisp: size | c++ | common lisp 100,000,000 | 181.73 | 183.9 the numbers differ (naturally) both on pc: size | c++ | common lisp 100,000,000 | 195.41 | 3544.3 since wanted additional measurement, started both programs time command , got (shortened up): $ time ./saxpy real 0m7.381s $ time ./saxpy_lisp real 0m40.661s i assumed different reasons blatant difference. scanned through both code samples, found no big algorithmic or numeric difference between c++ , lisp version. thought, usage of buildapp created delay, started benchmark directly in repl. last resort try version of sbcl , downloade...

ruby on rails - Chaining ActiveRecord::QueryMethods#select returns additional records -

i'm having strange situation calling article.comments doesn't bring records should, if add `select, comes up. i'm seeing things this: article.comments #=> [] article.comments.select(:id) #=> [#<comment:0x12341234 id: 1>] took @ sql , there's no difference, it's selecting comments.* vs comments.id . responsible this?

How to install ng2-prism with angular-cli -

when try install ng2-prism this: ng install ng2-prism i error: the package rxjs@5.0.0-beta.12 not satisfy siblings' peerdependencies requirements! error: package rxjs@5.0.0-beta.12 not satisfy siblings' peerdependencies requirements! @ /home/codesave-dash/node_modules/npm/lib/install.js:125:32 @ /home/codesave-dash/node_modules/npm/lib/install.js:268:7 @ /home/codesave-dash/node_modules/npm/node_modules/read-installed/read-installed.js:142:5 @ /home/codesave-dash/node_modules/npm/node_modules/read-installed/read-installed.js:263:14 @ cb (/home/codesave-dash/node_modules/npm/node_modules/slide/lib/async-map.js:47:24) @ /home/codesave-dash/node_modules/npm/node_modules/read-installed/read-installed.js:263:14 @ cb (/home/codesave-dash/node_modules/npm/node_modules/slide/lib/async-map.js:47:24) @ /home/codesave-dash/node_modules/npm/node_modules/read-installed/read-installed.js:263:14 @ cb (/home/codesave-dash/...

android - Rendering Error when adding design library -

i have installed android studio on pc (windows 10 home 64-bit). want use floating action button android app , requires design library. when add library program, error: rendering error . app layout disapears. can me this? thanks, guilherme

Revoke access to Firebase iOS app -

i'm new firebase. have ios app outsourced separate developer constraints. once part of project completed deleted ios app in firebase project , created new 1 different build id create different app id. figured prevent app using googleservice-info.plist file old app id access project. old app id in googleservice-info.plist still connects. @ first thought using cached credentials reset firebase after 24 hours or so, did 2 days ago. how revoke access app has old googleservice-info.plist file. can down without deleting project itself. appreciated! :) just clarification i'm not referring revoking individual users within project authentication module.

class - Function overloading in namespace in c++ -

i need in implementing below task. want have namespace's same named classes rhs inherited library class function, same named function rhsvalue inside rhs classes different implementation in each namespace. class function doesnt have function named rhsvalue in implementation. namespace s50{ // mother namesapce in want implement tasks class coeff: public function { // function class library public: virtual double value(); virtual void value_list(); }; } namespace charge{ class rhs: public funtion { virtual double rhsvalue (); // function class not have function named rhsvalue() }; } namespace s16{ class rhs: public function { virtual double rhsvalue(); // same named function in other namespace other implementation }; } it seems you've got want... mean described. some comments: 1) don't need rhsvalue defined in function class, if it's not cannot call rhsvalue funciton using pointer function, eg. function* function = new charge::rhs...

javascript - Image doen't take whole the header size -

i want make slider , consists 3 images , i'm facing problem. i want put image top of head .. made navbar height :0 , put navbar above header .. you can see code , , image show need exactly $('.header').height($(window).height()); .my-navbar { height: 0; } <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script> <body> <div class="my-navbar"> <div class="my-container"> <div class="user"> <i class="fa fa-user-circle-o" aria-hidden="true"></i> <a href="#" class="upper">login</a> <span class="separator">|</span> <a href="#" class=...

logic - Frustrating logical error while iterating through containers in Java -

i'm trying make simple "pharmacy delivery" program in java, i'm stuck whole day on logical error , can't wrap around. i'm pretty sure it's simple, don't understand - appreciate if can solve this. all in all, have 3 classes - drug, supplier, , order. drug holds info drugs (name , price). supplier holds other info including map (drugs, quantity). order holds map ordered , vector (suppliers). the basic idea fill 2 containers of order class .txt file. syntax of single line goes like: - ordered_drugs_name ordered_drugs_quantity (put 2 in map of orders) .. , rest similar parameters initialize suppliers object , put in vector. now, after i've filled these 2 containers have method takes (or @ least think does) first drug orders map , iterates on suppliers vector find if there suppliers have such quantity of drug. of course, when starts iterate suppliers must check if current supplier has drug, starts iterating supplier's map of drugs has....

android - How to fix Adapter when listview is scroll -

i want position testview left , right if user sender, position left else postion right work fine when scroll or down position every thing right here code string myisme="1"; private int self = 100; public chatdisplayadapter(context c, arraylist<string> id, arraylist<string> fname, arraylist<string> lname, arraylist<string> time, arraylist<string> senderid, arraylist<string> sendtoid, arraylist<string> sticker,arraylist<string> pic) { this.mcontext = c; this.id = id; this.firstname = fname; this.lastname = lname; this.chattime = time; this.chatsenderid = senderid; this.chatsendtoid = sendtoid; this.chatsticker = sticker; this.chatpic_pic = pic; } public int getcount() { // todo auto-generated method stub return id.size(); } public object getitem(int position) { // todo auto-generated method stub return null; } public long getitemid(int position) { chatsenderid....

Android intercept/disable recent apps button -

i trying create kiosk type app when press recent apps button dont want user able go different app. have been googling around cannot find on matter. there solution in thread recent apps button in android however not seem work me on android 6.0 can please point me right direction on how this? in link provided can find answer: is possible override recent apps button in android? not ordinary sdk app. you welcome build own custom rom modifies overview screen, convince people install custom rom on devices. so answer no in app written google provided sdks.

sql server - Cannot find the object 'TABLE" because it does not exist or you do not have permissions -

i running issue want add column table utilizes derived tables. want able populate column using while loop. however, when add column table following error: cannot find object "test" because not exist or not have permissions. have permissions not understanding why being prompted error when script executes without error without " alter table test add themevalue int(50)" line item added. the following code: declare @weekspriortoconversion int declare @periodenddate varchar(50) set @weekspriortoconversion = 5 set @periodenddate = '2016-10-26' select test.[casino] (select c.casino 'casino', tml.id 'id', tml.[themes or game titles] 'theme', count(distinct sm.[serial number]) 'title count', sum(smd.[standardizedcasinoholdv2]) / sum(case ...

Is it possible to achieve dynamic scoping in JavaScript without resorting to eval? -

javascript has lexical scoping means non-local variables accessed within function resolved variables present in parents' scope of function when defined. in contrast dynamic scoping in non-local variables accessed within function resolved variables present in calling scope of function when called. x=1 function g () { echo $x ; x=2 ; } function f () { local x=3 ; g ; } f # print 1, or 3? echo $x # print 1, or 2? the above program prints 1 , 2 in lexically scoped language, , prints 3 , 1 in dynamically scoped language. since javascript lexically scoped print 1 , 2 demonstrated below: var print = x => console.log(x); var x = 1; function g() { print(x); x = 2; } function f() { var x = 3; g(); } f(); // prints 1 print(x); // prints 2 although javascript doesn't support dynamic scoping can implement using eval follows: var print = x => console.log(x); var x = 1; function g() { print(x); ...

java - Reading in sets of 64 characters from a file -

so i'm trying read in string file. however, want each string contain 64 characters or less if last string doesn't have 64 in it. have counter, when counter reaches 64, set array of characters string, go next row , reset count zero. i'm not getting output of kind when run it. appreciated. here snippet of code public static void main(string[] args) throws ioexception{ file input = null; if (1 < args.length) { input = new file(args[1]); } else { system.err.println("invalid arguments count:" + args.length); system.exit(0); } string key = args[0]; bufferedreader reader = null; int len; scanner scan = new scanner(system.in); system.out.println("how many lines in file?"); if(scan.hasnextint()){ len = scan.nextint(); } else{ system.out.println("please enter integer: "); scan.next(); len = scan.nextint(); } scan.close(); ...

java - Can I retrieve information from Google Maps' app while mine is running on background? -

i need build turn-by-turn navigation on app, since don't allow using google maps api (usage terms 10.4.c), thinking letting app running on background , google maps on top of it, running turn-by-turn navigation. need retrieve information it, when user reaches next step of navigation. are there ways this?

material ui - Select all checkbox redux form -

i want check/ uncheck checkboxes moment select check can't make work. i'm using material-ui components , redux-form. plan grab checkall field value using formvalueselector api , set checkbox , b value based of that. tried using value prop no luck still. import react 'react'; import { connect } 'react-redux'; import { field, reduxform, formvalueselector } 'redux-form'; import { checkbox } 'redux-form-material-ui'; let form = (props) => { return ( <form> <field name="checkall" id="checkall" label="check all" component={ checkbox } /> <field name="a" label="a" component={ checkbox } checked={ props.checkall } /> <field name="b" label="b" component={ checkbox } checked={ props.checkall } /> </form> ); }; form = reduxform({ form: 'form' })(addreturnmodal); // decorate connect read form values const ...

java - is removing user credentials from session in addition to invalidate() superfluous? -

i looking @ legacy code base (at least ten years old) featuring amounts jsp model 2 architecture (basically servlets , jsp pages). i noticing code following: session.removeattribute("loginbean"); session.invalidate(); is there benefit in removing user credentials session. shouldn't invalidate alone sufficient? invalidate documentation seems pretty clear on subject. is there benefit in removing user credentials session. shouldn't invalidate alone sufficient ? yes, there benefit , best practice remove sensitive information usercredentials object before invalidating httpsession security perspective explained below: when call invalidate () on httpsession object, j2ee container internally triggers httpsessionlistener sessiondestroyed(httpsessionevent se) method. so, if don't remove usercreadentials object session, can still able retrieve inside sessiondestroyed method. so, point is best practice remove sensitive information https...

gzip - nginx + gzip_static_module -

scenario: have 2 files "style.css" , "style.css.gz". enabled modules gzip_static , gzip. works properly, nginx serve compressed "style.css.gz". both files have same timestamp. have cronjob creates pre-compressed files of file * .css , runs every 2 hours. gzip on; gunzip on; gzip_vary on; gzip_static always; gzip_disable "msie6"; gzip_proxied any; gzip_comp_level 4; gzip_buffers 32 8k; gzip_http_version 1.1; gzip_min_length 256; gzip_types text/cache-manifest text/xml text/css text/plain ........... question: if edit "style.css" , change few css rules, possible serve edited "style.css" instead of "style.css.gz"? (based on timestamp or smthing that) or pre-compress new "style.css.gz" after finish editing "style.css"? possible operate using nginx? or best solution?...

javascript - Why cannot I send a post to my WebApi through AngularJS's POST? -

i've sent "mytest.html" onto iis , project made of webapi+angularjs, , cannot right request webapi……i don't know why? 【codes html】 <!doctype html> <html> <head> <meta charset="utf-8"> <script src="http://apps.bdimg.com/libs/angular.js/1.4.6/angular.min.js"></script> <script src="http://lib.sinaapp.com/js/jquery/1.9.1/jquery-1.9.1.min.js"></script> </head> <body> <div ng-app="a" ng-controller="test"> <form method='post' name='myform'> <table width="100%"> <tr> <td>name:</td> <td><input type='text' ng-model='user.name' name='myname' required/> <span style='color:red' ng-show='myform.myname.$...

Multiple Schema Configuration On Spring MVC + Hibernate + JPA -

i using 1 schema(called schemaadmin) in database transactions in app(s), every tables in 1 schema. then company restructuring database management , require every app have 1 scheme read/write , allows readonly/select main schema, current 1 i'm using(schemaadmin). so here data.xml file, <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:jpa="http://www.springframework.org/schema/data/jpa" xsi:schemalocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/s...

python - Logging Formatter record current function executing -

in python logging want record function executing/running. example; class foo: def bar(self): logging.info("i'm alive") # writes log: '[info]: foo::bar(), i'm alive' is possible configure logger this? ie, create formatter find out? logging.config.dictconfig({ 'version': 1, 'disable_existing_loggers': false, 'formatters': { 'standard': { 'format': '[%(levelname)s] %(function_name)s: %(message)s' }, }, ... }) you can adding information context record of logger. this, need define own contextfilter class , add instance of logger. notice in order class name, depend on convention of calling self instance of class, , not using arguments of other functions (it based on question how-to-retrieve-class-information-from-a-frame-object ). notice work-around not able determine class of internalfunc because not have self argument. see code below. ...

Google Sheets count how many cells contain a specific word / words? -

i'm trying @ cells in set of columns/cells count how many of them contain word wordhere (in example) i've tried using: =sum(countif(a1:a100, "wordhere")) however finds 0 cell contains other words/letters/numbers, if cell contains wordhere works perfectly. i've tried using several regeexxtract , regexmatch including actual word can see below: =sum(countif(a1:a100,regexextract(a1:a100, "wordhere"))) but again, finds 0 matches. what doing wrong? so not answering doing wrong, here can do: =sum(countif(a1:a100, "*wordhere*"))

mysql - Joining table to union of two tables? -

i have 2 tables: orders , oldorders . both structured same way. want union these 2 tables , join them table: users . had orders , users , trying shoehorn oldorders current code. select u.username, count(user) cnt orders o left join users u on u.userident = o.user shipped = 1 , total != 0 group user this finds number of nonzero total orders users have made in table orders , want in union of orders , oldorders . how can accomplish this? create table orders ( user int, shipped int, total decimal(4,2) ); insert orders values (5, 1, 28.21), (5, 1, 24.12), (5, 1, 19.99), (5, 1, 59.22); create table users ( username varchar(100), userident int ); insert users values ("bob", 5); output is: +----------+-----+ | username | cnt | +----------+-----+ | bob | 4 | +----------+-----+ after creating oldorders table: create table oldorders ( user int, shipped int, total decimal(4,...