Kirat[ad_1] I’m quite sure this query will work; meaning that it won’t return an error but I’m not certain if it will return correct result as what you intended: SELECT s.Name, SUM(p.Note=5)/COUNT(*) as Anteil FROM Studenten s JOIN pruefen p ON p.MatrNr = s.MatrNr GROUP BY s.Name ORDER BY Anteil DESC, s.Name ASC; If this … Read more
[ad_1] Running your code through the popular online c compiler here: http://www.tutorialspoint.com/compile_c_online.php Your code ran as expected. What happens when you type “.”? EDIT: (Solution) The problem was that when you input a negative number, a=”-” which has an integer value greater than zero, hence not triggering the negative case. The solution then, is to … Read more
[ad_1] str converts the list into its string representation. Use map to convert each number in the list to str: lista = [1,2,3,4,9,5] print(“<“.join(map(str, sorted(lista)))) >>> 1<2<3<4<5<9 0 [ad_2] solved Can´t join a list the way I would like
[ad_1] Use this pattern instead (it looks for single digits): import re print(re.search(r’\b\d\b’, “I’m 30 years old.”)) Output: None This also works for Unicode characters in Python 3. To also account for punctuation, you can use \b\d(\b|\.|\?|\!) 3 [ad_2] solved regular expression to search only one-digit number
[ad_1] nums.count(val) counts how many instances of val are in nums. for i in range(nums.count(val)):… is a loop that iterates nums.count(val) times, or, in other words, it iterates as many times as the number of val‘s in nums. i does not actually do anything here, so the more “Pythonic” way of writing that would be … Read more
[ad_1] It’s more or less the same as your other question. The only change is that you’ll have to set “company,date” as the key columns to perform the join on (note that the order is important – it’ll first sort by company and then by date). require(data.table) ## 1.9.2 setDT(df) setDT(event) setkey(df, company1, date1) setkey(event, … Read more
[ad_1] I believe you can do it with a custom extension and view(code is below the image). //main view import SwiftUI struct ContentView: View { @State var text = “” var body: some View { VStack { TextField(“”, text: $text) .frame(width: 200, height: 40) .border(width: 1, edges: [.bottom], color: .gray.opacity(0.4)) .border(width: 1, edges: [.top, .leading, … Read more
[ad_1] If this is for a specific row, maybe use SUBSTR? Something like SELECT SUBSTR(column, 6, 5) AS col1 , SUBSTR(column, 13, 5) AS col2 FROM table Here is something else you can do.. Although it gets pretty complicated, and this isn’t the exact answer you are looking for but it will get you started. … Read more
[ad_1] Try out ! let url = window.location.toString(); window.location = url.replace(/function=login/, ‘/function=userloggedIn/’); [ad_2] solved How can I edit the URL without changing pages?
[ad_1] Guys finally i found Solution as Follows and working Great!! Controller def stagemilestone @milestones=Milestone.find(:all, :conditions => [“status_id=? and project_id=?”,params[:stageid], params[:id]]) respond_to do |format| format.html # index.html.erb format.json { render :json => @milestones} end end and My char.js looks like this $.ajax({ type : ‘get’, url : “/projects/stagemilestone”, data : “stageid=” + $(this).attr(‘name’) + “&id=” … Read more
[ad_1] This is a ternary operator the way it works is : condition ? (things to do if true) : (things to do if false); In your code what it does is : if value of Math.random() – 0.5 < 0 then assign change a values of -5 else assign change a value of 5. … Read more
[ad_1] checkboxClick:function(e) { var series = this.chart.series; if(e.checked){ for(i=0; i < series.length; i++) { series[i].show(); } } else{ for(i=0; i < series.length; i++) { series[i].hide(); } } } https://jsfiddle.net/anil_pin2/x5grrsc5/2/ This is what I want.an extra checkbox in my legend area. [ad_2] solved I want an extra Legend in highcharts column chart
[ad_1] milliseconds = (int) (appCurrentTime % 1000); String hours, minutes=String.format(“%02d”, mins), seconds=String.format(“%02d”, secs), miliSeconds=String.format(“%03d”, milliseconds); time.setText(minutes + “:” + seconds+ “:” + miliSeconds.substring(0,2) ); [ad_2] solved Formatting mili seconds in java using only hundredth and tenth position of the mill seconds
[ad_1] By the looks of the question, I assume that the input file is in csv format and the IOB2 format looks as though it is space or tab separated tokens. So the simplest way to achieve that format would be to read each line and replace the comma delimiter with a space. # fill … Read more
[ad_1] Many thanks to @Progrock for pointing me to checking last accessed time for files in target folder. This is what I had to do. Ensure capturing last accessed time is being set by Windows (see Directory.GetFiles keeping the last access time) Process.Start(“fsutil”, “behavior set disablelastaccess 0”).WaitForExit(); Also need to restart IIS to stop any … Read more