Running

i'm getting error when using aggregate function. guys can me, explained situation below. in football/soccer game player gets red card after second yellow card. query qry1twiceyellow gives unique id of players have 2 yellow cards. query written down below , works fine. select player_id (select player_id, count(id) total yellowcards game_id=29 , homeoraway=1 group player_id) total=2; now want retrieve information last card: the unique id of last yellow card. minute offence happened. the player id . i wrote following query causes error (below query). select y.id, y.player_id, max(y.minute) lastyellow qry1twiceyellow q inner join yellowcards y on q.player_id = y.player_id y.game_id=29 , y.homeoraway=1 group y.player_id; your query not include specified expression 'id' part of aggregate function. i tried following solutions: by adding id group error disappears max(minute) aggregate function useless since id unique. leaving out unique id. inner joi...

mates have problem using other table data. please @ code: $sql = mysqli_query($con, "select * properties category '$property_for' , property_type '$property_type' , search_radius >= '$area' , price >= '$price_min' , price <= '$price_max' , bed_rooms '$beds' , bath_rooms '$baths' order date_added desc") or die(mysqli_error($con)); $productcount = mysqli_num_rows($sql); if ($productcount > 0) { while($row = mysqli_fetch_array($sql)) { $pid = $row["property_id"]; $agent_id = $row["agent_id"]; $property_name = $row["property_name"]; $category = $row["category"]; $location = $row["location"]; $propert...

i need resolve host name ip address in shell script. code must work @ least in cygwin , ubuntu , openwrt ( busybox ). can assumed each host have 1 ip address. example: input google.com output 216.58.209.46 edit: nslookup may seem solution, output quite unpredictable , difficult filter. here result command on computer ( cygwin ): >nslookup google.com unauthorized answer: serwer: unknown address: fdc9:d7b9:6c62::1 name: google.com addresses: 2a00:1450:401b:800::200e 216.58.209.78 if want available out-of-the-box on modern unix, use python: pylookup() { python -c 'import socket, sys; print socket.gethostbyname(sys.argv[1])' "$@" 2>/dev/null } address=$(pylookup google.com) with respect special-purpose tools, dig far easier work nslookup , , short mode emits literal answers -- in case, ip addresses. take first address, if more 1 found: # bash-specific idiom read -r address < <(dig +short google.com |...

having issue when getting page position using scrolltop(). getting position correctly causing underlying page scroll top (see below). have tried 2 ways: var page_position = $(document).scrolltop(); $('#main-body').prepend(data.image).css('margin-top', page_position + 'px'); and: $('#main-body').prepend(data.image).css('margin-top', $(document).scrolltop() + 'px'); what data.image is div along image (large screenshot) returned ajax call. div image positioning correctly mentioned above underlying page scrolling top. btw, using foundation , jquery came packaged it, tried using jquery-1.11.3.min.js same results. plain javascript, want: var page_position = window.pageyoffset || document.documentelement.scrolltop

i want use jtss on ubuntu 14.04 64bits, have hardware tpm in version 1.2. installed .deb said in section 4.3 http://trustedjava.sourceforge.net/index.php?item=jtss/readme started daemon : jtss (tcs running) but if want run tests in packages (run_tests_simple.sh or run_test.sh) have error : "error! no tsp-tcs binding initialized. both jtss wrapper , jtss tried. check tsp configuration file." and command 'jtt tpm_version', have same error : --------------------- iaik java tpm tools --------------------- 16:34:56:631 [error] tctcsbindingsoap::connect (116): there seems no tcs running 16:34:56:647 [error] tctcsbindingsoap::connect (116): there seems no tcs running iaik.tc.tss.api.exceptions.tsp.tctspexception: tss error: error layer: 0x3000 (tsp) error code (without layer): 0x0103 error code (full): 0x3103a error message: core service connection failed. @ iaik.tc.tss.impl.java.tsp.tcsbinding.soapservice.tctcsbindingsoap.connect...

i have tried access following url when typed browser message: "not found" when use in talend rest component error message: 401 error. https://www.googleapis.com/datastore/v1beta2/datasets/my-project/runquery?key=aizasyca_j4wyyen-3q0nzwncmcoqcrrw17ec1y an idea? all cloud datastore api methods expect post requests. that's why error when access url via browser. the 401 error because need provide credentials access cloud datastore api. can find more information client libraries on cloud datastore getting started page or google apis client libraries page .

i have crash can't reproduce , don't understand crashlog. managed symbolize crashlog should bit useful. error when building release (archiving , uploading hockeyapp). can point me in right direction? objective-c , ios knowledge bit lacking: exception type: exc_crash (sigabrt) exception codes: 0x0000000000000000, 0x0000000000000000 triggered thread: 0 ___exceptionpreprocess + 122 _objc_exception_throw + 34 +[nsexception raise:format:] + 108 -[uinib instantiatewithowner:options:] + 852 -[nsbundle(uinsbundleadditions) loadnibnamed:owner:options:] + 160 0x43a2e -[uitableview _delegateviewforheaderinsection:] + 36 ___96-[uitableview _sectionheaderview:withframe:forsection:floating:reuseviewifpossible:willdisplay:]_block_invoke + 82 +[uiview(animation) performwithoutanimation:] + 68 -[uitableview _sectionheaderview:withframe:forsection:floating:reuseviewifpossible:willdisplay:] + 542 -[uitableview _sectionheaderviewwithframe:forsection:floating:reuseviewifpossible:willdispla...