| 00:17.05 | beandog | nn all |
| 01:11.53 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 01:11.54 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 01:22.20 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 01:22.20 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 01:30.24 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 01:30.24 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 01:30.49 | mindjuju | d00d, stderr |
| 01:30.51 | mindjuju | wth |
| 01:39.36 | *** join/#uphpu justincarmony_ (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net) |
| 01:39.37 | *** mode/#UPHPU [+v justincarmony_] by ChanServ |
| 02:23.07 | *** join/#uphpu justincarmony__ (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net) |
| 02:23.10 | *** mode/#UPHPU [+v justincarmony__] by ChanServ |
| 02:37.44 | *** join/#uphpu utahcon (n=utahcon@li51-147.members.linode.com) |
| 03:19.40 | *** join/#uphpu ChanServ (ChanServ@services.) |
| 03:19.40 | *** join/#uphpu undertakingyou (n=will@undertakingyou.dsl.xmission.com) |
| 03:19.40 | *** join/#uphpu optikal (i=optikal@failcore.com) [NETSPLIT VICTIM] |
| 03:20.22 | *** join/#uphpu burnin (n=burnin@204-228-142-196.ip.xmission.com) [NETSPLIT VICTIM] |
| 03:20.22 | *** mode/#UPHPU [+ovvv ChanServ undertakingyou optikal burnin] by irc.freenode.net |
| 03:20.22 | *** join/#uphpu unum (n=unum@207.192.70.23) |
| 04:25.12 | *** join/#uphpu justincarmony_ (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net) |
| 04:25.13 | *** mode/#UPHPU [+v justincarmony_] by ChanServ |
| 04:45.42 | *** join/#uphpu mjijackson (n=michael@174.52.137.20) |
| 05:46.30 | *** join/#uphpu beandog (n=sdibb@gentoo/developer/beandog) |
| 05:46.30 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 06:27.49 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 06:27.49 | *** join/#uphpu orsonj (n=orson@b22222.bookstore.usu.edu) |
| 06:27.49 | *** mode/#UPHPU [+ov mindjuju orsonj] by irc.freenode.net |
| 06:28.11 | *** join/#uphpu cycokilr (n=cycokilr@216.112.116.6) |
| 06:28.11 | *** join/#uphpu herlo (n=clints@fedora/herlo) |
| 06:28.11 | *** join/#uphpu stderr (n=stderr@truedat.org) |
| 06:28.11 | *** mode/#UPHPU [+v herlo] by irc.freenode.net |
| 07:14.38 | *** join/#uphpu mgeary (n=mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 07:14.39 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 08:05.17 | *** join/#uphpu mgeary (n=mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 08:05.17 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 14:12.55 | *** part/#uphpu Lone_Wanderer (n=Dan@c-67-169-246-153.hsd1.ut.comcast.net) |
| 14:37.13 | *** join/#uphpu jtsnow (n=chatzill@VDSL-151-118-132-71.DNVR.QWEST.NET) |
| 14:55.12 | *** join/#uphpu Utah_Dave (n=David@72.166.51.162) |
| 14:55.13 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 15:18.41 | *** join/#uphpu _psychic_ (n=_psychic@173-8-91-177-Utah.hfc.comcastbusiness.net) |
| 15:18.41 | *** mode/#UPHPU [+v _psychic_] by ChanServ |
| 15:30.07 | *** join/#uphpu justincarmony_ (n=justinca@98.202.44.233) |
| 15:30.07 | *** mode/#UPHPU [+v justincarmony_] by ChanServ |
| 15:33.27 | mindjuju | yo stderr |
| 15:33.49 | mindjuju | wth |
| 16:01.51 | *** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com) |
| 16:01.51 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 16:04.52 | mindjuju | i'm giving this a possibly nsfw, but i don't think it'll be a prob -- Somebody should put up a sign, no breeding in the clock tower -- http://www.mirror.co.uk/news/top-stories/2009/11/24/couple-have-sex-on-clock-tower-in-city-centre-as-shoppers-look-on-pics-115875-21846570/ |
| 16:05.22 | mindjuju | and the follow up article on other curious places people decided it was a great place for whoopie - http://www.mirror.co.uk/news/top-10s/2009/11/25/sex-in-public-the-strangest-places-people-have-been-caught-having-sex-115875-21849159/ |
| 16:05.33 | mindjuju | my fav is The Queen's Lawn |
| 16:05.45 | mindjuju | and on the hood of a cop car, while the cops were inside |
| 16:10.21 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 16:10.22 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 16:20.49 | *** join/#uphpu beandog (n=steve@gentoo/developer/beandog) |
| 16:20.50 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 16:21.34 | beandog | hmm, I got the must be registered to come in here too |
| 16:21.34 | beandog | that was unexpected |
| 16:22.21 | beandog | mindjuju, can you fix that? |
| 16:23.00 | mindjuju | fix what |
| 16:23.04 | mindjuju | sorry, i'm busy now |
| 16:23.08 | mindjuju | coding and... |
| 16:23.12 | mindjuju | watchin 21 jumpstreet |
| 16:23.16 | mindjuju | :) |
| 16:23.32 | beandog | mindjuju, drop the r on the channel settings |
| 16:23.36 | beandog | registered users only |
| 16:26.56 | *** join/#uphpu Utah_Dave (n=David@72-166-51-162.dia.static.qwest.net) |
| 16:26.57 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 16:28.53 | mindjuju | ~apb fungus |
| 16:28.54 | ibot | ACTION hires Dog the Bounty Hunter to rough up fungus |
| 16:31.24 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 16:32.31 | fungus | yes mindjuju. |
| 16:32.40 | fungus | i have been found |
| 16:33.23 | *** mode/#UPHPU [-r] by fungus |
| 16:33.32 | beandog | I wish gmail would automatically put all recepients in bcc when people send it out to 500 people. |
| 16:34.07 | beandog | yay fungus ! |
| 16:35.17 | fungus | easy fix |
| 16:35.31 | beandog | ~fix fungus |
| 16:35.32 | ibot | ACTION opens the hood of fungus , looks inside and says "that'll be 500 dollars." |
| 16:44.07 | *** join/#uphpu jtsnow (n=chatzill@VDSL-151-118-132-71.DNVR.QWEST.NET) |
| 16:46.01 | DexterTheDragon | http://www.youtube.com/watch?v=iDe4v318f64 |
| 16:47.25 | mindjuju | DexterTheDragon - that's awesome! |
| 16:47.57 | DexterTheDragon | checkout the side by side http://www.youtube.com/watch?v=xR4xDeiHrfA |
| 16:49.29 | mgeary | well crud |
| 16:49.41 | mgeary | i've got a bad, very noisy, fan in my MBP |
| 16:49.54 | mgeary | surely not a coincidence that it's like 30 days outside my extended warranty |
| 16:50.56 | DexterTheDragon | just kick it |
| 16:51.10 | *** join/#uphpu cro (n=cro@166-70-222-105.ip.xmission.com) |
| 16:51.21 | mgeary | tempted |
| 16:51.40 | mindjuju | mgeary, don't sweat it, i've got a couple laptops, i might could spot you one for a little while |
| 16:51.48 | mindjuju | it's the one that fungus always makes fun of |
| 16:51.56 | mindjuju | just because it weighs 10 lbs |
| 16:52.20 | mgeary | ~decline mindjuju |
| 17:11.32 | *** join/#uphpu redroy (n=Adium@66.60.105.178) |
| 17:14.46 | justincarmony_ | awesome DexterTheDragon |
| 17:28.00 | *** join/#uphpu Lone_Wanderer (n=Dan@c-67-169-246-153.hsd1.ut.comcast.net) |
| 17:28.01 | *** mode/#UPHPU [+v Lone_Wanderer] by ChanServ |
| 17:35.10 | Dezertol | just a neat radio tool I found -> http://www.radio-locator.com/ |
| 17:35.50 | Dezertol | a lot of the radio stations now-a-days stream so.. |
| 17:35.58 | Dezertol | if you like me and from AZ you can listen to some of there radio stations |
| 18:01.27 | *** join/#uphpu cro (n=cro@70.90.213.14) |
| 18:02.18 | *** part/#uphpu cro (n=cro@70.90.213.14) |
| 18:10.21 | brasto | ~rlart |
| 18:10.22 | ibot | shoots cycokilr in his sleep |
| 18:11.00 | mgeary | so violent |
| 18:19.13 | cycokilr | i ducked.. |
| 18:20.42 | DexterTheDragon | antelope drive has quite a few places to eat |
| 18:20.48 | DexterTheDragon | wrong window |
| 18:22.07 | *** join/#uphpu thebigdog (n=thebigdo@dsl093-228-015.slc1.dsl.speakeasy.net) |
| 18:22.08 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 18:24.53 | thebigdog | oh come on now |
| 18:24.55 | thebigdog | hehe |
| 18:25.22 | Dezertol | http://www.neatorama.com/2009/11/20/bacon-mug/ |
| 18:25.37 | Dezertol | how does one define "to much spare time" |
| 18:27.09 | thebigdog | that is awesome |
| 18:27.42 | thebigdog | http://thisiswhyyourefat.com/ i love that site |
| 18:29.29 | Dezertol | wow |
| 18:29.41 | Dezertol | is it sad that I've eaten like half them things ... just this week |
| 18:29.52 | Dezertol | j/k |
| 18:30.31 | wps | nasty! http://thisiswhyyourefat.com/post/232110503/spaghetti-meatballs-loaf-spaghetti-meatballs |
| 18:30.38 | Dezertol | http://s3.amazonaws.com/data.tumblr.com/i2dw5nf19or3u7rq5OkGa1xho1_1280.jpg?AWSAccessKeyId=0RYTHV9YYQ4W5Q3HQMG2&Expires=1259260225&Signature=GMFGhm4jxzJKvQ44YuTDyhifhfM%3D |
| 18:30.44 | Dezertol | wow.. the stake0nator |
| 18:30.46 | Dezertol | mmmm |
| 18:31.46 | brasto | cycokilr: you ducked in your sleep? Only a psycho killer could have reflexes like that... |
| 18:31.56 | Dezertol | ew.. some of them do not look good at all |
| 18:32.54 | Dezertol | http://thisiswhyyourefat.com/post/221924416/twinkie-sushi-via-cuisinetc |
| 18:33.05 | Dezertol | ok that one is the only way to eat sushi ;-) |
| 18:33.37 | Dezertol | tho.. I do enjoy a good California role from time to time... |
| 18:42.56 | thebigdog | wps that is not too bad...search for the 2 tombstone pizza one and that will kill you |
| 18:43.53 | thebigdog | that twinki sushi is awesome |
| 18:43.57 | thebigdog | kids would love that |
| 18:50.52 | thebigdog | here it is - the widow maker - http://thisiswhyyourefat.com/page/7 |
| 18:51.17 | thebigdog | http://thisiswhyyourefat.com/post/198376576/the-widowmaker-1-5-lbs-of-ground-beef-1-package |
| 18:51.21 | thebigdog | that is the direct link |
| 18:51.55 | thebigdog | this one looks great to make - http://thisiswhyyourefat.com/post/212954411/el-nino-ground-beef-sauteed-onions-sour-cream |
| 18:51.59 | thebigdog | el nino |
| 18:53.42 | *** join/#uphpu bigdog_ut (n=thebigdo@dsl093-228-015.slc1.dsl.speakeasy.net) |
| 18:53.43 | *** mode/#UPHPU [+o bigdog_ut] by ChanServ |
| 19:03.19 | *** join/#uphpu aiyu (n=ansuampa@117.206.16.79) |
| 19:03.26 | *** part/#uphpu aiyu (n=ansuampa@117.206.16.79) |
| 19:03.27 | *** join/#uphpu aiyu (n=ansuampa@117.206.16.79) |
| 19:03.53 | aiyu | hii utah php group, anybody has php manual in pdf format |
| 19:05.45 | fungus | no, but you can get the official docs downloaded in one package. |
| 19:05.45 | fungus | http://www.php.net/download-docs.php |
| 19:06.31 | aiyu | i want to have a printable version |
| 19:07.21 | cycokilr | download the single html file and print/save it as a pdf.. |
| 19:07.31 | wps | http://www.dcc.fc.up.pt/~pbrandao/aulas/0203/bdm/docs/php_manual_en.pdf |
| 19:08.07 | cycokilr | and btw, you can print html pages ;) |
| 19:08.50 | aiyu | @wps, for which version? |
| 19:08.50 | wps | found via google "php manual pdf" |
| 19:09.08 | aiyu | might be for php3 |
| 19:09.11 | aiyu | i have that |
| 19:09.25 | aiyu | its almost impossible to have for php5 |
| 19:09.35 | wps | why? |
| 19:09.51 | aiyu | just coz i cant find one. :) |
| 19:10.16 | aiyu | i've been searching for 2 weeks |
| 19:10.29 | aiyu | now i am in irc for a pdf |
| 19:10.30 | wps | that pdf has 4 in itâ¦Â I'm scanning, but I don't see any 5 |
| 19:10.49 | wps | why do you want to print it out? seems like a big waste of paper |
| 19:10.53 | aiyu | 4 is also satisfactory, u scored over me |
| 19:10.54 | aiyu | :) |
| 19:12.34 | mindjuju | oh gods of logic and reason; PLEASE imbue my coworkers with your grace! |
| 19:12.41 | aiyu | actually, i am a cyber wanderer , hard to sit and read from screen |
| 19:12.52 | optikal | DENIED |
| 19:12.57 | aiyu | lol |
| 19:13.13 | mindjuju | optikal, i'm speechless |
| 19:13.14 | optikal | I pray that same thing every day, and they deny it every time. :( |
| 19:13.46 | cycokilr | roger that |
| 19:14.48 | mindjuju | the marketing director asked for a video to be produced, we just got it in from the person who made it (who isn't very good at it yet) and the md asks me to put it on the website |
| 19:14.52 | mindjuju | without listening to it |
| 19:15.22 | mindjuju | and me, because I care about our company image, asked her to my office in the first place so i could voice some concerns |
| 19:15.42 | mindjuju | oh, i don't know, because you can't hear whats being said because the freakin background music is LOUDER than what is being talked about |
| 19:16.02 | fungus | marketing people don't care about how it works, they just want it there fast. |
| 19:16.15 | fungus | But, if you comply, then they get pissed cause it sucks. |
| 19:16.23 | mindjuju | EXACTLY |
| 19:16.33 | mindjuju | i hate doing work for this person cause it has to be done like 5x |
| 19:16.43 | mindjuju | oh, i didn't see this,or didn't think of that |
| 19:16.47 | mindjuju | drives me nuts |
| 19:17.28 | fungus | ~lart marketing people |
| 19:17.28 | ibot | hooks into a hydrant and hoses marketing people down |
| 19:17.50 | tierra | heh, that's exactly what I've been dealing with the last couple weeks... |
| 19:18.09 | tierra | so frustrating |
| 19:18.42 | mindjuju | i think we should riot |
| 19:19.40 | *** join/#uphpu burnin (n=burnin@204-228-142-196.ip.xmission.com) [NETSPLIT VICTIM] |
| 19:19.40 | *** join/#uphpu undertak1ngyou (n=will@undertakingyou.dsl.xmission.com) |
| 19:19.40 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 19:19.58 | *** join/#uphpu optikal (i=optikal@70.85.16.213) [NETSPLIT VICTIM] |
| 19:20.02 | *** mode/#UPHPU [+v optikal] by ChanServ |
| 19:20.12 | DexterTheDragon | alert the guild, we're going on strike |
| 19:20.32 | fungus | i'm lucky in that my boss and his boss keep tight reigns on marketing's requests on me. |
| 19:22.07 | mindjuju | i'm having a sudden urge to randomly kick people in the shins |
| 19:22.12 | mindjuju | to top this marketing thoughtlessness off |
| 19:22.21 | mindjuju | I get a call from a lawyer last night |
| 19:22.23 | optikal | mindjuju: Yeah. Drives me nuts when they come to you with action items before they've properly specs out and brainstormed the idea thoroughly. Then it gets changed 20x during your course of action, and in the end you've done 3x the work. |
| 19:22.32 | mindjuju | it seems that he wasts to answer the question i called him about |
| 19:22.38 | mindjuju | 4 MONTHS AGO |
| 19:22.44 | mindjuju | WTH |
| 19:22.59 | mindjuju | i called a handful of attorneys and got my answer and stuff worked out |
| 19:23.13 | mindjuju | one of the ones that never called back up decides to call me back |
| 19:23.20 | mindjuju | d00d, IT'S BEEN 4 FREAKIN' MONTHS |
| 19:23.48 | mindjuju | optikal, story of my life here |
| 19:40.40 | *** join/#uphpu beandog (n=steve@67.214.233.82) |
| 19:40.42 | *** mode/#UPHPU [+v beandog] by ChanServ |
| 19:41.08 | beandog | yo har |
| 19:42.11 | beandog | ~seen sunsparc |
| 19:42.14 | ibot | sunsparc <n=sparky@173-8-91-177-Utah.hfc.comcastbusiness.net> was last seen on IRC in channel #uphpu, 5d 16h 1m ago, saying: 'Interesting MTA comparison -> http://shearer.org/MTA_Comparison'. |
| 19:45.43 | mindjuju | that remids me, wheres stderr |
| 19:45.47 | mindjuju | ~seen stderr |
| 19:45.48 | ibot | stderr is currently on #utos (13h 17m 37s) #uphpu (13h 17m 37s), last said: 'mutt + vim bindings mmm'. |
| 19:46.57 | stderr | mindjuju: sup mayn |
| 19:47.17 | mindjuju | dude, saw your news on FB |
| 19:47.27 | mindjuju | congrats |
| 19:47.30 | stderr | :) |
| 19:47.36 | stderr | Thank you, I appreciate the good wishes. |
| 19:47.59 | mindjuju | i been dying to tell these guys, but good manners dictate that you say it |
| 19:48.07 | beandog | what news? |
| 19:50.09 | stderr | ah, Rachel and I are engaged. |
| 19:50.34 | mindjuju | :) |
| 19:50.51 | mindjuju | have ya'll set a day? |
| 19:52.07 | stderr | not yet, we're thinking early June. |
| 19:52.14 | mgeary | "not engaged without a ring and a date", they say ;) |
| 19:52.40 | stderr | hehe |
| 19:52.48 | mindjuju | congrats bro, prolly best news i've heard this week and last |
| 19:52.52 | mgeary | but congratulations nonetheless ;) |
| 19:53.15 | stderr | thanks guys :) |
| 19:55.33 | Lone_Wanderer | nice, grats Josh |
| 19:56.12 | stderr | thanks man, you still in SLC? |
| 19:56.19 | Lone_Wanderer | Orem, but yeah |
| 19:56.35 | stderr | I think a bunch of us are going to The Republican tonight if'n you wanted to hang. |
| 19:56.41 | Utah_Dave | congrats, stderr! |
| 19:56.43 | Lone_Wanderer | sure |
| 19:56.53 | stderr | (I have a bed you could pass out on if you don't want to head all the way back to Orem) |
| 19:56.57 | stderr | Utah_Dave: thanks man! |
| 19:56.58 | Lone_Wanderer | that'd be good |
| 19:57.17 | Lone_Wanderer | any specific time? |
| 19:58.21 | Utah_Dave | stderr: Here's my only bit of unsolicited advice: Buy everything you think you might want right now! |
| 19:58.24 | Utah_Dave | :) |
| 19:58.42 | beandog | stderr, congrats man |
| 19:58.47 | beandog | is she hawt? |
| 19:59.27 | stderr | Lone_Wanderer: ummm, lemme let you know |
| 19:59.30 | Lone_Wanderer | k |
| 19:59.33 | stderr | beandog: Indeed she is! |
| 19:59.34 | Lone_Wanderer | you have my number? |
| 19:59.42 | Lone_Wanderer | beandog: I've met her, she's super hot |
| 20:00.40 | stderr | Lone_Wanderer: I believe so. |
| 20:00.44 | Lone_Wanderer | k |
| 20:00.47 | stderr | ends with a 211? |
| 20:00.55 | Lone_Wanderer | yeah |
| 20:01.00 | stderr | word. |
| 20:01.24 | beandog | stderr, right on bro, congrats |
| 20:01.32 | stderr | thank ye sir |
| 20:01.46 | beandog | if it doesnt work out, can I date her? |
| 20:02.28 | Lone_Wanderer | (I recommend the redhead, she's *really* good at at least two things.) |
| 20:02.59 | stderr | beandog: http://photos-h.ak.fbcdn.net/hphotos-ak-snc1/hs190.snc1/6368_1121021543808_1175145775_30304104_3901766_n.jpg |
| 20:03.01 | beandog | ah dangit! |
| 20:03.08 | beandog | I waited 2 minutes and I missed all the amazon game deals. |
| 20:03.20 | beandog | stderr, I approve |
| 20:04.05 | DexterTheDragon | beandog: was there anything good? |
| 20:04.17 | stderr | you guys play Dragon Age yet? |
| 20:04.25 | beandog | DexterTheDragon, no |
| 20:04.26 | beandog | heh |
| 20:04.32 | beandog | stderr, I *just* got mine yesterday |
| 20:04.41 | beandog | gonna play it tonight / all weekend |
| 20:04.51 | beandog | is this any good? $10 |
| 20:04.52 | beandog | http://www.amazon.com/Rayman-Raving-Rabbids-Nintendo-Wii/dp/B000GEDN5E |
| 20:05.05 | stderr | man it's great, you're going to love it. |
| 20:05.11 | stderr | I'm replaying it for the second time right now |
| 20:05.19 | stderr | getting slowed up by hot MW2 PS3 action |
| 20:05.32 | beandog | stderr, MW2? |
| 20:05.49 | beandog | stderr, I've heard it is kind of like what KOTOR2 would have been like if Bioware made it |
| 20:05.50 | mindjuju | modern warfare 2 |
| 20:05.52 | mindjuju | methinks |
| 20:06.00 | beandog | minus the lightsabers. |
| 20:06.19 | stderr | yea, Modern Warfare 2. |
| 20:07.20 | Lone_Wanderer | Is it wrong that I feel cool for being on a mailing list where I just read the sentence "even those codes do a lousy job e.g. for heavy atoms which have relativistic effects" ? |
| 20:07.48 | Lone_Wanderer | I didn't know relativity applied at the atomic scale |
| 20:08.08 | *** join/#uphpu romanovic (n=mclark@216.112.117.10.ptr.us.xo.net) |
| 20:09.13 | *** join/#uphpu eco (n=eco@gnuk.net) |
| 20:09.13 | *** mode/#UPHPU [+v eco] by ChanServ |
| 20:13.26 | mindjuju | ok, i need some sql help. I have a table that records when clients hit particular resources over the entire website. this means that the table has several records of client A hiting resource 1, 2 and 3. what I want is the latest 100 unique client / event records. by that i mean, i just want to have the latest record of client A hiting resource whatever, then no longer showing any more hits by client A |
| 20:13.39 | mindjuju | and I'd like to do this all in 1 query |
| 20:13.43 | mindjuju | :) |
| 20:14.03 | mindjuju | i've tried left joins, inner joins and i'm pushing into subqueries |
| 20:14.42 | mindjuju | i just can't seem to find a way to make it so i don't have 100 lookups |
| 20:15.00 | beandog | can we see the query? |
| 20:15.26 | mindjuju | yeah, i'll sanitize it and pastebin it |
| 20:15.30 | mindjuju | uno momento por favor |
| 20:15.49 | beandog | while we're waiting, we'll just look at the picture of stderr's fiancee again |
| 20:18.38 | mindjuju | k, here it is, http://www.pastebin.ca/1687252 |
| 20:19.04 | mindjuju | the reason that doesn't work is because I think the distinct is pulling back all distinct records, not distinct to the fld_clientID col |
| 20:19.24 | mindjuju | which is why i then turned to subquery |
| 20:19.41 | mindjuju | and maybe i should sweat doing 100 lookups ?? |
| 20:19.54 | mindjuju | i'm always trying to minimize the impact to the database through good queries |
| 20:19.57 | beandog | TOP? |
| 20:20.01 | beandog | are you using mssql? |
| 20:20.05 | mindjuju | shhhh |
| 20:20.13 | romanovic | haha |
| 20:20.13 | mindjuju | don't say that too loud or nobody will help |
| 20:20.19 | mindjuju | shhh |
| 20:20.22 | beandog | srsly, I was gonna say, count me out |
| 20:20.31 | mindjuju | come on! |
| 20:21.06 | beandog | I dunno anyway |
| 20:21.16 | mindjuju | ...sigh... |
| 20:21.16 | beandog | looks fine |
| 20:21.33 | mindjuju | well, it is fine, i mean it works, it just isn't what i need |
| 20:21.49 | mindjuju | utah_dave |
| 20:21.55 | mindjuju | your sql guru |
| 20:22.02 | mindjuju | is thebigdog still here? |
| 20:22.23 | romanovic | so if client A accessed resource 1 once, and resource 2 50 times, you want it to return 2 records? |
| 20:22.41 | mindjuju | i actually only want 1 record |
| 20:22.50 | mindjuju | client A hit a resource on this day and time |
| 20:23.15 | jtsnow | mindjuju: don't you want to group by client ID? |
| 20:23.42 | mindjuju | i thoguht that too, but it didn't seem to be getting what I needed |
| 20:25.50 | *** join/#uphpu thebigdog (n=thebigdo@dsl093-228-015.slc1.dsl.speakeasy.net) |
| 20:25.51 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 20:27.04 | mindjuju | ~seen eggyknap |
| 20:27.06 | ibot | eggyknap is currently on #utos (22h 4m 56s) #udbug (22h 4m 56s) #utah (22h 4m 56s), last said: 'synic: pong'. |
| 20:28.26 | *** part/#uphpu aiyu (n=ansuampa@117.206.16.79) |
| 20:30.08 | jtsnow | mindjuju: http://www.pastebin.ca/1687264 |
| 20:30.23 | jtsnow | that would be my guess |
| 20:30.57 | jtsnow | should probably be DESC on the order by though |
| 20:31.15 | romanovic | jtsnow, does limit keyword work in mssql? |
| 20:31.29 | romanovic | (honestly asking - i'm not well versed in mssql) |
| 20:32.18 | fungus | lol |
| 20:32.18 | jtsnow | ah, I missed that |
| 20:32.19 | fungus | http://www.huffingtonpost.com/2009/11/24/petas-thanksgiving-turkey_n_368793.html |
| 20:32.20 | jtsnow | doh |
| 20:32.29 | *** join/#uphpu JacobEdmondKerrU (n=JacobEdm@67.41.175.171) |
| 20:32.56 | Utah_Dave | sup, mindjuju? |
| 20:33.09 | mindjuju | romanovic - it doesn't, but i know how to translate |
| 20:33.17 | jtsnow | top is equivelent to limit |
| 20:33.22 | JacobEdmondKerrU | I'm reading a bit on PHP5 classes and I found something I did not know about which I think is AWSOME! ( __autoload($class) ) |
| 20:33.27 | mindjuju | hi utah_Dave, romanovic is suggesting some things, but i was having an error |
| 20:33.37 | mindjuju | wondering how to do somethign sql |
| 20:33.40 | romanovic | mindjuju, if you weren't limiting to 100, i would think to use SELECT DISTINCT fld_clientID FROM ... |
| 20:34.31 | mindjuju | hmmm, now that i see your approach, i've tried that one before |
| 20:34.50 | mindjuju | i get an error saying its not conatined in the aggregate function |
| 20:34.56 | mindjuju | utah_dave, do you do ms sql? |
| 20:35.02 | romanovic | maybe not exactly that way, but specifying the column that needs to be distinct |
| 20:35.35 | mindjuju | well, since i only need 1 record of each client, limiting on the clientID achieves that |
| 20:36.37 | Utah_Dave | nope, sorry, mindjuju. |
| 20:37.23 | Utah_Dave | Every time I have to deal with ms sql I have it dump everything to a MySQL server |
| 20:37.41 | mindjuju | i'm headed in that direction, just not today |
| 20:37.43 | mindjuju | :( |
| 20:38.40 | mindjuju | <PROTECTED> |
| 20:40.03 | Utah_Dave | ~dump ms sql |
| 20:44.24 | mgeary | Utah_Dave: do you have an easy way to do that? I've found it quite cumbersome in the past |
| 20:54.03 | romanovic | mindjuju: might the max function help? |
| 20:54.37 | Utah_Dave | mgeary: I just install the mysql connector on the ms sql machine. |
| 20:54.49 | romanovic | something like this? http://www.pastebin.ca/1687285 |
| 20:55.14 | Utah_Dave | Then in Enterprise Manager I set up a job to export everything. It's pretty easy |
| 20:55.54 | Utah_Dave | We did have to figure out what mysql datatypes best fit, but it works. We have an automatic job run every night that does it. |
| 21:00.14 | *** join/#uphpu burnin_ (n=burnin@204-228-142-196.ip.xmission.com) |
| 21:12.44 | JacobEdmondKerrU | for($i=0; $i>=$myCoolness; $i++){//code} This is an infinite loop correct?? |
| 21:12.58 | JacobEdmondKerrU | Teehee. |
| 21:13.21 | fungus | nope, only runs once. |
| 21:13.25 | fungus | ;) |
| 21:13.28 | JacobEdmondKerrU | LOL.. |
| 21:13.28 | *** join/#uphpu burnin (n=burnin@204-228-142-196.ip.xmission.com) |
| 21:13.29 | *** mode/#UPHPU [+v burnin] by ChanServ |
| 21:15.45 | *** part/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 21:29.47 | *** part/#uphpu Utah_Dave (n=David@72-166-51-162.dia.static.qwest.net) |
| 21:38.28 | mindjuju | this looks awesome - http://www.apple.com/trailers/fox/familyguysomethingsomethingsomethingdarkside/ |
| 21:57.25 | cycokilr | http://woodenpickle.com/misc/PHP-Manual-EN_20NOV2009.pdf.bz2 <-- in case anyone wants an updated PDF of the PHP manual.. |
| 21:57.29 | cycokilr | just made it myself.. |
| 21:57.45 | DexterTheDragon | someones a go getter |
| 21:58.14 | cycokilr | well, started it an hour ago.. took a while on my computer.. which is kinda strange (dual quad-core w/ 16gb ram).. |
| 21:58.15 | cycokilr | oh well |
| 21:59.47 | cycokilr | too bad that aiuy guy split.. guess he'll just have to keep looking around.. |
| 22:07.30 | DexterTheDragon | for all the web developers http://www.youtube.com/watch?v=vTTzwJsHpU8 |
| 22:11.10 | herlo | DexterTheDragon: vry nice |
| 22:18.38 | beandog | red hat is confusing. |
| 22:18.52 | beandog | why can't they just be cool like gentoo? |
| 22:21.57 | *** join/#uphpu justincarmony_ (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net) |
| 22:21.57 | *** mode/#UPHPU [+v justincarmony_] by ChanServ |
| 22:26.17 | cycokilr | http://eatingtheroad.files.wordpress.com/2009/11/where-to-eat-cereal1.jpg |
| 22:26.44 | cycokilr | they should just all be like SuSE.. |
| 22:28.30 | cycokilr | wow, i'm glad i don't work with that guy.. if he started up i'd probably have to punch him.. |
| 22:29.17 | *** join/#uphpu mindjuju (n=mindjuju@mail.billgood.us) |
| 22:29.17 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 22:31.08 | mindjuju | i love how IE 9 has been in development for 2 weeks, and already it has screaming fast JS processing |
| 22:33.56 | mindjuju | language warning |
| 22:34.11 | *** join/#uphpu Jacolyte (n=blaine@unaffiliated/jacolyte) |
| 22:45.13 | *** join/#uphpu swb (n=sheri@static-64-22-40-34.albyny.csvoip.net) |
| 22:45.14 | *** mode/#UPHPU [+v swb] by ChanServ |
| 23:09.18 | *** join/#uphpu brasto (n=brasto@98.202.14.89) |
| 23:09.19 | *** mode/#UPHPU [+v brasto] by ChanServ |
