Five

mysql join count - i have 2 table table leave id | type 1 annual 2 sick 3 unpaid 4 marriage table leavedata idleavedata | leavetype* 1 1 2 1 3 2 4 2 leavetype foreign key (refer id in table leave) how count occurence of id in table leavedata? output illustration : type | count annual 2 sick 2 unpaid 0 or null marriage 0 or null try, select l.type , count(ld.leavetype) count leave l left bring together leavedata ld on ld.leavetype = l.id grouping ld.leavetype mysql

wpf - Error Adorner in a Scrollviewer - i'm trying ensure error adorners don't clipped scrollviewer's bounds. have series of textboxes @ border of fixed width scrollviewer (no horizontal scrolling, vertical). have adorners flag textboxes errors. the problem adorners clipped @ border of scrollviewer. any ideas? *note: have tried wrapping in adornerdecorator. ok solution problem same solution question referenced in comment above. you need retemplate scrollviewer , add together adornerdecorator template. something note in general adorners ... if have problem them, solution tends wrapping element in adornerdecorator, it's not going solution, it's worth first might be. wpf adorner adornerlayer adornerdecorator

ORACLE sql: Return columns associated with MAX value of a subquery that SUM values - i'm having issues problem i'm supposed utilize subqueries. have find names of authors of book(s) have been sold most. have works if there 1 row matches max value of totalsold. select fname, lname books b bring together bookauthor ba on b.isbn = ba.isbn bring together author on ba.authorid = a.authorid b.isbn = (select isbn (select sum(quantity) totalsold, ba.isbn isbn bookauthor ba bring together author on ba.authorid = a.authorid bring together orderitems oi on ba.isbn = oi.isbn grouping ba.isbn order totalsold desc) rownum = 1) however in theory there tie max value , stuck on how homecoming associated isbn tied max value(s). in essence how query without using rownum = 1. i came seems on clunky works: select fname, lname books b bring together bookauthor ba on b.isbn = ba.isbn bring together a...

android - No resource found that matches the given name - on resource chooser noticed there scheme resources of different icons. i wanted utilize in project. placed icons on buttons, , showed out expected: but when tried run app, didn't allow because although showed resource correctly on buttons, in xml file wrote error: error: no resource found matches given name (at 'drawableleft' value '@drawable/ abc_ic_menu_info_details'). so can or can not utilize these resources? use @android:drawable/abc_ic_menu_info_details instead of @drawable/abc_ic_menu_info_details to utilize scheme resource need start @android: android

c++ - OpenCV linking problems with ROS - i'm trying compile this project (following instructions given). when building rosmake , bunch of undefined reference cv::string::deallocate() , undefined reference cv::string::allocate(unsigned long) . find curious i'm getting error in functions while rest of opencv functions seem working properly. i know happens because linker can't find objects these functions compiled to, i'm kind of new ros build scheme , can't find what's wrong. i've tried using cmakelists.txt file provided, , adding find_package(opencv required) , target_link_libraries(xxx xxx ${opencv_libraries}) , without making difference. know opencv installed , compiled (i've used before), , had installed ros without problems. i'm using opencv 3, ros indigo, ubuntu 14.04 i had exact same problem - same error messages, same setup. i've managed solve it, though i'm not sure of steps did contributed. far can tell, due conf...

emulation - linaro-media-create error while booting qemu/linaro - i have been trying run linaro on qemu. have been next guide, https://developer.mozilla.org/en-us/docs/mozilla/developer_guide/virtual_arm_linux_environment#create_the_vm_disk_image the linaro-create-media command executes overall gives errors in between. thats why next command, sudo mount giving error of "invalid offset '' specified" the linaro-create-media command giving many such errors while fetching files, failed fetch http://ports.ubuntu.com natty-updates/universe armel packages 404 not found. natty no longer maintained, i'm guessing that's why repositories downwards , getting 404 errors. can utilize more recent versions of linaro , hwpack: https://releases.linaro.org/15.06/ubuntu example. also, wasn't able mount command work either, found way: sudo kpartx -avs vexpress.img you'll see output similar to: add map loop0p1 (252:2): 0 155584 linea...

mysql - is it possible to specify the IP address for a second database connection on heroku - i have heroku app , utilize heroku postgres main repo. want access sec database in read manner info hosted on 3rd party. have seen reply multiple databases here doesn't solve our static ip issue: how utilize multiple databases 1 rails 3.1 app in heroku? (ie second_database_url). should mention read much of active record infrastucture irrelevant. we want create connection, hash , inert locally (never doing migrations against sec database), etc... however, read-only user going create needs ip address. there way me static ip or proxy these mysql requests easily? i have seen quotaguard static looks http requests. or utilize in scenario. thx mysql ruby-on-rails heroku