| --- Log opened Tue Mar 18 00:00:00 2014 |
| 00:18 | | Derakon[AFK] is now known as Derakon |
| 00:46 | | Reiv [NSwebIRC@Nightstar-q8avec.kinect.net.nz] has quit [Ping timeout: 121 seconds] |
| 00:48 | | Reiv [NSwebIRC@Nightstar-q8avec.kinect.net.nz] has joined #code |
| 00:48 | | mode/#code [+o Reiv] by ChanServ |
| 00:50 | | himi [fow035@Nightstar-q9amk4.ffp.csiro.au] has joined #code |
| 00:50 | | mode/#code [+o himi] by ChanServ |
| 00:53 | | VirusJTG_ [VirusJTG@Nightstar-lsl.j5i.46.174.IP] has joined #code |
| 00:56 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [Ping timeout: 121 seconds] |
| 01:12 | | Thalass [thalass@Nightstar-bk3u2d.bigpond.net.au] has quit [Ping timeout: 121 seconds] |
| 01:12 | | Reiv_ [NSwebIRC@Nightstar-q8avec.kinect.net.nz] has joined #code |
| 01:13 | | Reiv [NSwebIRC@Nightstar-q8avec.kinect.net.nz] has quit [Ping timeout: 121 seconds] |
| 01:14 | | VirusJTG_ [VirusJTG@Nightstar-lsl.j5i.46.174.IP] has quit [[NS] Quit: Program Shutting down] |
| 01:15 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 01:18 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [[NS] Quit: Program Shutting down] |
| 01:32 | | Thalass [thalass@Nightstar-bk3u2d.bigpond.net.au] has joined #code |
| 01:33 | | mode/#code [+o Thalass] by ChanServ |
| 02:13 | | Lovan [nobody@Nightstar-0i858a.hr.cox.net] has joined #code |
| 02:14 | | Lovan [nobody@Nightstar-0i858a.hr.cox.net] has left #code [] |
| 02:16 | | HotShot [theeaznon@Nightstar-i370o1.sfldmi.sbcglobal.net] has quit [[NS] Quit: poop break] |
| 02:19 | | mac [macdjord@Nightstar-c0i1dq.cable.rogers.com] has joined #code |
| 02:19 | | Netsplit *.net <-> *.split quits: @Tarinaky, @Thalass, @macdjord, @Kindamoody[zZz], @McMartin, @mac, Turaiel[Offline], ToxicFrog, @RichyB |
| 02:19 | | mode/#code [+o mac] by ChanServ |
| 02:20 | | Netsplit over, joins: @RichyB, &ToxicFrog, &McMartin, mac, @Thalass, @macdjord, @Tarinaky, Turaiel[Offline], @Kindamoody[zZz] |
| 02:21 | | macdjord [macdjord@Nightstar-c0i1dq.cable.rogers.com] has quit [Ping timeout: 121 seconds] |
| 02:30 | | Thalass [thalass@Nightstar-bk3u2d.bigpond.net.au] has quit [Ping timeout: 121 seconds] |
| 02:52 | <&McMartin> | >>> 'slaughter'.endswith('laughter') |
| 02:52 | <&McMartin> | True |
| 03:29 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 03:29 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 03:39 | | Turaiel[Offline] is now known as Turaiel |
| 03:59 | | Harlow [harlow@Nightstar-9hnfdm.il.comcast.net] has joined #code |
| 04:03 | | HotShot [theeaznon@Nightstar-i370o1.sfldmi.sbcglobal.net] has joined #code |
| 04:05 | | Derakon is now known as Derakon[AFK] |
| 05:27 | | Harlow [harlow@Nightstar-9hnfdm.il.comcast.net] has quit [[NS] Quit: Leaving] |
| 05:28 | | Red_Queen [Z@Nightstar-484uip.cust.comxnet.dk] has joined #code |
| 05:28 | | mode/#code [+o Red_Queen] by ChanServ |
| 05:31 | | Turaiel is now known as Turaiel[Offline] |
| 05:37 | | HotShot is now known as HotShot^sleep |
| 06:19 | | Thalass [thalass@Nightstar-bk3u2d.bigpond.net.au] has joined #code |
| 06:19 | | mode/#code [+o Thalass] by ChanServ |
| 06:32 | | Red_Queen [Z@Nightstar-484uip.cust.comxnet.dk] has quit [[NS] Quit: If the world didn't suck, we'd all fall off.] |
| 06:58 | | Kindamoody[zZz] is now known as Kindamoody |
| 07:01 | | RichyB [RichyB@Nightstar-c6u.vd5.170.83.IP] has quit [[NS] Quit: Gone.] |
| 07:04 | | Erik [8f610223@Nightstar-obfcgl.mibbit.com] has joined #code |
| 07:04 | | RichyB [RichyB@Nightstar-c6u.vd5.170.83.IP] has joined #code |
| 07:11 | | Kindamoody is now known as Kindamoody|out |
| 07:23 | | AverageJoe [evil1@Nightstar-fb1kt4.ph.cox.net] has joined #code |
| 07:25 | | himi [fow035@Nightstar-q9amk4.ffp.csiro.au] has quit [Ping timeout: 121 seconds] |
| 07:44 | | Thalass [thalass@Nightstar-bk3u2d.bigpond.net.au] has quit [[NS] Quit: augh] |
| 08:34 | | AverageJoe [evil1@Nightstar-fb1kt4.ph.cox.net] has quit [[NS] Quit: Leaving] |
| 09:02 | <@Azash> | What does this SQL syntax do? |
| 09:02 | <@Azash> | from A B left join C D |
| 09:02 | <@Azash> | Where A, B, C and D are all tables |
| 09:05 | <~Vornicus> | Make me angry. |
| 09:14 | <@Azash> | Lol'd |
| 09:14 | <@Azash> | But yeah, I'm trying to figure out how it joins them together |
| 09:16 | <~Vornicus> | Okay, looks like "," is simply "inner join", and joins go from left to right, so it's ((A inner join B) left join C) inner join D. |
| 09:18 | <~Vornicus> | ...but left join needs a using/on clause to make any sense, so without that you are getting the cartesian product of the four tables. |
| 09:25 | <@Azash> | Yeah I mean it has other things, but I just kept the key areas |
| 09:25 | <@Azash> | Also that part has no commas |
| 09:25 | <@Azash> | It's just like I wrote it |
| 09:26 | <~Vornicus> | oh lordy. |
| 09:26 | <@Azash> | Is it aliasing? |
| 09:26 | <~Vornicus> | ...oh, perhaps! |
| 09:27 | <~Vornicus> | What sql dialect? |
| 09:27 | <@Azash> | MySQL |
| 09:27 | <~Vornicus> | Okay. |
| 09:28 | <~Vornicus> | Yes, aliases. |
| 09:28 | <~Vornicus> | So it's a basic left join, A and C are hte original table names, B and D are the aliases. |
| 09:30 | <@Azash> | Alright, cheers |
| 09:34 | | Syka [the@Nightstar-p5ku8k.lnk.telstra.net] has joined #code |
| 09:35 | | Syka is now known as NSGuest19658 |
| 10:06 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection closed] |
| 10:18 | | himi [fow035@Nightstar-v37cpe.internode.on.net] has joined #code |
| 10:18 | | mode/#code [+o himi] by ChanServ |
| 10:21 | | Harlow [harlow@Nightstar-9hnfdm.il.comcast.net] has joined #code |
| 10:21 | < [R]> | FYI, non-explicit joins are called implicit joins. The "ON" clause for them is actually in WHERE. |
| 10:25 | | mode/#code [+o RichyB] by ChanServ |
| 10:26 | | NSGuest19658 is now known as Syk |
| 10:46 | < Xon> | [R], even for explcit joins that can be the case |
| 10:49 | | * TheWatcher eyes this requirement |
| 10:49 | <@TheWatcher> | "Show whether entrants have won prizes in previous competitions" |
| 10:49 | <@TheWatcher> | Sure, that'd be easy if we had unique per-entrant accounts |
| 10:50 | | * TheWatcher sighs |
| 10:54 | < Erik> | Obviously your signup doodad must ask entrants if they have won prizes in previous competitions. |
| 10:58 | <@TheWatcher> | Please don't think that too hard |
| 10:59 | <@TheWatcher> | the problem is that we get /teachers/ to sign up for accounts, but when their pupils are submitting entries they enter a code that identifies their teacher, and then just enter their own names. |
| 11:00 | | thalass_ [thalass@Nightstar-bk3u2d.bigpond.net.au] has joined #code |
| 11:02 | < Erik> | Obviously you must change the students' names to GUIDs. |
| 11:05 | <@Tarinaky> | Your name is no longer Erik, it is 0xEEEAF11379 |
| 11:07 | <@Tarinaky> | The sensible course of action is for everyone born in the developped world to be assigned an IPv6 address. |
| 11:08 | | Syk [the@Nightstar-p5ku8k.lnk.telstra.net] has quit [Ping timeout: 121 seconds] |
| 11:08 | | Red_Queen [Z@Nightstar-484uip.cust.comxnet.dk] has joined #code |
| 11:08 | | mode/#code [+o Red_Queen] by ChanServ |
| 11:08 | <@Tarinaky> | Which can be used to uniquely identify their porn habits. |
| 11:11 | <@Tarinaky> | Okay. I'm actually feeling better about the Mid-Project Demo. |
| 11:11 | | Reiv_ [NSwebIRC@Nightstar-q8avec.kinect.net.nz] has quit [Ping timeout: 121 seconds] |
| 11:14 | | himi [fow035@Nightstar-v37cpe.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 11:19 | | Syk [the@Nightstar-ikj.hk5.127.1.IP] has joined #code |
| 11:20 | | Harlow [harlow@Nightstar-9hnfdm.il.comcast.net] has quit [[NS] Quit: Leaving] |
| 11:27 | | himi [fow035@Nightstar-v37cpe.internode.on.net] has joined #code |
| 11:27 | | mode/#code [+o himi] by ChanServ |
| 11:36 | | Syk [the@Nightstar-ikj.hk5.127.1.IP] has quit [Ping timeout: 121 seconds] |
| 11:38 | | Syk [the@Nightstar-ikj.hk5.127.1.IP] has joined #code |
| 11:42 | | Syk [the@Nightstar-ikj.hk5.127.1.IP] has quit [Ping timeout: 121 seconds] |
| 11:47 | | Syka [the@Nightstar-ikj.hk5.127.1.IP] has joined #code |
| 11:48 | | Syka is now known as NSGuest4269 |
| 12:23 | | ErikMesoy [Erik@Nightstar-6v0.mal.203.80.IP] has quit [Ping timeout: 121 seconds] |
| 12:23 | | ErikMesoy [Erik@Nightstar-6v0.mal.203.80.IP] has joined #code |
| 12:25 | | NSGuest4269 [the@Nightstar-ikj.hk5.127.1.IP] has quit [Ping timeout: 121 seconds] |
| 12:31 | | Syka [the@Nightstar-ikj.hk5.127.1.IP] has joined #code |
| 12:32 | < Erik> | That's a new one. List index out of range when asking for element 0. |
| 12:32 | | Syka is now known as NSGuest11905 |
| 12:32 | <@TheWatcher> | ...O.o |
| 12:33 | < [R]> | Using Lua? |
| 12:33 | < Erik> | Python. I'm guessing at an empty list. |
| 12:33 | < [R]> | Ah, yeah |
| 12:34 | < Erik> | Which shouldn't have happened; I'm using an external library to parse an external file. |
| 12:34 | < [R]> | Lua's pretty annoying if you know a bunch of C-like languages :/ |
| 12:34 | < Erik> | Both of these are supposed to be good. |
| 12:36 | < Erik> | I'm trying to get some content out of an Element. Documentation says to use Element.text, which errors "need string or buffer, list found". Trying to get the first element errors "list index out of range". Trying to get at the list with str(element) yields its type as though I were calling type(Element): it's an Element at 0xblahblah. |
| 12:37 | | NSGuest11905 [the@Nightstar-ikj.hk5.127.1.IP] has quit [Ping timeout: 121 seconds] |
| 12:39 | | Syka [the@Nightstar-ikj.hk5.127.1.IP] has joined #code |
| 12:40 | | Syka is now known as NSGuest46853 |
| 14:33 | | Erik [8f610223@Nightstar-obfcgl.mibbit.com] has quit [[NS] Quit: http://www.mibbit.com ajax IRC Client] |
| 14:42 | | iospace is now known as io\interview |
| 15:21 | | You're now known as TheWatcher[afk] |
| 15:39 | <@gnolam> | Qapla'! |
| 15:48 | | NSGuest46853 [the@Nightstar-ikj.hk5.127.1.IP] has quit [[NS] Quit: lol3g] |
| 16:53 | <&ToxicFrog> | [R]: Lua uses 1-indexed lists but there's no such thing as "out of range" unless you're using a custom data type. |
| 17:59 | | Kindamoody|out is now known as Kindamoody |
| 18:10 | | io\interview is now known as iospace |
| 19:26 | | thalass_ [thalass@Nightstar-bk3u2d.bigpond.net.au] has quit [Ping timeout: 121 seconds] |
| 19:28 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
| 19:28 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 19:42 | | Kindamoody is now known as Kindamoody[zZz] |
| 19:43 | | celticminstrel [celticminst@Nightstar-mhtogh.dsl.bell.ca] has joined #code |
| 19:43 | | mode/#code [+o celticminstrel] by ChanServ |
| 21:00 | | Reiver [quassel@Nightstar-ksqup0.co.uk] has quit [Server shutdown] |
| 21:00 | | PinkFreud [WhyNot@NetworkAdministrator.Nightstar.Net] has quit [Server shutdown] |
| 21:00 | | [R] [rstamer@genoce.org] has quit [Server shutdown] |
| 21:00 | | Netsplit *.net <-> *.split quits: ErikMesoy, @Tarinaky, @celticminstrel, @Kindamoody[zZz], @McMartin, mac, Turaiel[Offline], @ToxicFrog |
| 21:00 | | [R] [rstamer@Nightstar-d7h8ki.org] has joined #code |
| 21:01 | | Netsplit over, joins: @Tarinaky, ErikMesoy, mac, @Kindamoody[zZz], Turaiel[Offline], &McMartin, &ToxicFrog, @celticminstrel |
| 21:02 | | mode/#code [+o ErikMesoy] by ChanServ |
| 21:02 | | Reiver [quassel@Nightstar-ksqup0.co.uk] has joined #code |
| 21:02 | | mode/#code [+ao Reiver Reiver] by ChanServ |
| 21:05 | | PinkFreud [WhyNot@Pinkfreud.is.really.fuckin.lame.nightstar.net] has joined #code |
| 21:05 | | mode/#code [+o PinkFreud] by ChanServ |
| 21:22 | | Reiv [NSwebIRC@Nightstar-q8avec.kinect.net.nz] has joined #code |
| 21:22 | | mode/#code [+o Reiv] by ChanServ |
| 21:32 | | Syloq [Syloq@NetworkAdministrator.Nightstar.Net] has quit [Server shutdown] |
| 21:32 | | jeroud [sid10043@Nightstar-a1k27g.irccloud.com] has quit [Server shutdown] |
| 21:32 | | jerith [jerith@ServerAdministrator.Nightstar.Net] has quit [Server shutdown] |
| 21:32 | | Netsplit *.net <-> *.split quits: @Reiv, @ErikMesoy, @Tarinaky, @Reiver, @celticminstrel, @Kindamoody[zZz], @McMartin, mac, Turaiel[Offline], @ToxicFrog, (+1 more, use /NETSPLIT to show all of them) |
| 21:33 | | Syloq [Syloq@Nightstar-mbk.c3p.254.173.IP] has joined #code |
| 21:33 | | Netsplit over, joins: ToxicFrog, mac, McMartin, Tarinaky, ErikMesoy, Kindamoody[zZz], Turaiel[Offline], celticminstrel |
| 21:33 | | jerith [jerith@Nightstar-ngcnma.slipgate.za.net] has joined #code |
| 21:33 | | jeroud [sid10043@Nightstar-a1k27g.irccloud.com] has joined #code |
| 21:33 | | Netsplit over, joins: &Reiver, @PinkFreud, @Reiv |
| 21:33 | | ServerMode/#code [+oooaoaooaooo Tarinaky ErikMesoy Kindamoody[zZz] McMartin McMartin ToxicFrog ToxicFrog celticminstrel Reiver Reiver PinkFreud Reiv] by *.Nightstar.Net |
| 21:42 | | mode/#code [+ao jerith jerith] by ChanServ |
| 21:42 | | mode/#code [+o Syloq] by ChanServ |
| 21:42 | | himi [fow035@Nightstar-v37cpe.internode.on.net] has quit [Ping timeout: 121 seconds] |
| 21:44 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection closed] |
| 21:50 | | HotShot|work [HotShot@Nightstar-v7se27.try.wideopenwest.com] has joined #code |
| 21:57 | | Red_Queen [Z@Nightstar-484uip.cust.comxnet.dk] has quit [Ping timeout: 121 seconds] |
| 21:59 | < HotShot|work> | `commands |
| 22:00 | < HotShot|work> | ' |
| 22:00 | <@Syloq> | Unknown command |
| 22:00 | < HotShot|work> | XD |
| 22:08 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
| 22:10 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [[NS] Quit: Program Shutting down] |
| 22:23 | | VirusJTG [VirusJTG@Nightstar-lsl.j5i.46.174.IP] has joined #code |
| 22:26 | | Turaiel[Offline] is now known as Turaiel |
| 22:44 | | Shiz [mark@Nightstar-3hueb6.shiz.me] has quit [[NS] Quit: v. quit or quit·ted (kwtd), quit·ting, quits: To abandon or put aside; forsake] |
| 22:50 | | ErikMesoy is now known as ErikMesoy|sleep |
| 22:55 | | Vornicus [Vorn@Nightstar-28h42k.sd.cox.net] has joined #code |
| 22:55 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
| 22:56 | | Vornicus [Vorn@Nightstar-28h42k.sd.cox.net] has quit [Connection closed] |
| 23:07 | | VirusJTG [VirusJTG@Nightstar-lsl.j5i.46.174.IP] has quit [Ping timeout: 121 seconds] |
| 23:39 | | HotShot|work [HotShot@Nightstar-v7se27.try.wideopenwest.com] has quit [Connection closed] |
| 23:40 | | HotShot|work [HotShot@Nightstar-v7se27.try.wideopenwest.com] has joined #code |
| 23:51 | | * Reiv stares at a SQL query in mild shock |
| 23:51 | <@Reiv> | ... you can put case statements in a WHERE clause? |
| 23:54 | | HotShot|work [HotShot@Nightstar-v7se27.try.wideopenwest.com] has quit [Connection closed] |
| 23:58 | <@RichyB> | SQL has CASE statements? |
| --- Log closed Wed Mar 19 00:00:16 2014 |