Parth Code

this question has answer here: check if row exists, otherwise insert 10 answers mysql conditional insert 11 answers i want run set of queries insert data sql table if record satisfying criteria met. table has 4 fields: id (primary), fund_id , date , price i have 3 fields in query: fund_id , date , price . so query go this: insert funds (fund_id, date, price) values (23, '2013-02-12', 22.43) not exists ( select * funds fund_id = 23 , date = '2013-02-12' ); so want insert data if record matching fund_id , date not exist. if above correct strikes me quite inefficient way of achieving additional select statement must run each time. is there better way of achieving above? edit: clarification neither fund_id...

i'm develop client (proxy) webservice (is test call axis webservices). xsd is: <complextype name="getpermissionsrequest"> <sequence> <element name="idemploye" type="string"></element> </sequence> </complextype> <complextype name="getpermissionsresponse"> <sequence> <element name="permissions" type="tns:permission" maxoccurs="unbounded" minoccurs="0"></element> </sequence> </complextype> <complextype name="permission"> <sequence> <element name="idemploye" type="string"></element> <element name="idsystem" type="string"></element> </sequence> </complextype> <element name="getpermissionsrequest" type="tns:getpermissionsrequest"> ...

i adding listobject excel 2007 workbook using vba. listobject have querytable behind it, linking access database. code looks this: dim l listobject dim c adodb.connection dim r adodb.recordset set c = new adodb.connection c.open "provider=microsoft.ace.oledb.12.0;data source=myaccessdatabasepath;persist security info=false;" set r = new adodb.recordset r.open "select * mytable", c set l = activesheet.listobjects.add(xlsrcquery, r, true, xlyes, range("a1")) l.querytable.refresh false 'this line causes error l.querytable.refresh false essentially problem cannot refresh table more once. refresh button on both data , table design ribbons greyed out. have tried similar code without using listobjects (i.e. querytables) , same problem. have tried refreshing underlying connection object , again, same problem. i've spent morning googling no avail. is bug, designed behaviour or (most likely) doing stupid? many in advance, steve ...

i interesting in applying fulltext search on column contains complete path document. instance below: dir1/dir2/countries/regions/countries regions list.pdf now question if possible fulltext search on filename part of column path ? or suggest achieve it? i can't include complete path field in search directory names disturb relevancy in end. meaningful , required information in path field filename. there way without creating new column filenames ? i must apply fulltext searching on other fields other tables in query. any sort of highly appreciated in advance. if have limited number of directory names (in path), can add names in stopwords list . see link edit stopwords list.

the problem i'm facing following: exception in thread "main" javax.persistence.entityexistsexception: different object same identifier value associated session: [de.entities.genre#28] @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1359) @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1310) @ org.hibernate.ejb.abstractentitymanagerimpl.convert(abstractentitymanagerimpl.java:1316) @ org.hibernate.ejb.abstractentitymanagerimpl.persist(abstractentitymanagerimpl.java:881) @ de.model.databasebuilder.importdata(databasebuilder.java:87) @ de.main.main.main(main.java:55) so exception tells me want insert 2 different objects same primary key id. all datas want insert database using jpa coming xml file. parse file saxparser. of course there many genre entries id 28 because many movies have same genre. if use auto-generated ids, data wont correct anymore because id's correctly given xml file. ...

i have sp executing of sqlquery method of dbcontext.database . calling follows: edit 1:- passing datetime now var t = form["datetime"];//value 2013-may-08 09:30 datetime dtm; if (!datetime.tryparse(t, out dtm))//successfully parses dtm = new datetime(2013, 05, 8, 9, 30, 0); var rtime= new sqlparameter("@rtime", dtm); var result = uow.executesp<spresult>("spresult @rtime", rtime).tolist(); the last line throws exception specified cast string datetime not valid. following definition of sp. alter proc [dbo].[spresult] ( @rtime smalldatetime --varchar(32) ) begin --other code end if directly execute sp in sql management studio runs without problem: exec spresult ='2013-may-08 09:30' in sp string converted date time follows: @resultat smalldatetime = cast(@rtime smalldatetime) what going wrong here? what spresult take parameter? presumably datetime ? in case: give datetime : var t = datetime.now; ...

is there way load many models model test case in cakephp? i've tried way class footestcase extends caketestcase { public function setup() { parent::setup(); $this->foo = classregistry::init('foo'); $this->bar = classregistry::init('bar'); $this->unit = classregistry::init('unit'); } }

i have been trying work past few hours now. have cordova 2.2. i created new package called com.tester.newvideouri . i have class called newvideouri in package following content package com.tester.newvideouri; import org.apache.cordova.api.callbackcontext; import org.apache.cordova.api.cordovaplugin; import org.json.jsonarray; import org.json.jsonexception; /** * class echoes string called javascript. */ public class newvideouri extends cordovaplugin { @override public boolean execute(string action, jsonarray args, callbackcontext callbackcontext) throws jsonexception { if (action.equals("echo")) { string message = args.getstring(0); this.echo(message, callbackcontext); return true; } return false; } private void echo(string message, callbackcontext callbackcontext) { system.out.println("success here , display it"); if (message != null && message.lengt...

this question has answer here: why android emulator slow? how can speed android emulator? 81 answers i'm using mac pro quite powerful hardware(8g memory, ssd , i5). however, when run android simulator, it's slow(spent 2 minutes on start-up) , more worse, response mouse click. is there wrong configuration? or can do? thanks! you can switch x86 emulator images, described in the documentation . arm emulator images closer production hardware runs, android devices have arm cpus. however, os x machines use x86 cpus, , converting between arm instructions , x86 instructions on fly adds quite bit of overhead. x86 emulator requires initial setup, give faster results.

i using pyrocms , have module , in have controller, getting values in $var defined in function index(), how load controller in different module, have use variable in controller in dashboard view here controller code in module a public function index() { $data = $this->recent(); } dashboard.php view file <div class="accordion-body collapse in lst" style="overflow: auto;"> <?php print_r($data );?> </div> not getting $data in dashboard.php according documentation , should this: public function index() { $data = $this->recent(); $this->template ->set('data', $data) ->build('dashboard'); } edit: to have module load data when user visits dashboard need use events . following hook should called when loading dashboard. events::register('admin_controller', array($this, 'run'));

i using jquery lot, stuck because browser cannot see jquery library, or maybe loads library after running javascript code. pseudo-code explain question: <html> <head> load css here load jquery here </head> <body> <p class="link-style3"><span id="my_tag"><span>bize hemen yazın</span></span></p> <script> $(function() { $('#my_tag').click(function(e) { alert('tesrt'); }); }); </script> </body> </html> i put stuff in order below, doesn't work now. when click <span id="my_tag"> , doesn't anything, , doesn't return error. what should do? here entire code jsfiddle try avoid syntax errors like(suggestable only) <script type="text/javascript"> $(function() { $('#my_tag').click(function() { ...

i've stumbled (over hair pulled out in trying figure out) onto don't know if bug or me not doing things correctly. i've installed latest version of extension library (v9) onto domino 8.5.3fp2 server via updatesite db , installed osgi db2 driver via same updatesite db. after this, configured xpagesjdbc.nsf database point db2 express-c database (db2.jdbc file) , started testing. works great when use data in 2 tables (users, states) created setup functions on home page. i modified xpages.dbutil java class have different schema name , xpages.datainitializer java class create same 2 tables, schema name part of sql statements. (e.g. "create table users (..." "create table myschema.users (.." ) i reran setup functions on homepage , tables created , populated correct data. meta data functions (left hand navigation) works 100% showing tables , schemas correctly. the jdbc_rowsetdatasource page falls pieces. changing datasource sqltable "user...

how can use post title alt text of posts featured image in wordpress? please show me how/where can tweak wordpress core files achieve that, since seems theme i'm using doesn't react in way plugins re-write alt tags of images... thank you! no need change wordpress core files:) just locate in theme the_post_thumbnail() function used , change to: $title=get_the_title(); the_post_thumbnail( array(150, 150),array( 'alt' =>$title) );

how can simulate gestures programmatically. i points , app repeat these drawings. public void ongesturestarted(gestureoverlayview gestureoverlayview, motionevent motionevent) { log.d("tag", "started gesture: \n" + motionevent.getrawx() + "\n" + motionevent.getrawy() + "\n" + motionevent.geteventtime()); gestures.add(new gesturepoint(motionevent.getrawx(), motionevent.getrawy(), 100)); } @override public void ongesture(gestureoverlayview gestureoverlayview, motionevent motionevent) { //to change body of implemented methods use file | settings | file templates. gestures.add(new gesturepoint(motionevent.getrawx(), motionevent.getrawy(), 100)); log.e("tag", "gesture: \n" + motionevent.getrawx() + "\n" + motionevent.getrawy() + "\n" + motionevent.geteventtime()); } ...

i'm hitting following overlappingfilelockexception in logback. there know issues prudent mode in version of logback? logback-classic 1.0.7 logback-core 1.0.7 slf4j-api 1.7.2 slf4j-ext 1.7.2 11:16:59,252 |-error in ch.qos.logback.core.rolling.rollingfileappender[file_log] - appender [file_log] failed append. java.nio.channels.overlappingfilelockexception @ java.nio.channels.overlappingfilelockexception @ @ sun.nio.ch.sharedfilelocktable.checklist(filelocktable.java:255) @ @ sun.nio.ch.sharedfilelocktable.add(filelocktable.java:152) @ @ sun.nio.ch.filechannelimpl.lock(filechannelimpl.java:972) @ @ java.nio.channels.filechannel.lock(filechannel.java:1052) @ @ ch.qos.logback.core.fileappender.safewrite(fileappender.java:187) @ @ ch.qos.logback.core.fileappender.writeout(fileappender.java:204) @ @ ch.qos.logback.core...

i want enable android app send file 1 device device in various ways (mail, bluetooth, whatever). my first use case email. code i'm using generate send intent. intent shareintent = new intent(); shareintent.setaction(intent.action_send); shareintent.settype("text/xml"); shareintent.putextra(intent.extra_stream, uri); startactivity(intent.createchooser(shareintent, getresources().gettext(r.string.share_list))); when run on simulator (android 2.1), attachment section of resulting mail reads: content-type: ; however, when run on galaxy nexus (android 4.2.2), attachment section reads: content-type: application/tpl; this might because passed uri ends in .tpl . this have expected: content-type: text/xml; am missing here? important mail attachment has correct mime type can use intent filters receiving side of application. i think referring web content types, you should have type in case...

def replace_acronym(): # function not yet implemented #find abbr, text in acronyms.items(): if abbr == acronym_edit.get(): textadd.insert(0,text) #delete name = acronym_edit.get().upper() name.upper() r =dict(acronyms) del r[name] open('acronym_dict.py','w')as outfile: outfile.write(str(r)) outfile.close() # uneccessary explicit closure since used with... message ='{0} {1} {2} \n '.format('removed', name,'with text database.') display.insert('0.0',message) #add abbr_in = acronym_edit.get() text_in = add_expansion.get() acronyms[abbr_in] = text_in # write amended dictionary open('acronym_dict.py','w')as outfile: outfile.write(str(acronyms)) outfile.close() message ='{0} {1}:{2}{3}\n '.format('modified entry', abbr_in,text_in, 'added') display.insert('0.0',message)...

(note: asked question, answer specific java, , asking same question c# , .net framework. not duplicate.) i have been using pattern while, came think might not ok this. basically, use variant of pattern: public class sampleasync { public sampleasync() { } private bool completed; public void start() { var worker = new backgroundworker(); worker.dowork += (sender, e) => { //... on different thread completed = true; }; worker.runworkerasync(); } public void update() { if (!completed) return; //... else } } *the user responsible making sure start called once. update called wherever , whenever. i've assumed threadsafe in c#/the .net framework, because though nothing strictly synchronized, ever set completed true. once has been observed true , not reset false . initialized false in constructor, definition thread safe (unless stupid in it). so, thread safe use unreset...

i trying write log4j logfile using netbeans java. succeded writing log file c:\tmp\log.txt , reason have no premission write @ root of project : log.txt. this log4j.properties: log4j.rootlogger = all, file # define file appender log4j.appender.file=org.apache.log4j.fileappender log4j.appender.file.file=log.txt <- failes # define layout file appender log4j.appender.file.layout=org.apache.log4j.patternlayout log4j.appender.file.layout.conversionpattern=[%5p](%f:%l) %m%n log4j.appender.file.append=false have try : log4j.appender.file.file=./log.txt . represents current folder (usually project root folder). maybe log file set placed somewhere in root of drive. this reference may useful : where log4j log files?

when error $(document).ready(function(){ undefined , because jquery library not on page situation, error occurs since have small jquery plug-in on pages resolve issue when jquery library present during particular time of user's session. besides placing jquery library on page when particular error occurs, solution check if jquery present or error not occur on page overall? // if jquery isn't defined if (typeof jquery == 'undefined') { } else { // jquery loaded // run jquery code };

i've json template in property file in project. there way can use apache velocity embedding dynamic content without using .vm file ? i've like: template = [ { "name" : "$firstname $lastname" } ]; in .properties file. when parse json , store corresponding value want use velocity can firstname , lastname dynamically. you asking how load velocity template value in properties file instead of template file. you can writing custom resourceloader velocity. resource loader parse properties file , return template stored property value. for work, have configure velocity use resource loader instead of 1 using.

i trying call method class, inside method, call method first class... can't explain better, here's want code... myclass.cs public static void validarcampos(object sender) { **some code here** } // here, keydown function calls myhelper.cs=>textboxkyedown method private void tb_keydown(object sender, keyeventargs e) { (sender textbox).textboxkeydown(e, this); } myhelper.cs public static void textboxkeydown(this textbox tb, keyeventargs e, control container) { switch (e.keycode) { case keys.enter: case keys.add: tb.zerofill(e); // want call myclass.cs=>validarcampos(tb); // here, before moves next tb, because on // validarcampos(tb) can tell if next tb // enabled or not, if not call here // when press enter or add, wont move next tb // until press twice... e.suppresskeypress = true; container.selectnextcontrol(tb, true, true, fa...

when tried configure ldap ear application getting below error in server.log : 18:21:22,740 info [org.jboss.as.osgi] (msc service thread 1-1) jbas011907: register module: module "deployment.sbicardsadmin.ear.sbicardsadmin-war.war:main" service module loader 18:21:23,027 info [org.jboss.as.server] (controller boot thread) jbas018559: deployed "sbicardsadmin.ear" 18:21:23,028 info [org.jboss.as.server] (controller boot thread) jbas018559: deployed "webapplication1.war" 18:21:23,029 info [org.jboss.as.controller] (controller boot thread) jbas014774: service status report jbas014775: new missing/unsatisfied dependencies: service jboss.security.security-domain.sbicardsadmin (missing) dependents: [service jboss.web.deployment.default-host./sbicardsadmin-war.realm] domain.xml <subsystem xmlns="urn:jboss:domain:security:1.0"> <security-domains> <security-domain name=...

what i'm trying write this file << somefunction(5) << hex << 3; and output 00003 instead of 3 (and 300 00300, etc) note:- sorry if asked before, don't know term search this edit:- mean zero's left, included hex part clear want compatible format i believe mean. #include <iostream> #include <iomanip> int main() { std::cout << std::setw(5) << std::setfill('0') << 3 << '\n'; return 0; } output 00003 links setw , setfill . edit: also, see std::internal at question .

i'd submit form and, @ same time, send ajax request spring mvc server. have form this: <form id='confirma' method='post' action='confirma'> <button type='submit' id='save' class='btn btn-success' value='save'>enviar</button> </form> in server, have 2 methods receive both requests (the ajax request , normal form submission). // receive form @requestmapping("fromform") public string fromform(model model) { // atb1 values database model.addattribute("atb1", atb1); return "file.jsp"; } // receive ajax @requestmapping("fromajax") public void fromajax(string jsondata) { // deserialize json data , insert on database system.out.println("data received!"); } my intention receive data ajax request, save in database, , data in form submission method, called, in example, fromform. i know might crazy i'm doing b...

what best way highscore quiz app? leaning toward shared preference, have date/time , player name included score in highscore page. using score ninja overboard? this first venture android world , have in pocket read. grateful if advise me actual experience in building highscore activity... if going storing many high scores, , storing more score, recommend using sqlite database . sharedpreferences great storing sparse data (e.g. setting, single score). when start storing top 10 scores or indeterminate number of scores along date earned , name of sort, sharedpreferences become little bit more awkward deal with. plus storing table of high scores number of different fields screams "database!"

in code strange space rendered in between 2 inner divs in following html structure <body> <div class='datepicker'> <div id="daydiv" class='daydiv' style='background-color:blue'> <div class="" style='display: inline-block; height:10%;width:10%;background-color:red;vertical-align:top'> </div> <div class="" style='display: inline-block; height:10%;width:10%;background-color:red;vertical-align:top'> </div> </div> </div> </body> the innermost divs rendered space in between of them , want remove that. following jsfiddle link see page styles-sheet. note: margin, border , padding 0 elements remove white space between divs , goes away <div class='datepicker'> <div id="daydiv" class='daydiv' style='background-color:blue...

if have public property has getter, correct use private variable assign value return value or should use return rather setting value of userid ? in future plan add more functionality use userid field, , methods added class use userid field. there benefit 1 way or other? there other way should done? private string userid; public string id { { if (system.web.httpcontext.current.request.headers.allkeys.contains("uid")) { userid = system.web.httpcontext.current.request.headers["uid"].tostring(); } else { userid = "0000"; } return userid; } } the way getter coded right not need assignment, because subsequent calls ignore value set previous methods. however, cache result, this: private string userid; public string id { { if (userid == null) { if (system.web.httpcontex...

my per-project sublime text 2 settings seem not override global settings. added lines inside "settings" inside myproj.sublime-project : "file_exclude_patterns": ["config.xml"] "folder_exclude_patterns": [".git", ".metadata"] but did not prevent folders/files showing on project sidebar. none of files/folders above mentioned in global settings. is known sublime issue? doing wrong? you have add settings under folders (example taken here ): { "folders": [ { "path": "src", "folder_exclude_patterns": ["backup"] }, { "path": "docs", "name": "documentation", "file_exclude_patterns": ["*.css"] } ] }

been following question on site try , change label backcolour visible in .mdb database, using sql connect vb.net database. have seating plan set grid in form, using labels seats. labels should turn red if seat-code shown in booking database (the record added when seat booked) otherwise if returns no records label stays green. private sub checkfriday() dim friday(11, 20) control 'friday row friday(1, 1) = fa1 friday(1, 2) = fa2 friday(1, 3) = fa3 friday(1, 4) = fa4 friday(1, 5) = fa5 friday(1, 6) = fa6 friday(1, 7) = fa7 friday(1, 8) = fa8 friday(1, 9) = fa9 friday(1, 10) = fa10 friday(1, 11) = fa11 friday(1, 12) = fa12 friday(1, 13) = fa13 friday(1, 14) = fa14 'friday row b friday(2, 1) = fb1 friday(2, 2) = fb2 friday(2, 3) = fb3 friday(2, 4) = fb4 friday(2, 5) = fb5 friday(2, 6) = fb6 friday(2, 7) = fb7 friday(2, 8) = fb8 friday(2, 9) = fb9 friday(2, 10) = fb10 ...

i trying find routing configuration apicontroller having multiple methods. the controller class has 3 methods: public function getallproducts() ienumerable(of product) public function getproductbyid(prodid integer) product public function getproductbycategory(categoryname string) product please suggest routing configuration needed 3 methods. we follow web api design guidelines apigee , collections of patterns used in several , succesful web apis around world. the guideline suggest chart bellow organize web api resources, ideal scenario keep 2 base urls resource: in specific case, resource "product", suggest bellow urls: /products /products/{id} /products?cagetoryname={categoryname} and web api table routes can configurated easy, like: routes.maphttproute( name: "defaultapi", routetemplate: "api/{controller}/{id}", defaults: new { id = routeparameter.optional, action = routeparameter.optiona...

i've got collection of items , [ { itemid: 1249, somefield: 'abc' }, { itemid: 1479, anotherfield: 'bcc' } , // etc ] i recieve portion of data. of items there, not, [ { itemid: 6534, somefield: 'trw' }, // stored in collection.. { itemid: 1249, somefield: 'abc' } ] i'm looking way of bulk insert of data upsert strategy (means, if item such itemid there - update, otherwise insert). is possible 1 query, of need go throught collection manually , upsert each item? i use this, not effecent method, works mongoclient.connect("mongodb://localhost:27017/devbed", {native_parser:true}, function(err, db) { db.collection(project.name).findone({"revision":project.tmprev}, function(err,item){ if(item){ db.collection(project.name).update({json},{w:1},functi...

i hope record result of stderr & stdout different files, while watching both outputs terminal. so use tee , , found solution in this page . but sad thing is, can't work when put makefile: all: @command > >(tee stdout.log) 2> >(tee stderr.log >&2) it seems make use sh -c execute line, doesn't understand syntax. can have solution this? in order use syntax in makefile need change shell make uses running commands setting shell variable. by invoking make using: make shell=/bin/bash , or putting shell:=/bin/bash @ start of makefile should accomplish this.

i'm using localstorage keep local database within node-webkit based app , getting error: error: quotaexceedederror: dom exception 22 while attempting create new records. how increase localstorage quota within node-webkit? preferably unlimited value (or failing that, @ all). the limit removed commit: https://github.com/zcbenz/chromium/commit/e1c7731d5bd099ca5544fcf8eda3867d4ce5bab5

i'm working application uses wstrustchannelfactory create trust channels, noticed code creating new wstrustchannelfactory everytime new channel needed. i've never worked before since factory suppose can implemented singleton. am right? if so, there additional consideration take (will factory "usable" or there scenarios/exceptions should replaced new instance)?. also, factory creation expensive operation, such wcf channelfactory creation? am right? yes, think are. i've worked on several projects used channel factory , each time singleton . has limits , can become bottleneck under high load, lot implementations think fine.

i have 3 datepickers - have 1 datepicker shows 6 month span across top, , 2 date pickers beneath applied input fields. when input fields changed, want datepicker across top of webpage highlight start , end dates, , dates in between. i have far been able highlight both start , end date can see in following code, i'd appreciate someones in how should go highlighting days in between. var $test = $.datepicker.formatdate('yy-m-d', $('#date-start').datepicker('getdate')); var $test2 = $.datepicker.formatdate('yy-m-d', $('#date-end').datepicker('getdate')); var dates1 = {}; dates1[$test] = 'first date'; var dates2 = {}; dates2[$test2] = 'second date'; $( "#calendar" ).datepicker({ firstday: 1, numberofmonths: 6, dateformat: 'yy-mm-dd', beforeshowday: function(date) { var search = date.getfullyear() + "-...

i using spring 3.2 mvc controller , spring-ws create restful web-service. spring controller accepts object files update database correctly , returns json front-end. spring context set message converts json. have unit tests these, know spring controllers working , filing data accordingly. the error, warning, comes when data/json web-service: 10:05:08.906[error[phonebook]10:05:08.902:xrp3:warn:restdatasource:restuserds:restuserds.userbirthdate:value:-99187200000 failed on validator {type:&quot;isdate&quot;,typecastvalidator:true,_generated:true,defaulterrormessage:&quot;must date.&quot;} com.smartgwt.client.core.jsobject$sgwt_warn: 10:05:08.902:xrp3:warn:restdatasource:restuserds:restuserds.userbirthdate: value: -99187200000 failed on validator: {type: &quot;isdate&quot;,typecastvalidator: true,_generated: true,defaulterrormessage: &quot;must date.&quot;} @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method) @ sun.reflec...

the problem have run seems has simple answer. want have website simple task of grabbing piece of text webpage. i want code like... var str = textfromwebpage; the text want "grab" on http://dasd-sharepoint.dasd.org/schools/stemacademy/pages/default.aspx if on page (try control f , search current date, ex: "may-9-2013:" ) list of next 5 dates. want take list , use in variables in javascript. so prefered end result be var str = new array("may-9-2013: “f” day", "may-10-2013: “g” day", "may-13-2013: “h” day", "may-14-2013: “i” day", "may-15-2013: “j” day", "may-16-2013: “k” day"); purpose: school i'm checking time. instead of doing math make quick little program @ current time vs time current class ends. in school have different "letter days" means class lengths different on different days. letter days based on 12 day cycle means. monday through friday a-e mean following week mond...