Search

hi having problem in following query: update tbl set somecol = somecol key = (select key tbl group key having count(*) > 1) , time = (select max(time) tbl) above query works fine when there 1 key. if there more 1 keys query doesn't work. how store multiple values select subquery? time column can multiple. new sql. please guide. in advance. use in predicate: update tbl set somecol = somecol key in (select key tbl group key having count(*) > 1) , time = (select max(time) tbl)

i working on activity has username , password. used alertdialog.builder in else part show message of "wrong password or username". not connecting database test purpose using strings password , username compare values of edittext fields with, in if condition , if match takes user new screen name "newmenu" . problem when login activity starts (the app runs), shows first of message, else part, want show message after submit button has been clicked , the password or username wrong. here code public class login extends activity{ private string pass=new string(); private string nam=new string(); private button log; private view textreg; private edittext text1; private edittext text2; @override protected void oncreate(bundle savedinstancestate) { super.oncreate(savedinstancestate); setcontentview(r.layout.login); textreg=(textview) findviewbyid(r.id.textregister); log=(button) findviewbyid(r.id.btn...

i trying implement auto-wiring project, seems application isn't seeing sessionfactory definition in application-context.xml when running it. i'm missing obvious, though i've tried several solutions posts having similar issues no success. i using spring mvc , hibernate. here application-context.xml. <?xml version="1.0" encoding="utf-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context" xsi:schemalocation=" http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.0.xsd http://www.springframework.org/schema/aop ...

i have tableview custom-designed cells , if add swipe-to-delete buttons layout horrible. possible reposition these buttons inside cell? no not possible made changes delete button because built-in or default functionality of apple ios. better stop fighting :)

i trying find last entry specific user each location . need ignore rows balance zero. sample table: id location user balance -- -------- ---- ------- 1 gla 10.21 2 gla 0.00 3 gla b 45.68 4 gla b 12.56 5 edi c 1.23 6 edi d 5.48 7 edi d 0.00 8 lon e 78.59 9 man f 0.00 10 man f 12.98 11 man g 56.45 12 man g 89.25 13 man h 0.00 14 bir 0.00 15 bir 32.87 result required: id location user balance -- -------- ---- ------- 4 gla b 12.56 5 edi c 1.23 8 lon e 78.59 10 man f 12.98 12 man g 89.25 15 bir 32.87 i have been left cover colleague off sick , unfotunately sql knowledge limited in comparison. i have been researching using max , partition no luck far. sql server 2005 database. any assistance appr...

need raw message content os x mail.app pass next action. unfortunately - tested - , doesn't works: :( i don't want select "content" of message, want pass raw content (what base64 encoded) next action. so, need applescript action betwwen "get selected mail messages" , "new document". haven't idea how this... the "new textedit doc" tests, real action perl script, read raw message content stdin . try: on run {input, parameters} set thesource {} tell application "mail" repeat amessage in input set end of thesource amessage's source & return end repeat end tell return thesource text end run

we use 3-4 axis's in our matrix projects (os, isa, compiler , more) , annoyed fact have manually write complex combination filters because configurations don't exist. is there way tell jenkins ignore non existing configurations instead of piling them in queue?