irclog2html for #uphpu on 20060906

01:13.46*** join/#uphpu herlo (n=herlo@h4607554c.area7.spcsdns.net)
03:06.29*** join/#uphpu wps (n=wps@70.98.110.105)
03:06.29*** mode/#UPHPU [+o wps] by ChanServ
13:08.58*** topic/#UPHPU by wps -> New website up. Note changes to syndication URLs.
13:18.00*** join/#uphpu drip (n=drip@67.96.135.254)
13:21.47*** join/#uphpu RyanE (i=Piadas@rberick.dsl.xmission.com)
15:40.53*** join/#uphpu jbot (i=ibot@pdpc/supporter/active/TimRiker/bot/apt)
15:40.53*** topic/#uphpu is New website up. Note changes to syndication URLs.
15:48.13mindjujui think somebody needs a good lart
15:48.16mindjuju~rlart
15:48.32mindjujuthat's wierd, it hit him twice, almsot in a row
15:48.56mindjuju~chuckfact
15:48.57jbotit has been said that chuckfact is When the Boogeyman goes to sleep every night, he checks his closet for Chuck Norris
15:57.02dripmindjuju: I might have an extra 3dfx pci card for you somewhere.
15:57.26dripel_guacho: what kind of frame rates are you getting?
15:57.36mindjujuthat would be cool, except all i have are p3s
15:57.41mindjujui'll upgrade soon
15:57.57driphe he.. the 3dfx card is only about 8 yrs old
15:57.58drip=)
15:58.23mindjujuah, didn't see that the card was a pci
15:58.26dripmaybe 32 MB ram on that screamer
15:58.42mindjujuhey, i got the matrox mill g450
15:58.51mindjujudual head, 32mb of smoking fast ram
15:58.56drip=)
15:59.05dripI just want another card to sli together
15:59.12mindjujui can play a MEAN game of red alert
15:59.33dripI thought you were going to say Oregon Trail
15:59.34driplol
15:59.37mindjujuwhat a great, well balanced game
15:59.49mindjujulol
16:01.35mindjujuwow, not that anybody cares, but...
16:01.41mindjujuWindows Vista Home Basic: $199  Windows Vista Home Premium: $239  Windows Vista Business: $299  Windows Vista Ultimate: $399
16:05.22synicUpgrading Ubuntu: free.
16:06.29mindjujuyup
16:06.42mindjujusome serious vista bashing  http://www.computerworld.com/blogs/node/3392
16:07.03mindjujulast i heard, vista was 12g install, some guy here says it is 27g for full install
16:07.09mindjujuthat's huge
16:07.49mindjujuthat' can't be right, that'd be like 7 ~ 8 dvds
16:08.23synicwow.
16:08.34synicGots an OS X iso here that's 4GB
16:08.37synicand I thought that was huge.
16:10.11mindjujuyeah, i'll log into MSDN and find out how big it really is
16:10.19mindjuju27 is way too big to be realistic
16:13.03el_guachodrip, right now i avg 60fps
16:14.38mindjujuweird, even though the article says RC 1 available to MSDN, i'm just showing CTP and its 2.64 g
16:18.32*** join/#uphpu drip (n=drip@67.96.135.254)
16:23.50wpsmindjuju: can we take you up on the offer to hold the meetings at you office
16:23.57wpsLinux Networx is no longer available
16:25.43mindjujufo sho
16:25.49wpswonderful
16:25.50wpsthanks
16:25.58wpscan you get me the address?
16:26.11mindjujuyour giving me a chance to be even more lazy, and your thanking me???
16:26.21wpsyup
16:26.30mindjujuall i have to do is get up, walk about 100 feet and i'm there, WOOT!
16:26.55mindjujuBill Good Marketing
16:26.55mindjuju12393 Gateway Park Pl Ste 600
16:26.55mindjujuDraper, Utah 84020
16:29.48el_guachoman your not in slc?
16:33.17dripAt least it's not Levan
16:33.39cycokilryeah, and just an FYI.. the bill good website is not happy in firefox on linux (ubuntu at least)...
16:34.21el_guacholol
16:34.26el_guacho~pimpslap mindjuju
16:34.28jbotel_guacho pimpslaps mindjuju.  ouch!
16:36.17*** join/#uphpu jsmith (n=jsmith@24-75-195-202-st.chvlva.adelphia.net)
16:37.37dripit's so e-violent in here
16:38.05el_guachocause im an e-thug
16:38.12dripI know all too well.
16:38.45cycokilrit's funny having a trigger that's the same as the outcome.. kinda gives it away before it happens..
16:39.17el_guacho~thug
16:39.29drip~thugthump
16:43.52el_guacho~unsubscribe
16:44.20*** join/#uphpu bigdog_ut (n=bigdog@208.177.146.102.ptr.us.xo.net)
16:44.20*** mode/#UPHPU [+o bigdog_ut] by ChanServ
16:45.14bigdog_ut~teabag mindjuju
16:53.31mindjujuk, i'm back. cycokilr, if you got a chance, can you screenshot that and send it over.  
16:53.42*** join/#uphpu bigdog_ut (n=bigdog@208.177.146.102.ptr.us.xo.net)
16:53.42*** mode/#UPHPU [+o bigdog_ut] by ChanServ
16:54.04mindjuju~macattack bigdog_ut
16:54.06jbotACTION uses a paperclip to hotwire bigdog_ut's car!
16:54.37mindjujuwps, when you get a chance, can you tell me the next meet date (or next 2 if you have them)
16:54.54wpsthird thursday of every month
16:55.25wps21 sep, 19 oct, 16 nov, 21 dec
16:55.41bigdog_ut~teabag mindjuju
17:00.45mindjujuyou see the futility of trying to attack mindjuju!
17:01.17*** join/#uphpu herlo (n=herlo@hq-nat2.gurulabs.com)
17:07.08*** join/#uphpu mindjuju (n=Administ@65-121-75-195.dia.static.qwest.net)
17:07.23cycokilrhey mindjuju, sorry i was away for a bit..
17:07.37mindjujuno worries
17:07.39cycokilrmostly it's the menus.. on the homepage, they show up under the flash image..
17:07.57mindjujudag, i know the prob
17:08.14mindjujuhave it fixed for firefox on windows, but hadn't checked under *nix
17:08.20mindjujuthx for teh info
17:08.26cycokilryou betcha..
17:29.22*** join/#uphpu fungus (n=fungus@shell.aros.net)
19:20.54*** join/#uphpu RyanE_ (i=Piadas@rberick.dsl.xmission.com)
19:54.48*** join/#uphpu _psychic_ (n=_psychic@71.32.228.156)
21:04.27cycokilrooh.. this eclipse is fancy..
21:42.13*** join/#uphpu mindjuju (n=Administ@65-121-75-195.dia.static.qwest.net)
21:42.30*** part/#uphpu mindjuju (n=Administ@65-121-75-195.dia.static.qwest.net)
21:42.36*** join/#uphpu mindjuju (n=Administ@65-121-75-195.dia.static.qwest.net)
21:42.57cycokilrhey, do you mind, juju?
21:43.01cycokilrhehe..
21:43.19mindjujuhar har har
22:18.31Utah_DaveDoes anyone have a second to help me with a database query?
22:18.40Utah_DaveMySQL - PHP5
22:19.00Utah_DaveI have a user table, a contact table and a contactType table
22:19.17Utah_DaveI want to pull the first and last name from the user table
22:19.35Utah_Davethe phone number from the contact table
22:19.58Utah_Daveand the type of phone from the contactType table  (like "Cell" or "Home" )
22:20.28cycokilris there a console package manager for FC4 that anyone knows of off hand?
22:20.39Utah_DaveIf the user doesn't have any entries in the contact table, I still want the first and last name to come back from the user table
22:20.45Utah_Davecycokilr: yum
22:20.51cycokilrsweet..
22:20.55cycokilrwhat database query?
22:21.06Utah_DaveI think I need a left join, but I can't get it to work right
22:21.14bigdog_utcycokilr, should be like system-config-packages
22:21.32bigdog_utUtah_Dave, what do you have now for the query?
22:21.42*** join/#uphpu mindjuju (n=Administ@65-121-75-195.dia.static.qwest.net)
22:21.54fungusI assume your relation of users to contacts is 1 to many.
22:21.57fungusright?
22:22.17Utah_Davefungus: yes
22:22.33fungusIf it is, user left join contact will not get all the contacts.
22:22.56fungushowever contact left join user will leave out users w/ no contacts
22:23.47fungusyou need some kind of outer join I think
22:24.28Utah_Davebasically I always want the username to come back even if there isn't a contact
22:24.28bigdog_utouter join on user
22:25.03Utah_Davebigdog_ut: OK, I'll look that up.
22:27.53bigdog_ututah_dave what is your query now?
22:29.27Utah_DaveI'm trying to do a pastebin, but it's really slow right now
22:29.34bigdog_utlol
22:30.02Utah_DaveSELECT u.first_name, u.last_name, t.contact, c.contactName FROM users u, tblContact t, tblContactType c
22:30.02Utah_DaveWHERE u.userid = t.userID
22:30.02Utah_DaveAND t.contactTypeID = c.contactTypeID
22:30.02Utah_DaveAND u.userid = 1;
22:30.41Utah_DaveThis works fine if the user has a contact, but the query doesn't return anything if the user doesn't have a contact
22:31.02bigdog_utwhich version of mysql?
22:31.44Utah_Dave4.1, I think
22:31.50jsmithUtah_Dave: Do you know the difference between LEFT joins and RIGHT joins?
22:33.05Utah_Davenot enough I guess! It's been a while since I've really gotten into the database
22:33.12bigdog_utbut in mysql they are analoguos
22:33.45jsmithThey are?
22:34.01bigdog_utyep for compliance
22:34.39jsmithcompliance with what?
22:34.44Utah_Daveyeah, I'm on 4.1.11, but I'm hoping to upgrade to 5.0 soon, if that makes any difference here
22:34.51bigdog_utk
22:35.17fungusif you use a LEFT join the user will always appear, but will only pick one contact.
22:35.24bigdog_utcompliance to having right joins in sql
22:35.52jsmithbigdog_ut: How's it compliant if LEFT join acts just the same as RIGHT joins?  I don't think SQL '99 says they should be the same...
22:36.01Utah_Davefungus: is there any way I can pull out multiple contacts?
22:36.08bigdog_uthaving the right join keyword i guess
22:36.24bigdog_utUtah_Dave, union of the tables
22:36.35bigdog_utugly stuff though
22:36.42fungusI think you might need to use two queries and UNION them together.  I don't know if MySQL can do real outer joins.
22:37.46bigdog_utUtah_Dave, try and do a left outer join on user and contact first then build on the query
22:37.55jsmithfungus: One more reason to use postgresql!
22:37.59fungusIf you use a tblContact LEFT JOIN users, then UNION in another query for users w/ no contacts.
22:38.43fungustry bigdog_ut's suggestion first though.
22:39.08Utah_DaveI think I almost have it.
22:39.08bigdog_utstart small and then build on it
22:39.54bigdog_utbasically you would have somethign like this select * from t1 left outer join t2 on t1.id = t2.id
22:40.16Utah_DaveYes! I got it!
22:40.28Utah_DaveI did two  LEFT  JOINS and that did the trick
22:40.36bigdog_utcool
22:40.42Utah_Davesweet. It does exactly what I wanted it to do
22:40.42fungusSo did the LEFT OUTER join work?
22:40.58Utah_DaveI just did  LEFT JOINs
22:41.12Utah_Davejust a sec and I'll post it somewhere
22:41.17funguscool.
22:41.34fungusI don't do outer joins much, but they always give me headaches.
22:41.58bigdog_utoh left joins give you the in addition too
22:42.05bigdog_utso it is like having the outer
22:42.10bigdog_utthat is retarded
22:43.02Utah_Davehttp://www.ninethsense.com/pastebin/index.php?p=209
22:43.36Utah_Davethis gives me a row for each contact with the correct corresponding info.
22:43.58Utah_Daveif there isn't any contact info for the user, then just the info in the user table is returned
22:43.59bigdog_utanother reason i love pgsql
22:44.22bigdog_utthe left keyword assumes you are doing outer
22:44.26bigdog_utsame with right
22:44.55bigdog_utif you just use join then you get an inner join like what you had before Utah_Dave
22:45.28Utah_Davecool
22:45.32Utah_Davethanks everyone
22:46.18Utah_DaveThanks, bigdog_ut and fungus
22:47.30*** part/#uphpu Utah_Dave (n=boucha@72-166-51-162.dia.static.qwest.net)
22:47.36bigdog_utnp
23:28.32bigdog_uti feel like a dumass
23:28.54bigdog_uttroubleshooting apache perm issues only to find out they it was selinux
23:36.21herlobigdog_ut: tail /var/log/messages
23:42.18cycokilrsVVeet!
23:42.30cycokilrseems like i just did that same thing last week..

Generated by irclog2html.pl by Jeff Waugh - find it at freshmeat.net! Modified by Tim Riker to work with blootbot logs, split per channel, etc.