IRC log for #uphpu on 20080522

00:36.43*** join/#uphpu undertakingyou (n=will@undertakingyou.dsl.xmission.com)
01:37.42*** join/#uphpu mrkrow (n=Chad@dsl093-228-239.slc1.dsl.speakeasy.net)
01:37.42*** mode/#UPHPU [+v mrkrow] by ChanServ
01:50.19*** part/#uphpu mrkrow (n=Chad@dsl093-228-239.slc1.dsl.speakeasy.net)
02:10.11*** join/#uphpu Midorikawa (n=insanemo@75-169-218-182.slkc.qwest.net)
02:37.21*** join/#uphpu wps (n=wps@208.53.47.251)
02:37.21*** mode/#UPHPU [+o wps] by ChanServ
03:05.11*** join/#uphpu undertakingyou (n=will@undertakingyou.dsl.xmission.com) [NETSPLIT VICTIM]
03:05.11*** join/#uphpu DexterTheDragon (n=admin@oalug/member/blackchaos) [NETSPLIT VICTIM]
03:05.11*** mode/#UPHPU [+v DexterTheDragon] by irc.freenode.net
03:17.13*** join/#uphpu Utah_Dave (n=David_Bo@75-169-168-160.slkc.qwest.net)
03:17.13*** mode/#UPHPU [+o Utah_Dave] by ChanServ
03:21.02*** join/#uphpu kingsol (n=kingsol@c-67-166-66-98.hsd1.ut.comcast.net)
03:22.26*** join/#uphpu DexterTheDragon (n=admin@oalug/member/blackchaos)
03:22.26*** mode/#UPHPU [+v DexterTheDragon] by ChanServ
03:30.09*** join/#uphpu Trevyn1 (i=4c1b61c5@gateway/web/ajax/mibbit.com/x-6e6073543b1ff6dd)
03:30.30*** part/#uphpu Trevyn1 (i=4c1b61c5@gateway/web/ajax/mibbit.com/x-6e6073543b1ff6dd)
04:06.07*** part/#uphpu Utah_Dave (n=David_Bo@75-169-168-160.slkc.qwest.net)
04:28.15*** join/#uphpu undertakingyou (n=will@undertakingyou.dsl.xmission.com)
04:53.50*** join/#uphpu undertakingyou (n=will@undertakingyou.dsl.xmission.com) [NETSPLIT VICTIM]
05:53.44*** join/#uphpu SunSparc (n=sparky@71-35-208-217.slkc.qwest.net)
05:53.44*** mode/#UPHPU [+v SunSparc] by ChanServ
05:58.58*** join/#uphpu undertakingyou (n=will@undertakingyou.dsl.xmission.com) [NETSPLIT VICTIM]
14:25.19*** join/#uphpu mindjuju (n=mindjuju@76.8.222.130)
14:25.19*** mode/#UPHPU [+o mindjuju] by ChanServ
14:31.55jsmithmindjuju: I'd hate to see what happens when you scan the room with your bad eye ;-)
14:33.30mindjuju/my bad eye is actually a borg controled eye / laser unit
14:34.21mindjujusometimes, people think that i have a lazy eye, but it's REALLY because the borg are VNC'd into my eye and taking a look around
14:48.27*** join/#uphpu mrkrow (n=Chad@166.70.178.114)
14:48.27*** mode/#UPHPU [+v mrkrow] by ChanServ
14:48.44*** join/#uphpu beandog (n=steve@gentoo/developer/beandog)
14:48.44*** mode/#UPHPU [+v beandog] by ChanServ
14:55.04beandogbuenos dias
14:55.14beandogIm gonna go see Indy in about an hour
14:55.15beandogyay!
14:55.22beandogduh da dah dah
14:55.24beandogdah dah dah
14:55.28beandog~whip
14:55.29jbotACTION whips DarthValou with a big rope until she works again
15:03.32*** join/#uphpu wps (n=wps@64.0.193.211)
15:03.32*** mode/#UPHPU [+o wps] by ChanServ
15:04.40*** join/#uphpu thebigdog (n=thebigdo@0006yE-Yn.dsl.xmission.com)
15:04.40*** mode/#UPHPU [+o thebigdog] by ChanServ
15:12.50*** join/#uphpu SunSparc (n=sparky@66.7.114.125)
15:12.50*** mode/#UPHPU [+v SunSparc] by ChanServ
15:14.09*** join/#uphpu mgeary (n=mgeary@166.70.44.49)
15:14.09*** mode/#UPHPU [+v mgeary] by ChanServ
15:17.38wpssorry I disappeared after asking my SQL question last night
15:17.43wpsI was pulled into a meeting
15:17.45wpsI found the problem
15:17.48wpsthey weren't really dupes
15:18.02wpswas a unique value in a column that I was selecting
15:19.14*** join/#uphpu timinator (n=timothy@c-98-202-102-189.hsd1.ut.comcast.net)
15:19.14*** mode/#UPHPU [+v timinator] by ChanServ
15:20.45*** join/#uphpu josephscott (n=josephsc@75-169-251-65.slkc.qwest.net)
15:20.45*** mode/#UPHPU [+v josephscott] by ChanServ
15:20.49thebigdogsounds good
15:31.51mindjujusup thebigdog
15:33.13thebigdogk
15:33.48thebigdogwhatz up mindjuju
15:33.50thebigdoghow you doing
15:35.03mindjujurunning around the office with an iron boot kickin' butts today
15:35.52beandoghow many throats have you stepped on today?
15:36.51mindjujuwell, no throats, but a couple of company policies bypassed, and 1 iron boot butt kickin'
15:37.58beandogdeath to policy.
15:38.02mindjujuthe reviews for Indy 4 say that it is pretty good
15:38.07mindjujuyou'll have to tell us what up
15:38.11beandogask PoeticIntensity
15:38.12mindjujuare you coming back in afterwards?
15:38.13beandoghe saw it this morning
15:38.21mindjujusup PoeticIntensity
15:38.34beandogif he liked it, I'll hate it.
15:38.38beandogIt is the way of the universe.
15:39.07mindjujuthe universe has a way of balancing itself out
15:59.24*** join/#uphpu timinator (n=timothy@c-98-202-102-189.hsd1.ut.comcast.net)
15:59.24*** mode/#UPHPU [+v timinator] by ChanServ
16:04.30*** part/#uphpu mrkrow (n=Chad@166.70.178.114)
16:14.51mindjujunice
16:14.59thebigdogoh yeah
16:15.24thebigdoggot their hits from 1971 - 1975 going
16:18.09jsmiththebigdog: Foreigner?  .38 Special?  Journey?
16:18.36mgearyREO Speedwagon
16:19.03wpsis this proper syntax for the sub query?
16:19.03wpshttp://rafb.net/p/1qWXmC54.html
16:19.05mgeary~airsupply thebigdog
16:19.05jbotACTION takes thebigdog by the hand, hunkers down on one knee, gazes fondly into thebigdog's eyes, and croons, "'cause you're every woman in the world to meeeee...."
16:19.11wpsdo I need the parenthesis?
16:19.24mgearyparenthesis are good for subqueries
16:19.33mindjujucurious, i thought they were required
16:19.57thebigdogwps, no
16:20.09thebigdogjsmith, eagles
16:20.16thebigdogmgeary, i hate airsupply
16:20.18jsmiththebigdog: That doesn't really count.
16:20.32jsmiththebigdog: They may be classic, but I wouldn't exactly call them classic rock
16:20.43thebigdogi dont call them classic rock
16:21.18thebigdogclassic rock is more like pink floyd, jimmy hendrix, the doors
16:21.55wpsI am converting all of my queries from theta style to ansi style
16:22.17wpsI wish I had been taught ansi when I first learned
16:22.21wpsinstead
16:30.14thebigdogwps in that last example though i would not use a subquery
16:30.30thebigdogthat might be better as a view
16:30.31wpshow would I do it without a subquery?
16:30.44wpsoh… I don't know views yet… I'll have to look into that
16:32.03thebigdogwps, add another order by in the subquery
16:32.35wpswhy?
16:32.44wpsthat makes it a view?
16:32.45thebigdogcause that is all you are doing
16:32.48thebigdogno
16:32.59wpsoh
16:33.05wpsif I did another order by then I wouldn't need the subquery?
16:33.07thebigdogyou are adding a second order by with the outer query
16:33.13thebigdogyep
16:33.23thebigdogbut if you need to change it up then i would do a view
16:33.36thebigdogchange up line 13
16:33.49thebigdogor add a where clause
16:34.28thebigdogfrom your example you trying to mimic a view
16:35.09wpswait… I'm not sure it will work without a sub query
16:35.37wpsI need to order the subqueries results by date, then only get the top 10… then order those by name
16:36.58thebigdoga view
16:39.24thebigdogthis doesnt work http://rafb.net/p/9Naop010.html
16:41.10wpsare you asking if it doesn't or saying that it doesn't?
16:41.31thebigdogdoes that query give you the same results
16:41.48wpslet me try
17:00.39PoeticIntensitymindjuju, Indiana Jones was done wonderfully.
17:01.07PoeticIntensitythey stood true to trilogy....  humor... action....
17:01.13SunSparcmediaRAIN is about to go watch Indiana Jones.  In 30 minutes.
17:01.29PoeticIntensityyeah.... My wife took me yesterday at midnight.
17:01.36SunSparcNice
17:01.39SunSparc:)
17:02.08PoeticIntensitythey didn't do anything to make Indiana do anything out of character / age / etc...
17:02.16mindjujucool
17:02.17PoeticIntensityI thought it was enjoyable.
17:02.59mindjujuthat preview where they have him holding a bazooka looks funny
17:03.09mindjujuthink he says something like, "you'd better hold your ears"
17:03.10PoeticIntensityhehe... there were some really funny parts.
17:03.16PoeticIntensityyup.
17:03.29PoeticIntensitylots of crazy car stunts.
17:03.49PoeticIntensitynothing spectacular, but definitely true-to-form.
17:03.49mgearyso, tell me this, PoeticIntensity
17:04.13PoeticIntensitySheai Lebuoff (sp?) was pretty good in it, too.
17:04.45mgearydoes this supposedly happen *after* "Last Crusade"? Because, you know, he drank the magic juice in L.C. that was supposed to give him everlasting life. I guess it didn't grant eternal youth, though...
17:05.21PoeticIntensityhehe....
17:05.24DexterTheDragonmgeary: Last Crusade says that when you walk pass the seal at the door you lose the enternal life
17:05.26mgearyi just want to know if they try to reconcile his immortality with his advancing age and apparent danger
17:05.33mgearyahh
17:05.44PoeticIntensityDexterTheDragon is the man.
17:05.45DexterTheDragonThats what the knight in there tells him
17:05.46mgearymakes for a pretty lame magic potion, don't it?
17:05.48mindjujuyeah, that is the price of immortality
17:06.03PoeticIntensitybeing crammed into a cave.
17:06.09DexterTheDragonforever
17:06.13PoeticIntensityLOL
17:06.15*** join/#uphpu Lone_Working (n=chatzill@206.61.134.77)
17:06.25PoeticIntensitynah.... it's a really good flick.
17:06.39PoeticIntensityI didn't have very high expectations, and it was well worth the price / time.
17:06.49mgearySunSparc: were you at MR when they went to Star Wars III ?
17:07.03Lone_WorkingWhat movie, PI?
17:07.04SunSparcmgeary: Negative.
17:07.10PoeticIntensityIndiana Jones, Lone_Working
17:07.19mgearySunSparc: ah. They invited me to that, my son won the costume contest
17:07.27SunSparcSweet!
17:07.28Lone_Workingahh, okay
17:07.30PoeticIntensitythat's awesome, mgeary
17:07.40mgearyit was
17:07.41SunSparcWe are watching it at the Scera.  Just across the street from you.
17:08.23mgearymust have been delivered to the wrong suite. happens all the time
17:08.29SunSparc:)
17:27.17timinatoriTunes
17:27.19timinatoroops
17:27.27timinatorduh
17:28.16*** join/#uphpu SunSparc (n=sparky@66.7.114.125)
17:28.16*** mode/#UPHPU [+v SunSparc] by ChanServ
17:28.28timinatorwill you take a check?
17:38.27fungusI just got back from a screening of Indiana Jones 4.  It was really cool.  
17:52.10*** join/#uphpu burnin (n=burnin@204-228-142-194.ip.xmission.com)
17:52.10*** mode/#UPHPU [+v burnin] by ChanServ
18:11.55thebigdogwps did that query work for you?
18:12.02wpsyup
18:12.17wpsoh… wait… haven't tested that one yet
18:12.21thebigdoghaha
18:12.33wpsI am going to though… just have to finish something else first
18:12.41thebigdogno worries
18:12.55thebigdogjust thought i would ask
18:13.07thebigdogseeing that we are like the only ones working today
18:13.47thebigdoghehe
18:13.52mindjuju:)
18:15.07thebigdogfor mindjuju's coding skillz
18:16.19mindjuju~lart thebigdog
18:16.19jbotpulls out a ClueBat (tm) and thwaps thebigdog
18:27.40thebigdogmindjuju, you familiar with fates warning?
18:28.00thebigdogi need some rocking tunes today
18:29.11mindjujuheard of them
18:29.22mindjujusome of those other bands you mention i haven't but them i have heard of
18:29.36mindjujuprolly kin of Jack Black
18:29.39thebigdogpixies
18:29.48mindjujuah
18:29.55thebigdoghttp://www.frankblack.net/
18:30.55thebigdogwhen you enter the site
18:31.03thebigdognotice the pic at the very bottom of the page
19:07.39mgearyjbot, thebigdog is also Frank Black
19:07.39jbotokay, mgeary
19:08.33thebigdogys
19:08.59mindjuju~thebigdog
19:08.59jbotthebigdog is, like, the postgreSQL guru, a GWAR groupie, or secretly loves AOL, or a lover of cursors, or now 33.  Frank Black
19:16.52beandogokay, that was awesome
19:16.53beandog:D
19:17.04mgearyjbot: thebigdog is NOT 33
19:17.04jbot...but thebigdog is already something else...
19:17.17mindjujuwhat was awesome?
19:17.26beandogindy 4
19:45.03*** join/#uphpu toddperk (i=43a4c0e2@gateway/web/ajax/mibbit.com/x-8c015bf9c53a632b)
20:09.48thebigdogi heard it was kinda slow
20:09.50thebigdogis that the case?
20:10.05thebigdogwe are watching the 3 this weekend and then hitting the 4 next week
20:31.02*** join/#uphpu timinator_ (n=timothy@c-98-202-102-189.hsd1.ut.comcast.net)
20:36.42*** join/#uphpu timinator (n=timothy@c-98-202-102-189.hsd1.ut.comcast.net)
20:36.42*** mode/#UPHPU [+v timinator] by ChanServ
20:38.23synicwewt, hybrid on ravetrax
20:52.48timinatorI'm out... later guys
20:58.02SunSparcIndiana Jones IV does not disappoint!!!
20:59.17*** join/#uphpu beandog (n=steve@gentoo/developer/beandog)
20:59.17*** mode/#UPHPU [+v beandog] by ChanServ
21:00.31*** join/#uphpu Trevy1 (n=Trevyn@99-203-115-138.area1.spcsdns.net)
21:00.39Trevy1I have a php MySql question
21:01.11Trevy1I want to store special charactors in a myslq field
21:01.26Trevy1using PHP to insert and select from
21:01.35Trevy1without loosing those charactors
21:01.47Trevy1Teh Charactors are How are you? “I’m fine now!”
21:02.29tierrauh, a text field of some kind...
21:04.49SunSparcTrevy1: Are you having problems with that?
21:04.55Trevy1Yes
21:05.21SunSparcWhat is the problem?
21:05.21Trevy1My question is how do I do that?  What field type/ connection string setting do I need to ster those charactors?
21:05.39Trevy1I am adding them and they turn into this.
21:06.12*** join/#uphpu bradym (n=bradym@63-197-255-78.ded.pacbell.net)
21:06.12*** mode/#UPHPU [+v bradym] by ChanServ
21:06.30SunSparc<PROTECTED>
21:06.38Trevy1How are you? “I’m fine now!”
21:07.01SunSparcOh, because of the "pretty quotes"
21:07.07SunSparcMakes sense.
21:07.26Trevy1And apostrophy
21:07.40Trevy1These are being cut and pasted into the web form
21:07.44Trevy1from a word docuemtn
21:07.48Trevy1and Id like to keep them
21:09.02SunSparcI would think that the database should be able to handle them as long as the table specifies a character set that includes those characters.
21:10.29Trevy1It does.. I can do it with PHPmyadmin
21:10.44Trevy1but not through a AJAX php post I think...
21:11.05thebigdogi think the blob data type might keep it the way it was
21:11.25thebigdogit does look like an issue with the default char set for the table though
21:11.40thebigdogi wonder if you set the char set to utf8 if that would work
21:12.00Trevy1I changed the feild to value     longtext     utf8_unicode_ci      
21:12.01SunSparcI was thinking the same.  UTF8 handles quite a bit.
21:12.41thebigdogor you can just use pgsql and have it work ;)
21:12.44tierrayou need to make sure your connection is set to handle UTF8, i.e. run the SQL query "SET NAMES UTF8" iirc
21:13.54Trevy1ok thats what I was looking for
21:14.04Trevy1do I do that in my connection string on for that query?
21:14.19tierrajust at the beginning of your connection
21:14.26Trevy1Do you have an example?
21:14.29tierrabefore you run your query
21:14.38tierrathat was the example...
21:15.12thebigdogif you have access to my.cnf then you can set it there too
21:15.26Trevy1$link = mysql_connect("$servername","$dbuser","$dbpassword");
21:15.26Trevy1<PROTECTED>
21:15.26Trevy1<PROTECTED>
21:15.26Trevy1<PROTECTED>
21:15.39Trevy1Id rather do it on the connection string I think
21:16.47Trevy1mysql_query("SET NAMES 'UTF8'");
21:16.52Trevy1Do I just do that?
21:16.54thebigdogwhy not set it on the db?
21:17.11tierrayeah, shouldn't need the single quotes
21:17.17Trevy1I set it on the feild
21:18.01tierrayou do also need to make sure your fields are one of the utf8 collations, but if phpMyAdmin can do it, then they probably already are
21:18.03Trevy1<PROTECTED>
21:18.41tierrabut even if your fields are utf8, you still need to make sure your connection is
21:18.51tierrawhich is what SET NAMES utf8 does
21:22.08Trevy1tierra: Where do I pu that command?  In my main connection screen script?
21:22.19Trevy1Or prior to the querys that touch that table?
21:22.44Trevy1<PROTECTED>
21:22.45Trevy1<PROTECTED>
21:22.47Trevy1Liek that?
21:26.44wpsyes, Trevy1
21:32.44Trevy1Cool its in teh DB correclty now
21:32.45Trevy1thank you
21:43.52PoeticIntensitygreat song, mgeary...
21:44.35*** part/#uphpu Trevy1 (n=Trevyn@99-203-115-138.area1.spcsdns.net)
21:53.55*** join/#uphpu kingsol (n=kingsol@64.0.193.254)
21:57.12*** join/#uphpu beandog (n=steve@gentoo/developer/beandog)
21:57.12*** mode/#UPHPU [+v beandog] by ChanServ
22:19.55mgeary~cornnuts bradym
22:19.56jbotACTION sends bradym out for CornNuts™ for everyone. "Mmm, extra crunchy!"
22:54.29wpsnote to self… make sure that you always use thorough and descriptive SVN commit comments
22:56.55SunSparcSpeaking of SVN.  WHY is it not possible to ignore an item once it has been added to the repository.
22:56.57SunSparcArgh
22:59.18mgearyyeah, i hate that
23:50.13*** part/#uphpu mgeary (n=mgeary@166.70.44.49)

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