| 04:29.39 | Juggie | jsmith-zzz, rox bought like 150$ of books at powells |
| 04:29.57 | Juggie | most of them @ the tech one. |
| 07:47.07 | *** join/#asterisk-doc oej (n=olle@1mldj7l.ip.ssc.net) |
| 08:30.35 | *** join/#asterisk-doc oej (n=olle@1mldj7s.ip.ssc.net) |
| 10:58.59 | jsmith | Juggie: I told you so! |
| 10:59.08 | jsmith | Hello oej! |
| 10:59.35 | oej | Afternoon |
| 11:46.16 | *** join/#asterisk-doc lmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 11:46.16 | *** mode/#asterisk-doc [+o lmadsen] by ChanServ |
| 15:24.53 | Juggie | she was crooked with me this morning though because i got to the airport after she was ready |
| 15:25.18 | Juggie | but her flght got in 20min early... and she is also crooked because i think i'm alergic to cats so i kicked the cat out of our bedroom |
| 15:25.26 | Juggie | overall just bitchy :) |
| 15:25.51 | Juggie | my eyes have been bloodshot and like irritated for more then a month |
| 15:25.58 | jsmith | Juggie: But at least you're not a bachelor anymore |
| 15:26.26 | Juggie | haha |
| 15:26.46 | Juggie | life was simpler then |
| 15:27.04 | Juggie | i love my gf, but the only reason she has a cat is because i love her |
| 15:27.07 | Juggie | because i hate cats |
| 15:34.40 | Juggie | though if i didnt let her get a cat i'd probally be single |
| 15:48.44 | lmadsen | gotta draw the line somewhere :) |
| 16:14.56 | lmadsen | jsmith: what do you use to clean your macbook? |
| 16:15.08 | lmadsen | I have a lot of 'oils' on the keyboard and wrist rest |
| 16:15.17 | ctooley | lmadsen, a linux CD? |
| 16:15.26 | ctooley | Or are you talking about the device itself? |
| 16:15.34 | lmadsen | I'm talking about the casing |
| 16:17.18 | jsmith | lmadsen: It's probably not ideal, but I use glass cleaner |
| 16:17.31 | lmadsen | makes sense |
| 16:54.30 | *** join/#asterisk-doc km2 (n=x@c-24-23-255-173.hsd1.ca.comcast.net) |
| 16:57.48 | Juggie | yay i have an eye doc apointment |
| 16:57.49 | Juggie | next week |
| 16:57.49 | Juggie | to find out if i have an eye infection or alergies |
| 17:12.30 | lmadsen | oh fun stuff |
| 17:13.56 | Juggie | ya, well i'm just happy to get it so i can figure out whats going on |
| 17:24.56 | lmadsen | jsmith: ping? |
| 17:25.04 | jsmith | lmadsen: pong |
| 17:25.12 | lmadsen | SQL question for you... |
| 17:25.40 | jsmith | Sure! |
| 17:25.45 | lmadsen | I'm building a view via a SELECT statement... and I want a column to always exist, but I only want it populated with the values from another table (which are being brought in via a JOIN) only when another column is set to '1' |
| 17:25.54 | lmadsen | I should totally know how to do this... but it's friday... :) |
| 17:26.12 | jsmith | COALESCE |
| 17:26.17 | lmadsen | aha |
| 17:26.22 | lmadsen | goes to w3schools |
| 17:26.40 | lmadsen | thx! |
| 17:27.27 | file | jsmith: you are so knowledgeable |
| 17:28.03 | jsmith | file: -ERETRY |
| 17:28.10 | jsmith | file: Wrong! |
| 17:29.08 | lmadsen | hrmmm... |
| 17:29.14 | lmadsen | are you sure I want to use coalesce? |
| 17:29.23 | lmadsen | from the examples... it just returns the first non-null value.... |
| 17:30.07 | lmadsen | example: I have an 'email' field, and I only want to populate the 'vm_email' field in my view when 'vm_email_notify' is set to '1' |
| 17:30.43 | lmadsen | maybe I need to find better examples :) |
| 17:31.18 | jsmith | Oh, right |
| 17:31.24 | jsmith | You just need a simple CASE statement then |
| 17:32.10 | lmadsen | aha... I see an example |
| 17:34.48 | jsmith | SELECT email, CASE WHEN vm_email_notify = true THEN vm_email ELSE 'bob@example.com' END FROM table; |
| 17:35.25 | lmadsen | SEw00t! |
| 17:35.29 | lmadsen | yep, I just figured that out :D |
| 17:35.42 | lmadsen | like... right as you hit enter pretty much :) |
| 17:35.53 | lmadsen | CASE WHEN `ast_user`.`vm_notify_via_email` = '1' THEN NULL ELSE `ast_user`.`email` END AS `email` |
| 17:36.12 | jsmith | Uh, you've got that backwards I think |
| 17:36.35 | jsmith | You're saying if vm_notify_via_email is set to 1, to *not* return the email. |
| 17:38.48 | lmadsen | haha, you're right -- which I also just realized :) |
| 17:39.33 | lmadsen | much better |
| 22:05.12 | jsmith | ~buy lmadsen beer bottle |
| 22:05.12 | jbot | ACTION goes to S-Mart and gets a dozen beer bottles for lmadsen |
| 22:05.23 | lmadsen | lol |
| 22:05.37 | lmadsen | I already have lots of empty bottles |
| 22:06.07 | jsmith | ~buy lmadsen garbage sack |
| 22:06.08 | jbot | ACTION goes to S-Mart and gets a dozen garbage sacks for lmadsen |