Kirat[ad_1] just use join if two queries are fine then below will work select t1.PT_PEMBERI,t2.PT_PENERIMA from (SELECT nl.ID, p.NAMA_PT AS PT_PEMBERI FROM perusahaan p LEFT JOIN penerima_waralaba pw ON pw.ID_PERUSAHAAN = p.ID LEFT JOIN outlet o ON o.ID_PENERIMA_WARALABA = pw.ID LEFT JOIN nomor_logo nl ON nl.ID = o.NOMOR_LOGO_WARALABA WHERE nl.NOMOR_LOGO = ‘WI-0010205-610’ )t1 inner join … Read more
[ad_1] I got this fixed by creating a PHP function to return the latest thread with a SELECT * FROM threads WHERE subcat_id = variable SQL. 1 [ad_2] solved Resulting data on last thread_date
[ad_1] That is perfectly safe, if that is your question, since php as a quasi interpreted language does not leave any traces or artifacts when terminating the execution. If it is a good practice is another thing. I’d say it is fine for testing purposes, but you should avoid it in final code. Reason is … Read more
[ad_1] There is a method for Strings, called replaceAll, which you can use to replace parts of the String, like: “ATGCATGC GTCGTGA .”.replaceAll (“A”, “T”); In the upcomming java9, there is a jshell, ideally suited to test such things. -> “ATGCATGC GTCGTGA .”.replaceAll (“A”, “T”) | Expression value is: “TTGCTTGC GTCGTGT .” | assigned to … Read more
[ad_1] With that amount of information I can give you this much of an answer HTML <a href=”#” class=”aside-fixed aside-left”>left</a> <a href=”#” class=”aside-fixed aside-right”>right</a> CSS .aside-fixed { position: fixed; z-index: 20; top: 50%; background: black; padding: 10px; color: white; } .aside-left { left: 0; } .aside-right { right: 0; } 0 [ad_2] solved Vertical link … Read more
[ad_1] Perhaps the closest thing in Python to this Javascript array behavior is a dictionary. It’s a hashed mapping. defaultdict is a dictionary that implements a default value. In [1]: from collections import defaultdict In [2]: arr = defaultdict(bool) Insert a couple of True elements: In [3]: arr[10] = True In [4]: arr Out[4]: defaultdict(bool, … Read more
[ad_1] The Error is because you haven’t open the connection before using it. First open the connection with the line “myCon.Open();” before using it in SqlDataAdapter and then use the ‘=’ operator in the select query of the where clause. you have missed that too in your query. Your code should be private void trydb() … Read more
[ad_1] Ok so here is my solution using “onSelect” instead of “onClick” event : myTreeView.attachEvent(“onSelect”, function(id){ pid = myTreeView.getSelectedId(); dhtmlx.alert(pid); }); With this event i can now populate my grid from my tree with adding : myGrid.clearAll(); myGrid.load(“/LRF/XMLWeb/ProcessDescriptor/descriptor/PROJECT/grid.xml”); That’s it 🙂 [ad_2] solved Event “onClick” on treeview DHTMLX
[ad_1] In your code, you declare to return type T, but the variable you return has type list<T>. I’d suggest to develop your code with concrete types (and without templates) first; you can exchange the concrete type with placeholders afterwards, but concrete types give a better idea what actually happens. Try the following code and … Read more
[ad_1] You can’t cast them if they are not realted . The class of the object you’re casting and the class you’re casting it to must be related by inheritance; that is, you can cast an object only to an instance of its class’s sub- or superclass-not to any random class. Side note: Casting downward … Read more
[ad_1] you can do it with HttpURLConnection connection = null; try { URL url = new URL(“http://stackoverflow.com/”); connection = (HttpURLConnection) url.openConnection(); long start = System.currentTimeMillis(); String jsonResponse = myInputStreamReader(connection.getInputStream()); long finish = System.currentTimeMillis(); long totalTime = finish – start; System.out.println(“Total Time for page load – ” + totalTime); } catch (Exception e) { e.printStackTrace(); } … Read more
[ad_1] By setting innerHTML prop in your directive you only set DOM and attributes. But this content need to be compile by angular to allow angular-like behavior (binding directives, instanciating components etc..) . Angular dont have compiler ready to use like angularJS ( which has $compile ). You need to use 3rd party libraries like … Read more
[ad_1] I’d use slick for this. I wrote up an example on how to use it. $(document).ready(function(){ $(‘.slider’).slick({ infinite: true, arrows:true }); $(“#final”).click(function () { console.log(“Current slides:”); console.log($(‘.slide1’).slick(‘slickCurrentSlide’)); console.log($(‘.slide2’).slick(‘slickCurrentSlide’)); console.log($(‘.slide3’).slick(‘slickCurrentSlide’)); }); }); body { background:black; } .sliderContainer { padding:40px; color:white; } <link rel=”stylesheet” href=”https://cdnjs.cloudflare.com/ajax/libs/slick-carousel/1.6.0/slick.min.css” /> <link rel=”stylesheet” href=”https://cdnjs.cloudflare.com/ajax/libs/slick-carousel/1.6.0/slick-theme.min.css” /> <script type=”text/javascript” src=”https://code.jquery.com/jquery-1.11.0.min.js”></script> <script type=”text/javascript” src=”https://code.jquery.com/jquery-migrate-1.2.1.min.js”></script> … Read more
[ad_1] From the documentation. google.maps.Map.setCenter takes a google.maps.LatLng or a LatLngLiteral as an argument. This should work: <li><a onclick=”map.setCenter(new google.maps.LatLng(cityList[0][1], cityList[0][2])); return false”><script>document.write(cityList[0][0]);</script> </a></li> working code snippet: var map; var cityList = [ [‘Atlanta, GA’, 33.840644, -84.238972, 1, “text 0”], [‘Austin, TX’, 30.402887, -97.721606, 2, “text 1”], [‘Boston, MA’, 42.364247, -71.078575, 3, “text 2”], [‘Chicago, … Read more
[ad_1] I figured it out: def add_photo(entry_id, image_path): return requests.post( url = URL, headers = HEADER, files = { ‘entry[entry_id]’: (None, entry_id, ‘text’), ‘entry[photo]’: (os.path.basename(image_path), open(image_path, ‘rb’), ‘image/jpg’, {‘Expires’: ‘0’}) } ) [ad_2] solved How to use python-request to post a file on a Rails App