Five

tsql - Problem with using max in the below update statement - hi i'm having problem using max statement in below query working on update tb_ts_cm_ofirecpt set amt = (coalesce (abs(cmledg.tranamt), 0) + coalesce (abs(cmledg_1.tranamt), 0)) * - 1, tranamt = abs(cmledg.tranamt) *-1, rtaxamt = coalesce (abs(cmledg_1.tranamt) * - 1, 0), tranid = cmledg.tranid tb_ts_cm_ofirecpt inner bring together cmledg on tb_ts_cm_ofirecpt.tranid = cmledg.refnmbr , tb_ts_cm_ofirecpt.descrptn = cmledg.descrptn left outer bring together cmledg cmledg_1 on cmledg.tranid = cmledg_1.parenttranid , cmledg.descrptn = cmledg_1.descrptn (tb_ts_cm_ofirecpt.impid = '195') , (tb_ts_cm_ofirecpt.action = 'reversed') tranid = cmledg.tranid tb_ts_cm_ofirecpt inner bring together cmledg - particualr line should tranid = select max(tranid) .... however kerep getting syntax error. appreciate yuor help regards, abhi not exclusively sure try: tranid = (select max(t...

deployment - What technology should I use/how should I deploy my killer web app? - i decided time write "killer web app" dream about. :-) i've been programmer long can remember i'm not scared of technology, haven't been active in web world decade. looking help on direction should go. the app i'm considering: (in order of importance) 1) need charge customers securely using else's service 2) must scale 3) must inexpensive deploy 4) must reasonably responsive (much of client side javascript, there server interaction) 5) need database on end (not huge database, need scale client base) i'm thinking of using following: technology: mysql, php, javascript deployment: amazon cloud payment: paypal is right direction?? (any tutorial links appreciated) use know best. don't worry much technology choices. technologies list "safe" choices in sense many successful web apps have been built them, know can done. i...

asp.net - Applying Css Style to Asp:Menu MenuItem - i'm creating vertical breadcrumb create website navigation mobile (iphone) website. similar maybe how http://news.bbc.co.uk/sport1/hi/football/default.stm works click "premier league" using asp:menu command , sitemapdatasource binding current levels links within sitemap , finding parent manually insert @ top of list. illustration resulting nav be: about, we, do, locations var mi = new menuitem(); mi.navigateurl = node.url; mi.text = node.title; mi.tooltip = node.description; mobilemenu.items.addat(0, mi); this fine , works perfectly. however, dynamically inserted top menuitem needs styled in different background colour. in illustration above "about" have darker bg colour 3 items below it. but there isn't kind of obvious property on menuitem this. how dynamically set style on menuitem inserting position 0? in reply used jquery li:nth-child() method set class li after utilize...

d3.js - Error in redrawing graph with update function - i'm trying redraw , update graph every time slider moved, filters dataset within year range. unfortunately things aren't working , i'm unsure mistakes are. when seek run code error: error: invalid value <rect> attribute y="nan" error: invalid value <rect> attribute height="nan" i'm totally lost, help appreciated. link fiddle: http://jsfiddle.net/vyab4kcf/11/ you shouldn't doing this... request_data = data; and line referring global year when should local argument sexyear var yeardata = data.filter(function (element) { homecoming element.year == year }); should var yeardata = data.filter(function (element) { homecoming element.year == sexyear }); also, seek change event input works in ie... d3.select("#sexyear").on("change", function () { update(+this.value); }); this.value undefined here because...

rest - Python Tornado: Delete request never ends - i having problems delete request in tornado. request arrives server , in handler work great, never returns response client. i have tried returning something, "return" , without "return" , result same. i using python 3.4, tornado 4.1 , restclient of firefox. @web.asynchronous @gen.coroutine def delete(self, _id): try: model = model() model.delete(_id) self.set_status(204) except exception e: logging.error(e) self.set_status(500) homecoming tornado documentation (tornado.web.asynchronous): if decorator given, response not finished when method > returns. request handler phone call self.finish() finish > http request. you need phone call tornado.web.requesthandler.finish method. work: @web.asynchronous @gen.coroutine def delete(self, _id): try: model = model() model.delete(_id) self.set_status(204) ...

android - ECC key generation error - hi trying implement code provided anindonesian in flexiprovider - how encrypt/de formatted keypair on android. i getting nullpointerexception kpg.initialize(brainpoolp160r1); i new android , cryptography help appreciated. here have created page generates ecc key , encrypts/decrypts info , displays in text box. import android.os.bundle; import android.support.v7.app.actionbaractivity; import android.util.base64; import android.view.menu; import android.view.menuitem; import android.widget.textview; import org.bouncycastle.jce.provider.bouncycastleprovider; import java.security.invalidalgorithmparameterexception; import java.security.invalidkeyexception; import java.security.keypair; import java.security.keypairgenerator; import java.security.nosuchalgorithmexception; import java.security.nosuchproviderexception; import java.security.privatekey; import java.security.publickey; import java.security.security; import java.security.spec.ecg...

python imaging library - Re-coding Select JPEG Blocks with Pillow / PIL - is there someway in pil / pillow open jpeg file, modify portion of image , save image jpeg blocks modifications re-encoded? there libraries back upwards this: https://en.wikipedia.org/wiki/jpeg#lossless_editing what describing impossible. jpeg encodes in groups called mcus composed of 1 or more 8x8 info blocks. you'd have encode along info block or mcu boundary. the other problem dc coefficients (the [0,0] coefficient dc) encoded together. changing 1 means need alter ones follow. jpeg python-imaging-library pillow