| --- Log opened Sun Jul 05 00:00:01 2015 |
| 00:14 | | gizmore [kvirc@Nightstar-l346so.dip0.t-ipconnect.de] has quit [[NS] Quit: KVIrc 4.3.1 Aria http://www.kvirc.net/] |
| 00:53 | | gizmore [kvirc@Nightstar-l346so.dip0.t-ipconnect.de] has joined #code |
| 01:52 | | gizmore [kvirc@Nightstar-l346so.dip0.t-ipconnect.de] has quit [[NS] Quit: KVIrc 4.3.1 Aria http://www.kvirc.net/] |
| 02:07 | | catadroid` [catalyst@Nightstar-jj5ngm.dab.02.net] has joined #code |
| 02:11 | | catadroid [catalyst@Nightstar-cmbtg1.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 03:12 | | catadroid` is now known as catadroid |
| 03:14 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 03:15 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 03:15 | | catalyst [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has joined #code |
| 03:17 | | catadroid [catalyst@Nightstar-jj5ngm.dab.02.net] has quit [[NS] Quit: Bye] |
| 03:50 | | ErikMesoy1 [Erik@Nightstar-ki97ss.customer.cdi.no] has quit [Connection closed] |
| 03:50 | | ErikMesoy [Erik@Nightstar-ki97ss.customer.cdi.no] has joined #code |
| 04:15 | | celticminstrel [celticminst@Nightstar-b6hgh7.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 04:21 | | catalyst [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has quit [[NS] Quit: ] |
| 04:24 | | catadroid [catalyst@Nightstar-536d9n.dab.02.net] has joined #code |
| 06:10 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection closed] |
| 06:21 | | Derakon is now known as Derakon[AFK] |
| 06:48 | | Checkmate [Z@Nightstar-pdi1tp.customer.tdc.net] has quit [Ping timeout: 121 seconds] |
| 07:40 | | Kindamoody|out is now known as Kindamoody |
| 09:00 | | kourbou [kourbou@Nightstar-deqg8j.fbx.proxad.net] has joined #code |
| 09:37 | | kourbou [kourbou@Nightstar-deqg8j.fbx.proxad.net] has quit [Connection reset by peer] |
| 09:39 | <@simon> | I'm constructing a database query for a filtering mechanism for a webpage. |
| 09:43 | <@simon> | I'll replace the class names to something equivalent, though: |
| 09:44 | <@simon> | I've got Jobs and Contracts, and I want to filter Jobs based on the status of their Contracts. a Job can have many Contracts and Contracts can be Unknown, Good, Bad, ProbablyGood and ProbablyBad. |
| 09:46 | <@simon> | when I filter the Good and the Bad, I'll 1) find all the most recent copy of a Contracts for each job, 2) inner left-join Jobs on these. |
| 09:48 | | catadroid` [catalyst@Nightstar-a7lsmf.dab.02.net] has joined #code |
| 09:48 | <@simon> | (btw, the most recent copy of Contracts for each job was done pretty neatly (Linq): from c1 in contracts from c2 in contracts.Where(c2 => c1.id == c2.id && c1.timestamp < c2.timestamp).DefaultIfEmpty() where c2.id == null select c1; |
| 09:51 | | catadroid [catalyst@Nightstar-536d9n.dab.02.net] has quit [Ping timeout: 121 seconds] |
| 09:53 | <@simon> | anyways, when it comes to the option Unknown (i.e. Jobs where there are no Contracts uploaded), my only idea is to find the complement: i.e., find the Jobs for which there is a Good, Bad, ProbablyGood or ProbablyBad contract, and subtract them from the list of all Jobs. |
| 09:53 | <@simon> | oh... I'm probably not explaining myself well enough. |
| 09:55 | <@simon> | the way a Contract is determined to be Good, Bad, etc. is through two table columns, a nullable boolean and a nullable timestamp. if they're both null, the contract has Unknown status. |
| 09:55 | <@simon> | if neither are null, it's one of the others. (and if one is null and the other isn't, it's an error because this database wasn't normalized. *shrug*) |
| 09:57 | <@simon> | so basically I can't directly see which Contracts are Unknown because a Job can have several "Unknown" contracts and just *one* that isn't Unknown, and it becomes known. |
| 09:57 | <@simon> | I'll go with the complement. I think I just needed to spell it out. |
| 09:58 | <@simon> | (...oh, and it isn't related to jobs or contracts. they're actually TermsOfUse and Company, and the states are Unknown, AllowsCrawlers, DisallowsCrawlers, ProbablyAllowsCrawlers and ProbablyDisallowsCrawlers...) |
| 10:11 | | GreenGuy [GreenGuy@Nightstar-fik25i.gnomino.eu] has joined #code |
| 10:19 | <@gnolam> | <Alek> I've got a wide-screen monitor and a secondary, 4:3 monitor. I'd like to figure out how to put older games into the secondary monitor in fullscreen. I'm running windows. -_- |
| 10:19 | <@gnolam> | Shift+winkey+arrow? |
| 10:23 | | Kindamoody is now known as Kindamoody|afk |
| 10:33 | | macdjord is now known as macdjord|slep |
| 11:06 | < Wizard> | gnolam: That works on windowed apps |
| 11:06 | < Wizard> | Alek: Can you set the 4:3 to your main display to have them launch in it? |
| 11:07 | <@gnolam> | Wizard: the entire reason I learned that combo was because Bastion stubbornly launched fullscreen on the wrong monitor. |
| 11:23 | | celticminstrel [celticminst@Nightstar-3mpo5q.dsl.bell.ca] has joined #code |
| 11:23 | | mode/#code [+o celticminstrel] by ChanServ |
| 12:23 | <@simon> | from c1 in contracts from c2 in contracts.Where(c2 => c1.id == c2.id && c1.timestamp < |
| 12:55 | <@celticminstrel> | You know, it's be really useful if function popup menus also supported jumping to cases in switch statements. |
| 12:56 | <@celticminstrel> | Has no-one ever thought of that? |
| 13:03 | | ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has quit [Ping timeout: 121 seconds] |
| 13:04 | | catadroid` is now known as catadroid |
| 13:47 | | catalyst [catalyst@Nightstar-bt5k4h.81.in-addr.arpa] has joined #code |
| 14:15 | | GreenGuy [GreenGuy@Nightstar-fik25i.gnomino.eu] has quit [Connection closed] |
| 14:39 | | kourbou [kourbou@Nightstar-deqg8j.fbx.proxad.net] has joined #code |
| --- Log closed Sun Jul 05 14:44:41 2015 |
| --- Log opened Sun Jul 05 14:49:48 2015 |
| 14:49 | | TheWatcher [chris@Nightstar-ksqup0.co.uk] has joined #code |
| 14:49 | | Irssi: #code: Total of 38 nicks [26 ops, 0 halfops, 0 voices, 12 normal] |
| 14:49 | | mode/#code [+o TheWatcher] by ChanServ |
| 14:50 | | Irssi: Join to #code was synced in 36 secs |
| 15:08 | | ToxicFrog [ToxicFrog@ServerAdministrator.Nightstar.Net] has joined #code |
| 15:08 | | mode/#code [+ao ToxicFrog ToxicFrog] by ChanServ |
| 15:28 | | catalyst` is now known as catalyst |
| 15:29 | | catadroid` [catalyst@Nightstar-608akv.dab.02.net] has joined #code |
| 15:29 | | catadroid [catalyst@Nightstar-a7lsmf.dab.02.net] has quit [Connection closed] |
| 15:41 | | catadroid` [catalyst@Nightstar-608akv.dab.02.net] has quit [[NS] Quit: Bye] |
| 15:57 | | Derakon[AFK] is now known as Derakon |
| 16:36 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 16:40 | | kourbou is now known as Vallisnt |
| 16:42 | | Vallisnt is now known as kourbou |
| 16:54 | | kourbou [kourbou@Nightstar-deqg8j.fbx.proxad.net] has quit [Connection reset by peer] |
| 16:54 | | kourbou_ [kourbou@Nightstar-deqg8j.fbx.proxad.net] has joined #code |
| 16:55 | | kourbou_ is now known as kourbou |
| 16:58 | | kourbou is now known as kourboucorpse |
| 16:58 | | kourboucorpse is now known as kourbou |
| 17:13 | | Meatyhandbag [sebastianfe@Nightstar-v3t.j75.73.97.IP] has joined #code |
| 17:16 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 17:16 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 17:23 | | Checkmate [Z@Nightstar-r9lk5l.cust.comxnet.dk] has joined #code |
| 17:23 | | mode/#code [+o Checkmate] by ChanServ |
| 17:28 | | kourbou is now known as kourbou|out |
| 17:40 | | GreenGuy [GreenGuy@Nightstar-fik25i.gnomino.eu] has joined #code |
| 17:40 | | kourbou|out is now known as kourbou |
| 17:40 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [[NS] Quit: Leaving] |
| 17:47 | | celticminstrel [celticminst@Nightstar-3mpo5q.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
| 18:08 | | VirusJTG [VirusJTG@Nightstar-lsl.j5i.46.174.IP] has joined #code |
| 18:22 | | kourbou is now known as kourbou|LoL |
| 18:29 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection reset by peer] |
| 18:29 | | GreenGuy [GreenGuy@Nightstar-fik25i.gnomino.eu] has quit [Connection closed] |
| 18:51 | <@Alek> | HM! Thanks, gnolam, Wizard. shift-win-arrow works for a windowed app, will try a fullscreen one later. |
| 19:09 | | kourbou|LoL is now known as kourbou|foodz |
| 19:12 | | Meatyhandbag [sebastianfe@Nightstar-v3t.j75.73.97.IP] has quit [Ping timeout: 121 seconds] |
| 19:26 | | kourbou|foodz is now known as kourbou |
| 19:44 | | Derakon [chriswei@Nightstar-2fe4eq.ca.comcast.net] has quit [Ping timeout: 121 seconds] |
| 20:04 | | Derakon [chriswei@Nightstar-2fe4eq.ca.comcast.net] has joined #code |
| 20:04 | | mode/#code [+ao Derakon Derakon] by ChanServ |
| 20:25 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 20:25 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 20:52 | | Meatyhandbag [sebastianfe@Nightstar-v3t.j75.73.97.IP] has joined #code |
| 21:06 | | Checkmate [Z@Nightstar-r9lk5l.cust.comxnet.dk] has quit [Ping timeout: 121 seconds] |
| 21:12 | | kourbou [kourbou@Nightstar-deqg8j.fbx.proxad.net] has quit [Connection reset by peer] |
| 21:47 | | Alek [Alek@Nightstar-03ja8q.il.comcast.net] has quit [Ping timeout: 121 seconds] |
| 21:50 | | Alek [Alek@Nightstar-03ja8q.il.comcast.net] has joined #code |
| 21:50 | | mode/#code [+o Alek] by ChanServ |
| 22:05 | | Kindamoody|afk is now known as Kindamoody |
| 22:33 | | Checkmate [Z@Nightstar-pdi1tp.customer.tdc.net] has joined #code |
| 22:34 | | mode/#code [+o Checkmate] by ChanServ |
| 22:39 | | Kindamoody is now known as Kindamoody[zZz] |
| 22:41 | | VirusJTG_ [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 22:45 | | VirusJTG [VirusJTG@Nightstar-lsl.j5i.46.174.IP] has quit [Ping timeout: 121 seconds] |
| 23:39 | | Meatyhandbag [sebastianfe@Nightstar-v3t.j75.73.97.IP] has quit [Client exited] |
| --- Log closed Mon Jul 06 00:00:15 2015 |