| 00:06.20 | *** part/#uphpu nickdc (~NCrandall@128.187.222.117) |
| 00:08.17 | *** join/#uphpu TuxToaster (~TuxToaste@c-24-10-187-146.hsd1.ut.comcast.net) |
| 00:13.10 | *** part/#uphpu mgeary (~mgeary@66.233.220.188) |
| 00:19.50 | *** join/#uphpu redroy (~Adium@216.51.63.72) |
| 00:22.16 | *** join/#uphpu carmony (~carmony@192.41.96.68) |
| 00:22.16 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 01:07.07 | *** join/#uphpu eggyknap_ (~jtolley@184-11-47-23.dr01.dlta.ut.frontiernet.net) |
| 01:08.43 | *** join/#uphpu noticz (~noticz@192.41.96.68) |
| 01:16.06 | *** join/#uphpu _clint_ (~Adium@c-67-177-57-215.hsd1.ut.comcast.net) |
| 01:18.17 | carmony | $lart FBI |
| 01:18.18 | raifbot | puts FBI through a wood chipper. |
| 01:18.22 | *** join/#uphpu Utah_Dave (~David@192.41.96.68) |
| 01:18.24 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 01:18.42 | *** join/#uphpu carmony (~carmony@192.41.96.68) |
| 01:18.42 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 01:22.52 | linagee | we call him little bobby drop tables |
| 01:22.58 | carmony | lol, yup |
| 01:30.16 | *** join/#uphpu SunSparc (~jonathan@c-67-172-224-227.hsd1.ut.comcast.net) |
| 01:30.16 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 01:30.46 | *** join/#uphpu linagee (~linagee@about/linux/staff/linagee) |
| 01:34.25 | *** join/#uphpu bhosie (~bhosie@c-24-10-247-175.hsd1.ut.comcast.net) |
| 01:41.27 | *** join/#uphpu mindjuju1 (~mindjuju@173-10-26-193-BusName-utah.ut.hfc.comcastbusiness.net) |
| 01:53.27 | *** join/#uphpu bhosie (~bhosie@c-24-10-247-175.hsd1.ut.comcast.net) |
| 01:56.07 | *** join/#uphpu macnewbold (~Adium@192.41.96.68) |
| 01:56.07 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 02:27.02 | *** join/#uphpu skinner (~david@c-71-199-10-91.hsd1.ut.comcast.net) |
| 02:27.08 | *** part/#uphpu skinner (~david@c-71-199-10-91.hsd1.ut.comcast.net) |
| 02:47.00 | *** join/#uphpu jkr801 (~jkr801@c-67-186-196-19.hsd1.ut.comcast.net) |
| 03:41.41 | *** join/#uphpu jtsnow (~jtsnow@75-169-60-127.slkc.qwest.net) |
| 03:59.43 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 04:05.16 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 05:11.15 | *** join/#uphpu ender|a (~ender@c-98-202-87-28.hsd1.ut.comcast.net) |
| 05:57.30 | *** part/#uphpu mindjuju1 (~mindjuju@173-10-26-193-BusName-utah.ut.hfc.comcastbusiness.net) |
| 10:17.02 | *** join/#uphpu tierra (~tierra@2001:470:1f0f:94a::1:2) |
| 12:32.31 | *** join/#uphpu eggyknap (~jtolley@184-11-47-23.dr01.dlta.ut.frontiernet.net) |
| 12:32.31 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 12:32.31 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 12:47.05 | *** join/#uphpu jsmith-away (~jsmith@fedora/jsmith) |
| 12:47.05 | *** mode/#UPHPU [+v jsmith-away] by ChanServ |
| 12:48.04 | *** join/#uphpu jsmith-away (~jsmith@fedora/jsmith) |
| 12:48.04 | *** mode/#UPHPU [+v jsmith-away] by ChanServ |
| 13:58.20 | *** join/#uphpu noticz (~noticz@c-76-23-30-166.hsd1.ut.comcast.net) |
| 14:05.14 | *** join/#uphpu bhosie (~bhosie@208.97.53.253) |
| 14:05.43 | *** join/#uphpu TuxToaster (~TuxToaste@c-24-10-187-146.hsd1.ut.comcast.net) |
| 14:28.46 | *** join/#uphpu macnewbold (~Adium@76.8.223.101) |
| 14:28.46 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 14:30.55 | *** topic/#UPHPU by macnewbold -> UPHPU | Utah PHP Users Group |
| 14:33.53 | *** join/#uphpu macnewbold (~Adium@76.8.223.101) |
| 14:33.53 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 14:35.48 | *** join/#uphpu itimber (~Adium@74.51.216.34) |
| 14:35.48 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 14:42.09 | mindjuju | ~apb eggyknap |
| 14:42.09 | ibot | ACTION calls Duane Lee to spray mace at eggyknap |
| 14:46.40 | macnewbold | ~tlapd |
| 14:46.40 | ibot | i guess tlapd is Talk Like A Pirate Day. Its celebrated each year on Sep. 19. Its TALK like a pirate, not BE like a pirate, Arr! |
| 14:46.55 | *** join/#uphpu skinner (~david@128.187.200.191) |
| 14:47.05 | TuxToaster | lol |
| 14:47.11 | *** topic/#UPHPU by macnewbold -> UPHPU | Utah PHP Users Group | Monday, Sept 19: Talk Like A Pirate Day |
| 14:49.42 | *** join/#uphpu carmony (~carmony@c-24-10-180-216.hsd1.ut.comcast.net) |
| 14:49.56 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 14:57.56 | *** join/#uphpu mgeary (~mgeary@66.233.220.188) |
| 14:57.56 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:02.29 | *** join/#uphpu Monnok (~monnok@205.204.33.82) |
| 15:20.13 | *** join/#uphpu redroy (~Adium@216.51.63.72) |
| 15:26.56 | *** join/#uphpu beandog (~sdibb@gentoo/developer/beandog) |
| 15:26.56 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 15:29.43 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 15:38.46 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 15:43.17 | carmony | gooooooood morning |
| 15:43.37 | *** join/#uphpu carmony (~carmony@c-24-10-180-216.hsd1.ut.comcast.net) |
| 15:43.37 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 15:43.40 | carmony | and good morning again! :P |
| 15:55.54 | *** join/#uphpu fridgesm (~fridgesm_@mycutedressups.dsl.xmission.com) |
| 16:03.04 | influx | mornan |
| 16:04.03 | *** join/#uphpu TuxToaster (~TuxToaste@c-24-10-187-146.hsd1.ut.comcast.net) |
| 16:17.23 | mgeary | can anyone speculate what might be going on with a machine that is completely responsive to web requests, but stalls when I attempt to ssh in? |
| 16:17.47 | *** join/#uphpu jtsnow (~jtsnow@74-95-52-198-Utah.hfc.comcastbusiness.net) |
| 16:17.56 | macnewbold | mgeary: something accessed by your login scripts isn't available? (file mount, etc)? |
| 16:18.13 | mgeary | is there a way to log in and bypass login scripts? |
| 16:24.12 | mindjuju | anybody here using Arch linux? |
| 16:24.29 | mgeary | no, but i've fought an Arch Lich before |
| 16:24.40 | mindjuju | sounds dangerous |
| 16:25.06 | mindjuju | an undead mage is not to be triffiled with |
| 16:26.52 | mgeary | it was long ago. I was young and foolish |
| 16:29.25 | mindjuju | yippee! finally something good in the news! Get a free feelski with every NFL ticket purchase! http://content.usatoday.com/communities/gameon/post/2011/09/nfl-orders-ankles-up-frisks-for-16-million-fans-enterting-stadiums-security-buffalo-bills/1?csp=hf |
| 16:30.14 | mgeary | ~security theater |
| 16:30.21 | mindjuju | well, it seems i'll keep up my trend of never having gone to an NFL game |
| 16:34.32 | ninnypants | mindjuju: same here |
| 16:34.49 | ninnypants | I think I'll refrain from watching too just incase thay have to come search me when I do that as well ;) |
| 16:34.53 | *** join/#uphpu xtrementl (~xtrementl@neutroninteractive-xmission.xmission.com) |
| 16:36.57 | carmony | pic of the day: http://www.makeuseof.com/tech-fun/answering/ |
| 16:44.31 | *** join/#uphpu eggyknap (~jtolley@184-11-47-23.dr01.dlta.ut.frontiernet.net) |
| 16:44.31 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 16:44.31 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 16:49.54 | beandog | mindjuju: a free feelski? |
| 16:51.35 | mindjuju | did you click link? |
| 16:56.21 | *** join/#uphpu erik-v (~erik-v@173-165-132-1-utah.hfc.comcastbusiness.net) |
| 16:57.38 | beandog | I'm good |
| 16:59.55 | ninnypants | the url really says it all |
| 17:01.23 | mindjuju | @ninnypants - i don't people will get it until enhanced pat downs comes to Walmart |
| 17:02.12 | beandog | dude |
| 17:02.16 | beandog | walmart would *never* pay for it. |
| 17:02.18 | ninnypants | mindjuju: is it an enhanced patdown? |
| 17:02.44 | ninnypants | just read in the url that everyone was being frisked |
| 17:02.52 | mindjuju | just a quick google scan of assault in walmart shows several incidents |
| 17:03.04 | mindjuju | here the NFL is taking this course of action based on 1 incident |
| 17:03.33 | mindjuju | @beandog, they'll have the door greeters do it |
| 17:03.41 | mindjuju | ;) |
| 17:04.07 | ninnypants | mindjuju: nah it'll be homeland security and taxpayers will pay for it |
| 17:12.45 | mindjuju | bring it foo |
| 17:13.10 | mindjuju | i'm your huckleberry |
| 17:13.43 | mindjuju | ~bdhit utahcon |
| 17:13.43 | ibot | ACTION gives utahcon the Priest Flip of the Blessed Foulness |
| 17:17.42 | *** join/#uphpu dharmatech (~hayduke@c-98-202-81-152.hsd1.ut.comcast.net) |
| 17:17.42 | *** join/#uphpu dharmatech (~hayduke@drupal.org/user/64968/view) |
| 17:30.00 | ninnypants | mindjuju: are we extending project day to avoid holy war trafic? |
| 17:33.10 | carmony | lol |
| 17:33.21 | carmony | I heard an annoucement on the radio about traffic on saturday |
| 17:33.31 | mindjuju | ninnypants, can't extended, BUT, there are alternatives |
| 17:33.44 | mindjuju | one particular alternative is, oh, i don't know BELIGIAN WAFFLE! |
| 17:33.51 | mindjuju | just saying |
| 17:33.53 | mindjuju | it's close |
| 17:33.56 | mindjuju | it's food |
| 17:33.58 | mindjuju | its yum |
| 17:34.02 | mindjuju | word |
| 17:34.09 | ninnypants | mindjuju: very good idea! |
| 17:34.14 | mindjuju | ;) |
| 17:34.42 | ninnypants | but yeah I don't know that I want to touch that section of freeway until midnight |
| 17:34.58 | jsmith | BELGIAN WAFFLE FOR THE WIN! |
| 17:35.16 | ninnypants | I figure that's when the trafic will die down |
| 17:36.06 | mindjuju | oh wow, game is at 7:15, i bet freeway heading down will be cleared by 8p |
| 17:36.18 | jsmith | mindjuju: You will have them set a plate in my honor at Ye Ole Belgian Waffle, won't you? |
| 17:36.28 | mindjuju | course |
| 17:36.42 | mindjuju | i might even get you a plate of eggs and hash with cholula |
| 17:37.07 | jsmith | Louisiana Red Dot is better... but cholula is a close third |
| 17:37.43 | jsmith | (tapatÃo being the second) |
| 17:38.00 | mindjuju | them are good |
| 17:38.30 | jsmith | M R good.... |
| 17:39.23 | mindjuju | M R Ducks |
| 17:39.46 | ninnypants | mindjuju: probably |
| 17:40.06 | jsmith | C D BD Is? |
| 17:40.07 | mindjuju | we're the same |
| 17:44.17 | *** join/#uphpu _clint_ (~Adium@c-67-177-57-215.hsd1.ut.comcast.net) |
| 17:52.22 | mindjuju | ~apb eggyknap |
| 17:52.23 | ibot | ACTION summons Leland to spray mace at eggyknap |
| 18:03.55 | eggyknap | que? |
| 18:04.42 | mindjuju | te iba ayudarle con (mumble) |
| 18:04.58 | mindjuju | tienes tiempo? |
| 18:05.37 | eggyknap | Seulement si on peut eviter de le faire en espagnole |
| 18:06.38 | mindjuju | you've got me there, can't read it |
| 18:07.01 | eggyknap | It says, in French, "Only if we can avoid doing it in Spanish" |
| 18:07.27 | eggyknap | I couldn't remember how to say such things in Estonian, which would have been far more impressive. But I'm currently listening to a newscast in French, making thinking in Estonian even more difficult than it typically is. |
| 18:07.55 | mindjuju | :) |
| 18:09.41 | eggyknap | That being said, what's "mumble" a placeholder for? |
| 18:10.25 | *** join/#uphpu dharmatech (~hayduke@68.178.116.74) |
| 18:10.25 | *** join/#uphpu dharmatech (~hayduke@drupal.org/user/64968/view) |
| 18:10.37 | mindjuju | did you send me an email to help you get on mumble? |
| 18:10.39 | mindjuju | for the meet tomorrow |
| 18:10.45 | eggyknap | Oh, right... that Mumble. |
| 18:10.54 | eggyknap | Now that you mention it, I did indeed. |
| 18:10.57 | mindjuju | i put it in parenthesis so it wouldn't translate |
| 18:11.01 | mindjuju | but it didn't help |
| 18:11.30 | mindjuju | srry, got to splain something about ssl, brb |
| 18:11.39 | eggyknap | sounds enjoyable </not> |
| 18:14.11 | *** join/#uphpu SunSparc (~jonathan@24-104-129.146.hfc.mediarain.com) |
| 18:14.11 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 18:17.35 | SunSparc | ~friday |
| 18:17.35 | ibot | methinks friday is !!!!!!!! FRIDAY !!!!!!! |
| 18:17.50 | SunSparc | ~rlart |
| 18:17.51 | ibot | hurls dozens of incontinent, insomniac, hungry kittens with tiny little razor-sharp claws and a wide variety of contagious intestinal parasites at sabayonuser |
| 18:25.18 | mindjuju | k, i'm back |
| 18:25.47 | beandog | ~rejoice |
| 18:25.47 | ibot | No, damit!!! |
| 18:26.14 | mindjuju | apparently, the last guy that it would be cool to buy ssl certs individually and to date we've bought 4 and now i'm in the driver seat on this issue, i suggest instead of spending $350 for individual ssl per year, we just buy the wildcard at $200 |
| 18:26.28 | mindjuju | and give the $150 to me |
| 18:27.14 | mindjuju | so eggyknap, do you have mumble installed on your computer? |
| 18:28.17 | beandog | $200? more like $100 |
| 18:29.40 | eggyknap | mindjuju: Ok, installed. |
| 18:47.06 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 18:49.07 | influx | Sleep-Deprived Adventures in SQL |
| 18:49.42 | influx | Episode 1: That one where influx is a dork. |
| 18:50.53 | itimber | I wonder why that payment thing isn't workingâ¦. |
| 18:51.10 | itimber | .. // echo "...about to post payment to this profile...need to finish code...";exit; |
| 18:52.20 | itimber | :) |
| 18:58.17 | influx | :))) |
| 18:58.21 | influx | Dang key. |
| 18:59.33 | *** join/#uphpu josephscott (~josephsco@208.95.152.44) |
| 18:59.33 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 19:10.34 | *** join/#uphpu ninnypants1 (~ninnypant@76.8.192.78) |
| 19:15.29 | *** join/#uphpu ninnypants1 (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 19:17.41 | influx | mindjuju: You might get a kick out of this. http://it.toolbox.com/blogs/securitymonkey/datacenter-good-fire-bad-16332 |
| 19:20.05 | mindjuju | i wonder if he works at rackspace? |
| 19:24.11 | mindjuju | ~influx++ |
| 19:24.36 | mindjuju | this is good and scarely similar as i haven't experienced a fire yet |
| 19:24.51 | mindjuju | though i did have a UPS burn up in the server room, while i was in there (lucky me) |
| 19:25.53 | herlo | that's the life of the sysadmin |
| 19:26.26 | mindjuju | nobody has a key to the server room but me and the owner, so maybe this story of doom won't happen to me |
| 19:34.50 | bhosie | who are these guys? |
| 19:34.58 | bhosie | oops wrong room |
| 19:36.44 | herlo | we are UPHPU! |
| 19:36.46 | herlo | lol |
| 19:37.07 | herlo | mindjuju: only having two people with the key could be a problem in a different direction... |
| 19:37.42 | herlo | single/dual point of failure when something goes down. What if you are out of town, or get hit by a bus, who's covering you?? |
| 19:39.27 | mindjuju | hopefully the paramedic covers me with a sheet if i get hit by a bus |
| 19:39.33 | mindjuju | it's the least he/she could do |
| 19:39.39 | herlo | heh |
| 19:39.48 | herlo | you are funny, sir |
| 19:39.53 | herlo | that was quite the knee slapper |
| 19:39.53 | mindjuju | good point on the key |
| 19:39.58 | herlo | :P |
| 19:41.37 | bhosie | herlo: ha, nice...some dudes from another company just starting shooting hoops on our mini basketball hoop... |
| 19:45.36 | herlo | bhosie: did you challenge them to a slam dunk contest? |
| 19:47.37 | bhosie | herlo: no way, they busted the last hoop dunking :P |
| 19:48.40 | herlo | bhosie: make them pay for it! |
| 19:48.48 | herlo | dunk in their FACES!! |
| 19:49.21 | ender|a | hayo influx ! :) |
| 19:49.50 | mindjuju | anybody want a free copy of the original portal game? |
| 19:49.59 | bhosie | at least we're moving buildings in two weeks! |
| 19:58.07 | bhosie | hey, so anyone know someone looking for work? We need 2 devs, like yesterday. Response has been pretty slim so far..... |
| 19:58.35 | mindjuju | bhoise, contract or full time, and for what skill set? |
| 19:58.42 | mindjuju | and where? |
| 19:58.43 | ninnypants | bhosie: I think influx might be looking |
| 19:58.50 | influx | ender|a: aloha |
| 19:58.58 | bhosie | full time, in orem/canyon park php/jquery/codeigniter |
| 19:59.10 | bhosie | http://grosocial.com |
| 20:00.02 | influx | bhosie: No xp with codeigniter or jquery. Just started reading the documentation on CakePHP yesterday. |
| 20:00.09 | influx | Sorry mayn. |
| 20:00.17 | bhosie | influx: mvc in general? |
| 20:01.16 | influx | Very very very basic. |
| 20:01.23 | mindjuju | i like to MC techno music, do i qualify? |
| 20:01.36 | jtsnow | We are hiring as well in downtown SL... |
| 20:01.45 | mindjuju | k, my jokes aren't funny, i recognize that, i'm going back to work |
| 20:01.47 | bhosie | mindjuju: haha, well, we all hang out in turntable pretty regularly so.... :) |
| 20:01.53 | influx | I'm doing my best to implement it in my own projects from the ground up. |
| 20:02.04 | influx | mindjuju: :D |
| 20:02.11 | influx | jtsnow: O? |
| 20:03.15 | jtsnow | influx: Yup. Looking for front-end devs as well as back-end devs (mostly Drupal work). And we need a sys admin too |
| 20:03.45 | unum | now you tell me :p |
| 20:03.52 | influx | unum: teehee |
| 20:07.18 | jtsnow | http://www.digitaria.com/about/working-here |
| 20:07.57 | influx | oh man. i feel like should have picked up drupal ages ago. |
| 20:09.57 | influx | Well. Bed time. |
| 20:10.46 | ninnypants | ~dub mindjuju qualified |
| 20:11.18 | DexterTheDragon | ~dubstep mindjuju |
| 20:12.55 | ninnypants | mindjuju: have you hung out in the dubstep room of turntable.fm? |
| 20:13.21 | mindjuju | havent yet, it was wanting to snarf up all my fb contacts, etc |
| 20:13.32 | *** join/#uphpu _clint_ (~Adium@c-98-202-218-87.hsd1.ut.comcast.net) |
| 20:19.32 | influx | mindjuju: Word on the stream is you deal in stimulants. |
| 20:19.42 | influx | The street name is "Monster." |
| 20:19.56 | influx | That true? |
| 20:20.58 | mindjuju | if stimulants is a euphamism for technobeats, dat true |
| 20:22.40 | mindjuju | right now, i recomend this http://www.shoutcast.com/shoutcast_popup_player?station_id=1207848&play_status=1&stn=Breaks%20-%20D%20I%20G%20I%20T%20A%20L%20L%20Y%20-%20I%20M%20P%20O%20R%20T... |
| 20:23.13 | mindjuju | ^5 |
| 20:24.48 | herlo | ~tinyurl mindjuju |
| 20:24.48 | ibot | ACTION runs '/exec tinyurl.sh http://maps.google.com//maps/ms?ie=UTF8&addr=mindjuju' and laughs maniacally! |
| 20:25.01 | ninnypants | though it didn't have a no rick/rebecca guarantee attached to it |
| 20:25.21 | mindjuju | wasn't a youtube post |
| 20:25.55 | ninnypants | true but there are non video versions of those songs |
| 20:26.08 | ninnypants | and someone showed us the magic of redirects a while back ;) |
| 20:26.11 | mindjuju | hmm, that gives me an idea |
| 20:37.37 | *** join/#uphpu Monnok (~monnok@205.204.33.82) |
| 21:05.40 | ninnypants | $chuck-fact |
| 21:05.40 | raifbot | Chuck Norriss' calandar goes from march 31st to april 2nd cause nobody fools Chuck Norris |
| 21:06.24 | *** join/#uphpu nickdc (~NCrandall@128.187.220.195) |
| 21:34.16 | *** join/#uphpu fridgesm (~fridgesm_@fridgesm.isyourdaddy.net) |
| 21:55.54 | *** join/#uphpu cro1 (~cro@204-228-149-217.ip.xmission.com) |
| 22:01.10 | *** join/#uphpu cro1 (~cro@204-228-149-217.ip.xmission.com) |
| 22:02.36 | *** part/#uphpu skinner (~david@128.187.200.191) |
| 22:15.05 | *** part/#uphpu nickdc (~NCrandall@128.187.220.195) |
| 22:36.26 | herlo | thoughts on the layout of this blog? http://developmentseed.org/blog/all/ |
| 22:36.28 | herlo | http://developmentseed.org/blog/ |
| 22:51.27 | *** join/#uphpu JacobEdmondKerr (~JacobEdmo@205.204.32.14) |
| 22:55.55 | JacobEdmondKerr | Heres a kinda tuff MySQL question i think. I'm going to try to explain without to much confusion. I want to be able to select everything from a table and also check another table (table2) for value using an index from table1 here's where it get tricky if the select from table 2 returns nothing i want to have something like exist = false return as a column name in the result. Can u do something like that with MySQL? |
| 22:57.00 | jsmith | Sure... |
| 22:57.05 | jsmith | Do a join between your two tables |
| 22:57.15 | jsmith | and learn the difference between a left join and a right join |
| 22:57.25 | jsmith | One will show records only if a value exists in table two |
| 22:57.26 | JacobEdmondKerr | K. |
| 22:57.29 | JacobEdmondKerr | Yeah that makes sense. |
| 22:57.38 | jsmith | The other will show a "null" if nothing exists in table two |
| 22:57.45 | JacobEdmondKerr | then the value will be empty. |
| 22:57.50 | JacobEdmondKerr | K. |
| 22:57.51 | jsmith | No, it will be NULL |
| 22:57.54 | jsmith | There's a difference |
| 22:57.54 | JacobEdmondKerr | Yeah null. |
| 22:58.10 | JacobEdmondKerr | so empty() will not work then. |
| 22:58.13 | jsmith | You job, young grasshopper, is to learn LEFT and RIGHT and INNER and OUTER and SELF joins :-) |
| 22:58.18 | jsmith | Correct |
| 22:58.26 | jsmith | You'll need to use IS NULL or IS NOT NULL |
| 22:58.36 | JacobEdmondKerr | k sweet. |
| 22:59.24 | JacobEdmondKerr | LEFT JOIN takes everything from table1 but not from table2 and RIGHT takes everything from table2 and not table1 or is that wrong? |
| 23:01.43 | jsmith | You're on the right path... |
| 23:01.58 | jsmith | Now check out INNER and OUTER joins |
| 23:02.03 | jsmith | And SELF joins, while you're at it :-) |
| 23:02.04 | *** join/#uphpu cro1 (~cro@204-228-149-217.ip.xmission.com) |
| 23:02.55 | JacobEdmondKerr | Heh. |
| 23:03.15 | mindjuju | so jsmith, what's your opinion on subqueries? |
| 23:03.22 | mindjuju | macnewbold says no good about them |
| 23:03.24 | jsmith | mindjuju: Use joins instead! |
| 23:03.35 | jsmith | mindjuju: (at least, for most situations) |
| 23:03.49 | JacobEdmondKerr | Im just going to start running a bunch a queries an see what happens. |
| 23:03.57 | mindjuju | i could feel that stern look all the way over here on my qq of subqueries |
| 23:04.00 | jsmith | mindjuju: Listen to macnewbold, especially if you value performance |
| 23:04.17 | jsmith | mindjuju: It was a stern but loving look -- really it was |
| 23:05.04 | ninnypants | mindjuju: I advise using only subqueries ;) |
| 23:05.10 | herlo | lol |
| 23:05.16 | herlo | ~mock ninnypants |
| 23:05.16 | ibot | ACTION pulls ninnypants's pants down and shows the world ninnypants's pink spotted underwear |
| 23:05.40 | ninnypants | man those would be some cool underwear |
| 23:05.46 | ninnypants | herlo: you coming to project day? |
| 23:06.45 | herlo | ninnypants: you gotta read my blog more often |
| 23:06.53 | herlo | http://sexysexypenguins.com/ |
| 23:07.04 | ninnypants | herlo: first I gotta read your blog at all :) |
| 23:07.13 | ninnypants | I saw the post but didn't read |
| 23:07.18 | herlo | ninnypants: and the utos planet too |
| 23:07.25 | herlo | http://planet.utos.org/ |
| 23:07.30 | herlo | ninnypants: get on that! |
| 23:08.15 | herlo | hey, ninnypants and mindjuju, whatcha think of this site? http://developmentseed.org/blog/ |
| 23:08.28 | ninnypants | probably should I ned to overhaul my feed reader and get rid of a bunch of stuff |
| 23:08.46 | herlo | ninnypants: indeed |
| 23:09.21 | ninnypants | herlo: looks good |
| 23:09.40 | herlo | ninnypants: I didn't write it |
| 23:10.13 | ninnypants | well I gotta hurry and walk home while the rain is stopped I'll look at it more later |
| 23:10.17 | ninnypants | oh who did? |
| 23:10.18 | herlo | no worries |
| 23:10.34 | herlo | ninnypants: it's a github-pages site, using a tool called jekyll |
| 23:10.47 | herlo | I'm evaluating how to best build the GoOSe Linux project website tonight |
| 23:11.03 | herlo | think I'm gonna got get a whiteboard |
| 23:11.10 | ninnypants | nice |
| 23:11.24 | ninnypants | that's cool github has been doing some awesome stuff |
| 23:11.34 | ninnypants | ok better run ttyl |
| 23:12.43 | *** join/#uphpu beandog (~sdibb@c-71-199-32-42.hsd1.ut.comcast.net) |
| 23:12.43 | *** join/#uphpu beandog (~sdibb@gentoo/developer/beandog) |
| 23:12.43 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 23:21.52 | jsmith | Shoot -- Jabob left right before my instructional pastebin exercise... |
| 23:22.05 | jsmith | Hopefully he figured out what he was looking for |
| 23:23.21 | mindjuju | i'm game |
| 23:23.40 | mindjuju | i could always use a trainer on table joins |
| 23:24.10 | jsmith | mindjuju: OK, I give... |
| 23:24.12 | jsmith | Let's do it! |
| 23:24.20 | mindjuju | in fact, just the other day i had the choice between doing a table join or this crazy long subquery and i chose the subquery |
| 23:24.31 | jsmith | (and pardon in advance for some pasting into the channel) |
| 23:24.51 | jsmith | CREATE TABLE rockstars (star_id int not null auto_increment primary key, star_name varchar(255)); |
| 23:25.09 | jsmith | INSERT INTO rockstars VALUES (DEFAULT,'herlo'); |
| 23:25.18 | jsmith | INSERT INTO rockstars VALUES (DEFAULT,'mindjuju'); |
| 23:25.26 | jsmith | INSERT INTO rockstars VALUES (DEFAULT,'JacobEdmundKerr'); |
| 23:25.37 | jsmith | INSERT INTO rockstars VALUES (DEFAULT,'jsmith'); |
| 23:25.44 | jsmith | With me so far? |
| 23:25.54 | jsmith | Just a simple table, right? |
| 23:25.56 | mindjuju | yup |
| 23:26.17 | jsmith | CREATE TABLE groupie (star_id int NOT NULL, groupie_id int NOT NULL); |
| 23:26.24 | jsmith | another simple table |
| 23:26.28 | jsmith | and now some data |
| 23:26.54 | jsmith | INSERT INTO groupie VALUES (4,2); |
| 23:27.12 | jsmith | INSERT INTO groupie (4,1); |
| 23:27.21 | jsmith | oops, forgot the word VALUES in there |
| 23:27.27 | jsmith | Anyhoo, you get the idea, right? |
| 23:27.33 | jsmith | Now, run this query: |
| 23:27.38 | mindjuju | yup |
| 23:27.46 | jsmith | SELECT rockstars.star_id, star_name, groupie_id FROM rockstars LEFT JOIN groupie ON rockstars.star_id = groupie.star_id; |
| 23:27.48 | jsmith | What do you get? |
| 23:28.25 | jsmith | It should list everyone in the table on the left side of the join, whether or not there's matching data in the right table. |
| 23:28.32 | jsmith | Does that make sense so far? |
| 23:28.37 | mindjuju | yup |
| 23:28.42 | mindjuju | srry, somebody was bugging, but i'm back |
| 23:29.10 | jsmith | No worries... run that query, then change "LEFT JOIN" for "RIGHT JOIN" |
| 23:29.22 | jsmith | While you do that, I'm going to go haul in a 150 pound box from the driveway |
| 23:31.15 | mindjuju | just jsmith |
| 23:31.22 | mindjuju | listed twice |
| 23:32.55 | jsmith | With the RIGHT JOIN, you only get records where the RIGHT table has data that corresponds to the LEFT table |
| 23:33.13 | jsmith | In other words, it doesn't show records where the right table columns would have shown up as NULL |
| 23:33.39 | jsmith | Does that make sense? |
| 23:33.54 | mindjuju | yup |
| 23:34.46 | *** part/#uphpu mgeary (~mgeary@66.233.220.188) |
| 23:34.53 | jsmith | Anyhoo -- I can't tell you how many people I've run into that don't understand JOINs in general, and LEFT AND RIGHT joins in particular |
| 23:35.05 | jsmith | Anyhoo, time for me to stop playing sys-admin and start playing plumber |
| 23:35.17 | jsmith | Have a good evening! |
| 23:35.34 | mindjuju | thx for the refresher, i'm going to play around with inner now |
| 23:35.42 | jsmith | Whee! |
| 23:35.50 | jsmith | Like I said, work your way up to SELF joins |
| 23:36.09 | jsmith | Once you really understand self joins, you'll rarely need a subquery again |
| 23:36.23 | mindjuju | oh, i was just teasing about doing the subquery recently |
| 23:48.07 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |