| 06:57.07 | *** join/#asterisk-doc oej (n=olle@90-84-254-204.ip.sipit.net) |
| 13:26.31 | *** join/#asterisk-doc lmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 13:26.31 | *** mode/#asterisk-doc [+o lmadsen] by ChanServ |
| 15:12.58 | *** join/#asterisk-doc codefreeze-lap (n=murf@72.21.67.40) |
| 16:40.58 | Juggie | yeeehaw |
| 16:46.32 | jsmith | Juggie: Becoming a cowboy? |
| 16:46.49 | jsmith | Juggie: Buy yourself some Wranglers and a hat? |
| 16:47.12 | jsmith | is probably the only person in this channel to how how to saddle a horse |
| 16:48.39 | ctooley | jsmith, of that, you can be sure you are wrong |
| 16:49.09 | jsmith | ctooley: Glad to hear it :-) |
| 16:49.27 | jsmith | codefreeze-lap probably knows how to as well, come to think of it |
| 16:49.27 | ctooley | Not only can I saddle one, I can vaccinate calfs from one. :) |
| 16:49.40 | ctooley | errr calves |
| 16:49.44 | jsmith | ctooley: Right on! |
| 16:49.53 | ctooley | is slightly incoherent. |
| 16:49.54 | jsmith | ctooley: I'm from Wyoming... they get called calfs a lot there :-p |
| 16:50.25 | ctooley | calfs are the muscles on the back of your legs, calves (or littuns) are young cattle. :) |
| 17:07.19 | codefreeze-lap | jsmith: my wife is the saddling expert. She uses me to tighten the various straps. I guess if the horse is going to kill someone, it's better if it were me. |
| 17:08.39 | codefreeze-lap | It's best to be riding in the saddle on the top of the horse, rather than hanging under the horse's belly. |
| 17:09.20 | jsmith | That was my problem growing up... my mom couldn't tighten the belly strap tight enough |
| 17:09.35 | jsmith | So I'd end up underneath the horse |
| 17:09.59 | codefreeze-lap | holding on for dear life, too, I'd imagine! |
| 17:10.05 | Juggie | jsmith, nah... i just wanted to start a conversation |
| 17:10.09 | Juggie | and it would seem it worked! |
| 17:10.18 | jsmith | That it did |
| 17:10.25 | jsmith | codefreeze-lap: How much snow did you get? |
| 17:10.34 | jsmith | codefreeze-lap: Naw... I learned when to let go |
| 17:10.44 | lmadsen | JUMP! |
| 17:11.36 | jsmith | lmadsen: Jumping from a saddle is much harder than it appears in the movies |
| 17:11.45 | lmadsen | I can imagine |
| 17:11.45 | jsmith | has done all kinds of stupid things on a horse |
| 17:11.56 | lmadsen | I would think it'd be more like falling off than actually jumping from |
| 17:12.01 | codefreeze-lap | jsmith: in windy spots, 1.5 inches. In nice, quiet places, 4 foot drifts. So, it averaged out to 2 inches. But we couldn't get a vehicle out of the driveway for 3 days, I put the boys to work digging out. |
| 17:12.16 | jsmith | codefreeze-lap: Nice! |
| 17:12.19 | jsmith | misses the snow |
| 17:12.31 | lmadsen | only misses snow on ski hills |
| 17:30.15 | codefreeze-lap | Pretty much, only the places where it was piled up are still around. The grass is green, the trees, well, some took it better than others. It rained last night. Normal fall stuff around here. |
| 17:32.45 | Juggie | you got 2inches of snow and you coudnt get your car out of the driveway? |
| 17:34.21 | Juggie | one year i was in ottawa actually during the winter |
| 17:34.33 | Juggie | my parents gfot 650cm during that winter |
| 17:34.38 | codefreeze-lap | Juggie: About 10 4 foot drifts -- the driveway is lined with lilacs-- wind shadow. One was the entire length of one strip of the driveway. |
| 17:34.40 | Juggie | including one time when it snowed 75cm in a day |
| 17:35.08 | Juggie | codefreeze-lap, snow blower? :) |
| 17:36.29 | jsmith | Juggie: He's got kids to shovel the driveway |
| 17:36.29 | codefreeze-lap | Juggie: Waste of money, when you have a shovel and teenaged boys with muscle. |
| 17:36.30 | Juggie | ya my dad was a jerk too |
| 17:36.30 | Juggie | he used to make me mow like 1 1/2 - 2 acres w/ a push mower |
| 17:36.30 | Juggie | when i moved out |
| 17:36.30 | Juggie | he bought a ride on |
| 17:36.30 | codefreeze-lap | Hey, it's Jerk with a capital 'J', there buddy! ;) |
| 17:37.20 | Juggie | hah |
| 17:37.40 | Juggie | anyways 255inches in one winter is pretty nuts |
| 17:37.55 | codefreeze-lap | I shoveled one big drift all by myself. Wet, heavy snow. Just about killed me. I came in and said, I got the big one, the rest are yours. They had it clear in less than an hour. |
| 17:40.08 | codefreeze-lap | Marquette Mich gets like 8+ feet of standing snow every winter. I'd imagine you shovel until it fills in up above, and then you don't have to worry about it.... |
| 17:40.42 | Juggie | hah, awesome, just be happy you dont have to deal w/ this: http://stupidsnow.com/pictures/images/9452-Feb25_06845pm-snow-door-newfoundland-lesley-s.jpg |
| 17:42.27 | codefreeze-lap | lol, now that's a snow drift. Really, Wyoming hardly gets any snow accumulation at all. Mother nature just makes a little moisture here into quite a breathtaking display. |
| 17:42.44 | Juggie | i personally love snow |
| 18:21.14 | Juggie | jsmith, do you know how to do a self join |
| 18:21.32 | jsmith | Juggie: Sure... |
| 18:21.45 | jsmith | Juggie: I used to use them in MySQL to get around the lack of subselects |
| 18:21.52 | Juggie | eg, i have select * from table as t1, table as t2 |
| 18:21.59 | Juggie | table has a datetime field |
| 18:22.05 | Juggie | and i want to join on the common day of year |
| 18:22.18 | Juggie | so lets say there is data for year 2006,2007,and 2008 |
| 18:22.22 | Juggie | well day 50 will happen 3 times |
| 18:22.31 | Juggie | but for simplicitiy lets limit it to comparing two years |
| 18:22.48 | jsmith | Sure... a self-join is essentially a cross-product until you limit it with your WHERE clause |
| 18:22.53 | Juggie | i want to basically merge the two common days into one row so i can then spit out a comparison in php |
| 18:23.06 | jsmith | OK, now you've lost me |
| 18:23.12 | jsmith | Give me a few sample rows from your table |
| 18:23.14 | Juggie | ok lets say i've got this table |
| 18:23.22 | Juggie | its on a dif network would be a pain to paste |
| 18:23.26 | Juggie | but lets say its like this |
| 18:23.38 | Juggie | datetime,number of calls |
| 18:23.59 | Juggie | datetime looks like say, 2008-09-09 12:55:01, calls would be anything 50 100 whatever |
| 18:24.17 | Juggie | we have that stat over and over and over (for dif days, years, etc) |
| 18:24.25 | Juggie | so i want to basically compare the same day for last year |
| 18:25.18 | jsmith | Oh, I gotcha |
| 18:25.31 | jsmith | So you want Jan 1 2008 vs Jan 1 2007, etc.? |
| 18:25.48 | jsmith | And this is in MySQL or PostgreSQL? |
| 18:25.52 | Juggie | so if i did a select *, DATEPART(dy, t1.datetime), DATEPART(dy, t2.datetime) from table as t1, table as t2 where DATEPART(dy, t1.datetime) = DATEPART(dy, t2.datetime) |
| 18:25.58 | Juggie | mssql unfortunatally |
| 18:26.06 | Juggie | i'd get all the matching records |
| 18:26.12 | Juggie | but i need to get when there is no match as well |
| 18:26.37 | jsmith | You need a WHERE clause in there... otherwise you're going to get rows you don't want |
| 18:27.10 | Juggie | ya well i'm going to be limiting it by number and date range |
| 18:27.23 | Juggie | but is there a way to see the data that has no match |
| 18:27.38 | Juggie | lets say we have no sample for day 55 for the previous year but we have one for this year |
| 18:29.00 | jsmith | Hmmmn... let me see what I can do. |
| 18:29.28 | Juggie | whats 'where's sister |
| 18:29.35 | jsmith | HAVING |
| 18:29.38 | Juggie | right... |
| 18:29.48 | Juggie | it bugs me doing an 'as varname' |
| 18:29.51 | Juggie | and then i can't access it |
| 18:42.15 | Juggie | ahha |
| 18:42.18 | Juggie | i think i might of got it |
| 18:42.28 | Juggie | see your gtalk i can use web on the other network |
| 19:09.36 | jsmith | OK, hold on... that's on another machine |
| 19:09.40 | jsmith | (me has been on a phone call) |
| 19:30.51 | *** join/#asterisk-doc ctooley_ (n=ctooley@doc-24-32-196-69.concordia.ks.cebridge.net) |
| 21:37.06 | *** join/#asterisk-doc Alric (n=Alric@masq.hyperusa.com) |
| 21:37.28 | Alric | flags lmadsen down. |
| 21:37.46 | jsmith | Alric's alive! |
| 21:37.55 | Alric | Indeed. |
| 21:38.05 | jsmith | I thought the politics in Texas would have been too much for him to bear |
| 21:38.10 | Alric | lmadsen: "4,5k" or "4.5k" |
| 21:38.40 | jsmith | Alric: "4.5k" |
| 21:38.44 | jsmith | thinks |
| 21:38.45 | lmadsen | 4.5k |
| 21:38.50 | lmadsen | 4,5k is french |
| 21:38.55 | jsmith | Only the Eurpeans do "4,5k" |
| 21:38.57 | lmadsen | and other european countries |
| 21:39.13 | Alric | Yeah, but you Canadians seem to like your European Overlord's way of doing things. |
| 21:39.35 | Alric | Just wondering if you'd come across to the way of freedom and what not ;) |
| 21:39.50 | jsmith | They have lots of freedom in Canada |
| 21:40.01 | jsmith | Including the freedom to elect another Conservative minority gov't, apparently |
| 21:40.33 | jsmith | But I shouldn't be complaining about Canadian politics, as it bothers me to no end that Europeans are calling my congressmen to tell them how to vote |
| 21:40.56 | lmadsen | european overlords? |
| 21:41.01 | lmadsen | shakes his head |
| 21:41.04 | Alric | Which congressmen? |
| 21:41.13 | Alric | lmadsen: colour, centre... enough said. |
| 21:41.26 | Alric | Welcome to colonial rule ;) |
| 21:41.44 | *** kick/#asterisk-doc [Alric!n=Leif@asterisk/documenteur-extraordinaire/blitzrage] by lmadsen (colonial rule this) |
| 21:42.23 | jsmith | Alric: When the House was debating the ol' "700 Billion of Your Tax Dollars Down the Toilet" bill... several thousand people called the US House and US Senate to influence the vote |
| 21:42.33 | jsmith | Oh man... now I have to repeat myself when he gets back |
| 21:42.39 | *** join/#asterisk-doc Alric (n=Alric@masq.hyperusa.com) |
| 21:42.44 | Alric | did I just get kicked? :D |
| 21:42.52 | lmadsen | I don't think so |
| 21:42.53 | Alric | lol |
| 21:43.13 | Alric | Trillian doesn't handle those things too well |
| 21:43.40 | jsmith | Alric: When the House was debating the ol' "700 Billion of Your Tax Dollars Down the Toilet" bill... several thousand people called the US House and US Senate to influence the vote |
| 21:44.46 | jsmith | wonders who would have voted for it if they would have put it in terms of "We can bail out the markets, but when you taxes are due in April, you'll have to pay an additional $1500 per person" |
| 21:44.56 | jsmith | Because that's pretty much what it amounts to |
| 21:46.37 | Alric | But jsmith, it will let those poor people who signed up for homes/loans they couldn't afford keep their houses! |
| 21:47.02 | Alric | The ones who were chained to the desk with a gun to the head until they signed on the dotted line! |
| 21:50.58 | jsmith | I'm not concerned that they signed on the dotted lines |
| 21:51.31 | jsmith | I'm concerned that I have to pay an extra $6k (or more, when all is said and done) to make no permanent effect in the markets |
| 21:52.51 | Alric | Yep |
| 21:52.53 | Alric | It sucks |
| 21:53.17 | Alric | Politicians love OPM though. |
| 22:03.32 | *** part/#asterisk-doc Alric (n=Alric@masq.hyperusa.com) |
