Computing desk | ||
---|---|---|
< April 5 | << Mar | April | May >> | April 7 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
I want to download this movie from YouTube. Among the best qualities, there are two options available: MP4 360p and FLV 480p. Which will be better in quality? Are MP4 videos better in quality? Please help, i have a slow internet connection and it takes a lot of time to download videos in my computer. I want the better quality video. --Houlok (talk) 05:54, 6 April 2011 (UTC)
Hi,
how can I disable the behaviour of my laptop touchpad to inerpret the tipping on the pad as a click? I am using a Dell Inspiron with With Windows 7 Home Premium. Toshio Yamaguchi (talk) 12:19, 6 April 2011 (UTC)
I ran into a rather complicated problem with SQL today at work. We are using the following kind of SQL query:
SELECT a.name, b.name, c.name, d.name FROM tablea a, tableb b, tablec c, tabled d WHERE b.aid(+) = a.id AND c.bid(+) = b.id AND d.id(+) = c.did
The idea is that this query must return rows even if no matching row is found from tableb
, tablec
or tabled
, but if no matching rows are found from tablec
or tabled
, then b.name
must be null even if there's actually a value there. I tried various ways of configuring the outer joins but couldn't find a way to do it the right way. Sorry for the nondescriptive names used in this example, but the actual code is under our company's copyright. Can anyone help me to achieve this kind of thing in SQL? JIP | Talk 18:44, 6 April 2011 (UTC)
Suppose tablea
contains the following data:
name | id |
---|---|
Tarja Halonen | 1 |
Carl XVI Gustaf | 2 |
Angela Merkel | 3 |
Palpatine | 4 |
tableb
contains the following data:
name | id | aid |
---|---|---|
Finland | 10 | 1 |
Sweden | 20 | 2 |
Germany | 30 | 3 |
tablec
contains the following data:
bid | did |
---|---|
10 | 100 |
20 | 200 |
tabled
contains the following data:
name | id |
---|---|
Helsinki | 100 |
Stockholm | 200 |
I want to be able to return every row in tablea
, even though Palpatine can't be linked to any of the other tables. However, I don't want Germany to show up along with Angela Merkel, because it can't be linked to tablec
or tabled
, instead it should show up as null. JIP | Talk 17:44, 7 April 2011 (UTC)
Tarja Halonen Finland Helsinki Carl XVI Gustaf Sweden Stockholm Angela Merkel Palpatine
(SELECT a.name, b.name, d.name FROM tablea a, tableb b, tablec c, tabled d WHERE b.aid = a.id AND c.bid = b.id AND d.id = c.did) UNION (SELECT a.name, " ", " " FROM tablea a, tableb b WHERE b.aid != a.id)
tablea
is joined to more tables, which are irrelevant to this question. The actual query is quite long and isn't even written as static text but instead built dynamically because parts of it can change. Having a union would mean having to repeat all this. I've managed to work around the problem by having the code that reads the result ignore values from tableb
that can't be linked to tablec
or tabled
. JIP | Talk 18:09, 8 April 2011 (UTC)Hi. As of this morning, my fixes to remove the igoogle side tabs on firefox don't work (the tabs appear on the left side of my igoogle page, with idiotic things like "gadget shares" and "friends"--things I have no interest in, and waste my screen real-estate). Bad google. My greasemonkey script, having given good service for a year or so, now doesn't get rid of them, and the firefox plug-in doesn't work either. I'm going to have to switch to netvibes or similar if I can't sort this out. Any genius out there with an idea how to remove those stupid side tabs? Robinh (talk) 20:56, 6 April 2011 (UTC)