IRC log for #uphpu on 20090424

00:24.22*** join/#uphpu wps (n=wps@208.53.47.251)
00:24.22*** mode/#UPHPU [+o wps] by ChanServ
00:25.00*** join/#uphpu Utah_Dave (n=boucha@c-67-172-225-101.hsd1.ut.comcast.net)
00:25.00*** mode/#UPHPU [+o Utah_Dave] by ChanServ
00:32.34*** part/#uphpu Utah_Dave (n=boucha@c-67-172-225-101.hsd1.ut.comcast.net)
01:04.04*** join/#uphpu Utah_Dave (n=boucha@c-67-172-225-101.hsd1.ut.comcast.net)
01:04.04*** mode/#UPHPU [+o Utah_Dave] by ChanServ
01:04.06*** join/#uphpu olds (i=olds@siren.zzq.org) [NETSPLIT VICTIM]
01:04.06*** join/#uphpu unum (n=unum@li32-23.members.linode.com)
01:04.06*** mode/#UPHPU [+vv olds unum] by irc.freenode.net
01:19.57*** join/#uphpu Utah_Dave (n=boucha@c-67-172-225-101.hsd1.ut.comcast.net)
01:19.57*** mode/#UPHPU [+o Utah_Dave] by ChanServ
02:27.38*** join/#uphpu Utah_Dave (n=boucha@c-67-172-225-101.hsd1.ut.comcast.net)
02:27.38*** mode/#UPHPU [+o Utah_Dave] by ChanServ
03:40.18*** join/#uphpu mgeary (n=mgeary@69.169.142.45.provo.static.broadweave.net)
03:40.18*** mode/#UPHPU [+v mgeary] by ChanServ
03:46.50*** join/#uphpu mastergunns (n=mastergu@c-67-186-231-121.hsd1.ut.comcast.net)
04:04.50*** join/#uphpu supernovia (n=Velda@c-67-164-250-20.hsd1.ut.comcast.net)
04:15.29*** join/#uphpu whiteinge (n=whiteing@whiteinge.dsl.xmission.com)
05:56.51*** part/#uphpu mastergunns (n=mastergu@c-67-186-231-121.hsd1.ut.comcast.net)
13:57.24*** join/#uphpu utahcon (n=utahcon@bromine.sosstaffing.com)
13:59.49*** join/#uphpu mgeary (n=mgeary@69.169.142.45.provo.static.broadweave.net)
13:59.49*** mode/#UPHPU [+v mgeary] by ChanServ
14:14.46*** join/#uphpu cro (n=cro@166-70-222-105.ip.xmission.com)
14:42.34*** join/#uphpu orsonj (n=orson@b22222.bookstore.usu.edu)
14:42.34*** mode/#UPHPU [+v orsonj] by ChanServ
14:48.49*** join/#uphpu _psychic_ (n=_psychic@173.8.91.177)
14:48.49*** mode/#UPHPU [+v _psychic_] by ChanServ
14:58.29*** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com)
14:58.29*** mode/#UPHPU [+o fungus] by ChanServ
15:23.24*** join/#uphpu josephscott (n=josephsc@75-169-240-226.slkc.qwest.net)
15:23.24*** mode/#UPHPU [+v josephscott] by ChanServ
15:25.22*** join/#uphpu itimber (n=itimber@c-98-202-102-189.hsd1.ut.comcast.net)
15:25.22*** mode/#UPHPU [+v itimber] by ChanServ
15:25.35_carmonyGood morning :)
15:28.25utahcon~lart _carmony
15:28.25ibotpours gasoline all over _carmony, ignites the fire, and then enjoys some toasty marshmallows with the glorious blaze
15:28.36itimbersup guys
15:33.20utahconnice
15:33.24utahconstoring dead bodies?
15:38.46*** join/#uphpu thebigdog (n=thebigdo@70.103.91.98)
15:38.46*** mode/#UPHPU [+o thebigdog] by ChanServ
15:41.51fungus_carmony, are they cute black guys you want to eat later.
15:42.52*** join/#uphpu SunSparc (n=sparky@173.8.91.177)
15:42.52*** mode/#UPHPU [+v SunSparc] by ChanServ
15:49.58thebigdognow that was a statement fungus
15:50.32croHe means black JELLY BEANS
15:50.46crothe Jelly Belly kind, small, cute, flavorful
15:50.47fungusheh you missed the previous conversation
15:50.54fungus* _carmony just bought a freezer
15:50.55fungus<utahcon> nice
15:50.55fungus<PROTECTED>
15:51.12thebigdogi just thought that was really crazy statement
15:51.25fungushehe
15:52.17_carmonylol
15:52.20_carmonyRC WIlley
15:52.26_carmonyhad a morning sale
15:52.29unumso I have another sql question(suprise, suprise)
15:53.19fungusI have a sql answer, let's see if they match
15:53.24unumsweet
15:53.27fungusSELECT 20 + 22
15:53.32unumdarn
15:53.49unumi got caught up in reading the backlog
15:54.38unumso let's say I have a table with two time stamps per row.  And I want to know if those times over lap with other rows in the table
15:54.49unumso I have an in time and an out time
15:55.07unumand I want to know if my in and out times over over lap in in the table
15:55.12unumhow would you do that
15:55.16crounum: is this MySQL?
15:55.25unumcro: no pgsql
15:55.45crounum: I'd write a stored procedure
15:56.23crolet me think...
15:57.02unumwith that I could even set it up to check for that on the insert couldn't I
15:57.58croyeah
15:58.08croso is this a constraint?
15:58.17crono rows in the table with overlapping timestamps?
15:58.20unumit should be :)
15:58.32unumwell it will be based of an other value
15:58.37unumthis is a timecard
15:58.42croMy Pg is a little rusty...
15:58.43unumso no one can be clocked in twice
15:59.18croyou could do it as a subselect
16:02.13croActually, all you really have to check for is that start_time is outside the range start->end
16:02.31crooh, wait, that's not trye
16:02.32crotrue
16:02.45crothat start_time is outside start-> and end_time is outside start->end
16:03.17crono, that's not true either, because you could have a new start and end where both start and end are outside an existing start->end
16:04.00unumI guess start should always be > max(end)
16:04.38unumactually start > max(end) WHERE start<start
16:04.45croright
16:05.02unumand end < start WHERE end > end
16:05.03crofor a single employee
16:05.17unumright
16:05.28cromax(end), that's a good way to handle that
16:06.19unumcan I add that as a constraint some how
16:08.17croyeah
16:10.00croalter table timecards add check (check_start_time(start_time) == 1)
16:10.13crowhere check_start_time is your stored procedure
16:10.14croI think
16:10.21croagain, my Pg is rusty
16:10.38croand check_start_time returns 1 if the time is legal
16:14.21croactually you would probably want to do this as an 'on insert before' trigger rather than a constraint
16:14.29crohttp://www.postgresql.org/docs/8.3/interactive/trigger-definition.html
16:15.08herlohttp://www.woot.com/
16:16.08herloutahcon: what?
16:16.37utahconthe personal viewer...
16:16.51utahconYou apparently wanna keep your media to yourself
16:16.57utahconit was all a bad joke...
16:16.58utahcondamn
16:16.59unumcro: thanks
16:17.04herloutahcon: really bad
16:17.13utahconthat is my style
16:17.18unumI've got my test database reloaded and I'm going to give it a try
16:17.23mindjujuso who here does contract work?
16:17.26crounum: np
16:17.31cromindjuju: me
16:17.59croitimber does too
16:18.17mindjujuso get this, I get a call from a guy at Tek Systems, wanting to know if I know any PHPers who are looking for contracts
16:18.17itimbersi
16:18.32mindjujualso, wondering what he can do to make his jobs posting more effective
16:18.48mindjujuso i says, send it over and I'll take a look, and I'll also forward to interested parties
16:19.25mindjujuso who's interested
16:19.31mindjujuit's $20/hr
16:19.51croI'll take a look
16:20.03unumthat seems awefully low for contract work
16:20.03mindjujuPM your email addy
16:20.20unumunless it's contract to hire
16:21.37unumI just told a guy yesterday that it would be $100/hour for contract work
16:21.55unumand even then I gave him the mailling list address.
16:22.19unumI burn out on programming in <40 hours
16:22.48unumI don't hate my job. I just don't enjoy it for 8 hours straight like I did the first few months
16:23.43unumI used to go home and program even more....
16:23.52_psychic_It helps to work on varied projects
16:24.26mindjujuk, it's sent
16:25.03unumya it does.  I'm afraid I've been doing web apps for the last two and  half years
16:25.09unumand mostly the same one....
16:25.34unumit pretty big project and has some different parts.  but they all get old.
16:26.38herloutahcon: well, it can't hurt to try the joke, even if it fails.  In here, it'll likely not be a big issue
16:26.48herlowe'll just mock you for the rest of your life :)
16:27.24utahconpretty used to that :D
16:30.37cromindjuju: got it, thanks
16:35.59utahconYes!!!!!
16:36.13utahconMy Guitar Hero World Tour is ready for pickup :D
16:36.29utahconthat was much faster than the anticipated 2 week delivery... stupid WalMart.
16:38.37herloutahcon: Wii?
16:49.26mindjujui'm suppose to be outside finishing the front yard, but instead, i'm distracted by shoping for cars as my jeep needs a new engine
16:49.28mindjujuhttp://www.hotbuysthisweek.com/detail.php?1989-1739
16:52.44utahconherlo: xbox360
16:52.58herloutahcon: well, I'll still play :)
16:53.09utahconlol
16:53.11herlomindjuju: buy :)
16:53.26utahconI'll have to clean the house and have some geeks over or GHWT :D
16:53.29utahconwife will love that.
16:53.34mindjujui should, but i'd have to sell my jeep first, get the money, still some money from the family reserve and get it
16:53.44mindjujulike $700 from family reserves
16:54.15herlomindjuju: btw, my dad has a truck just like that, it's been with them the entire time.  Recently required new transmission, but no other major work
16:54.32herloutahcon: she'll love it?
16:54.34herloreally?
16:54.47herloI can't sing, but I'll do it anyway :)
16:54.54mindjujuis he selling?
16:54.58herlono
16:55.05mindjuju:(
16:55.11mindjujuyeah, cause its hawt
16:55.15mindjuju:(
16:55.17herloI was just giving you a reliability reason...
16:55.22mindjujuah
16:55.28utahconherlo: She would love it... she thinks I am a recluse
16:55.30mindjujuyeah...
16:55.43utahconloves it when I bring people over to prove I am not just out drinking alone when I go to user groups
16:55.54stderrhttp://facemining.pittpatt.com/
16:55.58mindjujuutahcon - that's hilarious
16:56.09herloutahcon: haha
16:57.45mindjujuk, i'm off to do the weeds, bbl
17:12.58itimberI'm out guys.... late
17:20.21*** join/#uphpu carmony (i=JustinCa@c-67-164-249-224.hsd1.ut.comcast.net)
17:20.21*** mode/#UPHPU [+v carmony] by ChanServ
17:20.35carmonyI now have TortoiseSVN installed
17:20.39carmony1.6
17:25.58herlonice
17:26.29orsonjhttp://www.bustedtees.com/buckyballs  <-- these look really fun
17:31.09carmony... I want some
17:32.11unumme too
17:36.31optikalorsonj: Nice link.  Now only if they were in stock. :(
17:41.55orsonjI have to admit, that was my first thought also
17:42.50orsonjI thought it was some science article, but no, it is some insanely cool toy.
17:44.39burninI'm curious how accurate those little magnets are at predicting potential fullerne shapes.
18:02.07herloutahcon: DexterTheDragon, mindjuju http://www.flickr.com/photos/7175709@N07/sets/72157617265383756/ <-- UTOS OLPC hackfest photos
18:03.21herlohttp://blog.utos.org/2009/04/23/hacking-first-utos-olpc-hacknight/
18:05.12unumok so here's the deal on the time card thing I was discussing earlier.  checks for when stuff is first being entered is pretty simple(for the most part that is already verified before being entered) the problem is that suprvisors can alter the time cards.
18:05.33unumso I need to make sure that they are not changing things to overlap with an other entry
18:05.51unumI now have it working for for changing clock in times
18:06.21unumI'm about to add it to clock out times.  I'm going to add it to the same function but use a differnt select statement so I can hand back a better error
18:06.29unumdoes that sound like an acceptable way to do things
18:07.11*** join/#uphpu Utah_Dave (n=David@72-166-51-162.dia.static.qwest.net)
18:07.11*** mode/#UPHPU [+o Utah_Dave] by ChanServ
18:16.22thebigdogfungus you there?
18:16.40fungusYup
18:17.24thebigdogfungus, are you guys using an assp setup? if so, how you liking it?
18:18.18thebigdoganyone in downtown slc want to hit some lunch? a little geek action?
18:18.39fungusNo we aren't using assp specifically.  Just spamc/spamd from SpamAssassin
18:22.26thebigdogcool
18:23.48thebigdogany geek lunch partakers out there?
18:25.48carmonyI would, but I'm in Ogden :(
18:26.21thebigdogoh so sorry panda bear
18:26.29stderrlulz
18:27.21thebigdogif itimber changed his nick again it would be stdin
18:27.29thebigdogoh man no itimber today
18:29.16fungusitimber only works 1-4
18:33.06thebigdoghaha
20:29.22herloeat!
20:51.44*** join/#uphpu synic (n=squish@pdpc/supporter/student/synic)
20:51.44*** mode/#UPHPU [+v synic] by ChanServ
21:04.34*** join/#uphpu _psychic_ (n=_psychic@173.8.91.177)
21:04.34*** mode/#UPHPU [+v _psychic_] by ChanServ
21:43.18herloI'm sleepy
21:43.27herloand I want to go home (well, to LFNW)
21:57.26*** join/#uphpu utahcon (n=utahcon@bromine.sosstaffing.com)
21:59.11synic^5 jaunty buddy
22:03.04HeartsbaneI like it too ... but tracker sure eats up the system resources on my desktop at bootup, wonder what is up there?
22:03.46Heartsbaneevery other system perfectly fine :(
22:34.24*** join/#uphpu unum (n=unum@li32-23.members.linode.com)

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.