Tarik Use array_agg: http://www.sqlfiddle.com/#!1/5099e/1 SELECT s.name, array_agg(g.Mark) as marks FROM student s LEFT JOIN Grade g ON g.Student_id = s.Id GROUP BY s.Id By the way, if you are using Postgres 9.1, you don’t need to repeat the columns on SELECT to GROUP BY, e.g. you don’t need to repeat the student name on GROUP BY. … Read more
Allow me to preface this answer by stating that all of these hooks are very rarely used. 99% of the time, you won’t need these. They are only meant to cover some rare corner-case scenarios. useImperativeHandle Usually when you use useRef you are given the instance value of the component the ref is attached to. … Read more
You can execute commands in parallel with start like this: start “” ping myserver start “” nslookup myserver start “” morecommands They will each start in their own command prompt and allow you to run multiple commands at the same time from one batch file. Hope this helps!
viewGroup.removeAllViews() works for any viewGroup. in your case it is GridView. http://developer.android.com/reference/android/view/ViewGroup.html#removeAllViews()
AsyncTask instances can only be used one time. Instead, just call your task like new MyAsyncTask().execute(“”); From the AsyncTask API docs: Threading rules There are a few threading rules that must be followed for this class to work properly: The task instance must be created on the UI thread. execute(Params…) must be invoked on the … Read more
You can check Autoscroll from source in setting for project pane (in the lastest version is probably different icon)
Any ideas on how to resolve this? Delete one. I’ve been playing with the build path to no success. Step #1: Undo all that. If you are messing with the build path, on R16 or higher version of the ADT plugin for Eclipse, you’re doing it wrong. Step #2: Pick one of those two versions … Read more
It is implementation dependent. For example, under Windows they are the same, but for example on Alpha systems a long was 64 bits whereas an int was 32 bits. This article covers the rules for the Intel C++ compiler on variable platforms. To summarize: OS arch size Windows IA-32 4 bytes Windows Intel 64 4 … Read more
You can use the FormData API. If you’re using jquery.ajax, you need to set processData: false and contentType: false. var fd = new FormData(); fd.append(‘fname’, ‘test.wav’); fd.append(‘data’, soundBlob); $.ajax({ type: ‘POST’, url: ‘/upload.php’, data: fd, processData: false, contentType: false }).done(function(data) { console.log(data); });
You can manually set xticks (and yticks) using pyplot.xticks: import matplotlib.pyplot as plt import numpy as np x = np.array([0,1,2,3]) y = np.array([20,21,22,23]) my_xticks = [‘John’,’Arnold’,’Mavis’,’Matt’] plt.xticks(x, my_xticks) plt.plot(x, y) plt.show()