| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> thumb rule #1
<0> but back to the question
<0> winner and looser points to handle, right?
<0> don't really get the whole query either, but we'll get to that :)
<1> Well, what I want to do is count the number of times attend.handle occurs as kill_log.winner... then count the number of times attend.handle occurs as kill_log.loser .
<1> Basically so I end up with attend.handle, kills, deaths.
<1> I COULD do it with multiple queries, but I was hoping to clunk them into one.
<0> CancerMan: http://www3.kfwebs.net/cancerman.txt
<0> should be one option..
<0> uhm, wait.. you probably want a where on the handle as well
<1> Ohhh.
<0> or is it a general list?
<1> General list?
<0> list of multiple handles or one specific handle?
<1> Multiple handles.
<0> ah, second then
<1> And now... I get to read through my book translating your work into neural pathways.
<1> Yeees.
<0> try to update now
<0> http://www3.kfwebs.net/cancerman.txt
<1> Ok. It dumped an error on the IF, but I think I can work that out.
<0> it would work for MYSQL
<0> you might need a CASE for PG
<1> Well, I'll read up on IF(). I have an O'R book on it.
<0> well, good luck anyways :)
<0> hopefully it was of some help
<1> Thank you very much Sir.
<2> D-side: lemme know if you like it... i have a centos box here that i'm just thinking of installing it on.
<2> hey peter
<3> re
<1> K_F: I have a solution. I used CASE, as well as using SUM() instead of COUNT() in conjuction. I confirmed it with the former multi-query solution. Again, thank you VERY much.
<0> bah, yes
<0> my bad, SUM indeed
<0> of course..
<4> Anyone had problems streaming shoutcast tv on mplayer?
<5> hmm, the more I get familiar with quanta the more I start to like it.
<6> haha
<6> Lion-O: gotcha!
<6> its actually a really useful editor
<5> wha?
<5> damn, you were looking in here.
<6> Lion-O: i mentioned using quanta yesterday. now you're using it ;)
<5> OxD: but yeah, so far I managed not only to get a decent (and validated) website up but I actually learned something about html too.
<1> K_F: You chose COUNT instead of SUM because you were rolling your own custom COUNT.
<5> OxD: my issues weren't with Quanta but Sid. The stable version is (iirc) 1.4 while I have 1.5, on Sid. No wonder it has issues every once in a while.
<1> And *I* wrote count.
<6> Lion-O: heh yeah. sid is a bit too unstable for me
<6> i won't bring up what i use for a desktop
<5> OxD: yeah, don't I know it.. I'm considering to move back to Stable or perhaps ubuntu.
<6> stable isn't a good workstation distro though. a little too stale, you know?
<1> 13: An 8x4 peice of plywood? :P
<5> OxD: *nod*, true.
<6> CancerMan: close. fedora ;P
<5> aaaargh! <plok>
<6> heh
<6> it has very good "hey. lookit that. it works!" factor
<5> fc5? ;) You traitor ;)
<0> CancerMan: yeah, think I had count in my forehead ..
<7> Lion-O: what's in testing?
<0> but indeed, has to be SUM or logic doesn't make sense
<1> 13: That's OK... I run Slack 10 as a desktop... and as my Wolf server.
<5> whyzzyrd: dunno.
<6> CancerMan: aaagh
<1> 13: Ice Cream and Curry. :D
<6> have fun!
<1> 13: Eh. I acknowledge that major underlying library changes will expand my anus by at least 4 ring sizes.
<6> hehee
<6> all i do is netboot and point at an nfs share for an upgrade
<6> modern distro: 1, slackware: 0
<6> http://www.arouse.net/despair-linux/slackware.jpg
<1> I ack and accept some of the 'dysfunctionalities' of my chosen distribution. However, I've also chosen to 'try out' NetBSD 3.
<6> i've chosen the idea that you're a masochist
<6> and thats ok
<1> How did YOU know that I still have an Apple IIgs, and a fondness for SCSI?
<6> haha google video has the naked news
<8> hah really?
<8> url
<8> i havent seen that in years
<6> http://video.google.com/videoplay?docid=-902497272743062271
<6> its actually under top 100
<6> how do you keep a straight face doing that
<9> who is naked?
<9> they're all wearing a bikini
<6> ...girls
<9> ;)
<6> oh. yeah. definite misnomer
<6> still, boobies!
<8> no, they're usually naked
<8> i remember it from like 5 years ago
<6> none of the ones i saw on their actually got naked
<8> check the site out.
<8> theres a "members entrance"
<6> ah hah
<8> you know full well that means no boobies til they have your cash
<9> hehe true, true
<8> bahahaha
<8> "Just like CNN but WAY better"
<10> Lorem ipsum dolor sit amet, consectetuer adipiscing elit.
<7> http://video.google.com/videoplay?docid=7624305360916017446
<10> afternoon Travis, D-side, whyzzyrd
<3> Quidquid latine dictum sit, altum sonatur
<6> ey sean
<6> whyzzyrd: ...what the hell?
<10> whyzzyrd: LOL!
<7> OxD: some twit on a fast bike?
<6> darwin is rolling over in his grave
<10> nevermind how stable the video is
<6> yeah
<10> must be some mad expensive camera
<7> http://video.google.com/videoplay?docid=3532345995516410015
<6> http://video.google.com/videoplay?docid=-9041238562513599364
<2> Lion-O: what's wrong with fc5 on the desktop?
<11> http://video.google.com/videoplay?docid=-7486583767426908809
<11> FTW
<10> reality: BWAHAHAHAHAH
<12> whee... that was fun yesterday. boss got married and I got blasted at our local bar after coming home from the hotel.
<12> the hotel can't make a ****ing bloody mary to save their lives... they didn't use vodka but they had the gall to use gin in theirs!
<12> lol
<13> PolarWolf: there?
<14> anyone available to give me some help ?
<12> OxD, w00t! bouncing titties!
<11> ares2007: Go to http://www.catb.org/~esr/faqs/smart-questions.html
<15> smsie: hmm?
<14> reality tks
<12> reality, ****!
<12> give that guy the darwin award!
<11> cappicard: As I said... FTW
<11> Anybody running Skype?
<11> And isn't in the US?
<10> not since eBay acquired them
<11> I need somebody to test my skype to mobile phone gateway
<11> Trying to see if it's going to dock me skypeout credits or not (which it shouldn't seeing as I'm doing it by routing it to a US phone number from within the US which is supposed to be free until December)
<6> what the ****
<6> it took it 36 hours to send an e-mail
<15> Why the **** is / full *again*
<7> PolarWolf: because / is too small
<6> i need to throw around some quotes on our boxes at work
<6> i've personally filled / twice just this past week because /home is on it
Return to
#linux
or
Go to some related
logs:
OK GO - Invincible mp3
#java
sslport directive apache
#linux
ERROR: The DSP Fileinfo.dsp does not exist.
#windows
cadpat friendster
#teens
1923 s-a nascut un mit
#linux
|
|
