| snap-l | ebarch: Thank you. :) | 13:38 |
|---|---|---|
| rick_h__ | how goes the festivities? | 13:42 |
| snap-l | 'twas good | 13:42 |
| snap-l | Didn't go to many panels, but the ones that I was part of | 13:42 |
| rick_h__ | cool | 13:42 |
| snap-l | Though we went to the first-half of the Smithee awards | 13:42 |
| snap-l | bad movie clips with a voting component | 13:42 |
| snap-l | Worst Monster, Worst Special Effect | 13:43 |
| rick_h__ | hah, nice | 13:43 |
| snap-l | Yeah, a lot of fun | 13:43 |
| snap-l | Talked with tjagoda | 13:43 |
| rick_h__ | uh oh, you guys get him some help? | 13:43 |
| snap-l | Heh, nah | 13:44 |
| snap-l | Just asked if he used the tablet to check on RIM's stock price | 13:44 |
| snap-l | That was the worst I dished out. :) | 13:44 |
| rick_h__ | hah, good stuff | 13:44 |
| rick_h__ | hopefully he's not an owner of too much of that stuff | 13:44 |
| snap-l | heh | 13:44 |
| snap-l | Back | 19:07 |
| rick_h__ | party! | 19:09 |
| snap-l | Yeah, I'm a bit tired. :) | 19:17 |
| snap-l | Lots of goodies from the con, though | 19:17 |
| snap-l | and some good info | 19:17 |
| rick_h__ | very cool | 19:20 |
| snap-l | Now catching up on e-mmail | 19:33 |
| rick_h__ | man, my sql-fu is hitting a wall | 20:12 |
| rick_h__ | anyone have a clue for the opposite of in() where I want something more like all() or something? | 20:12 |
| Blazeix | most DBs do have some sort of 'all' statement, but I've never used it. | 20:22 |
| snap-l | I think you have to nest it perhaps? | 20:37 |
| rick_h__ | it's a mess, thought I almost had it but meh | 20:37 |
| rick_h__ | I found some page on relational divisino | 20:37 |
| snap-l | select * from blah where id in (select id from blah) | 20:37 |
| snap-l | or some shit like that | 20:37 |
| rick_h__ | yea, http://paste.mitechie.com/show/304/ works to get me the id of the one I want | 20:39 |
| rick_h__ | but trying to represent it without the subquery: http://paste.mitechie.com/show/305/ | 20:40 |
| rick_h__ | that's not coming out right | 20:40 |
| snap-l | I'm not sure how you can do it without the subquery. | 20:40 |
| snap-l | pindboard? | 20:41 |
| rick_h__ | just happened to be an exmaple from the set that worked | 20:42 |
| rick_h__ | trying to get all bookmarks with all of the tags specified | 20:42 |
| rick_h__ | there's one with the tags hosting and pinboard | 20:42 |
| rick_h__ | http://paste.mitechie.com/show/306/ these two queries should be equiv? | 20:46 |
| snap-l | believe so | 20:47 |
| rick_h__ | oh lol | 20:47 |
| rick_h__ | misread the typo there | 20:47 |
| rick_h__ | right, no d there | 20:47 |
| rick_h__ | oh crap I think I've got it | 21:04 |
| rick_h__ | bwuhahahahaha | 21:04 |
| snap-l | rick_h__: What was the problem? | 21:04 |
| rick_h__ | just a matter of getting the query put together right | 21:06 |
| rick_h__ | was missing a join condition I thought it was going to do auto for me | 21:06 |
| snap-l | Ah, that makes sense | 21:06 |
| rick_h__ | http://paste.mitechie.com/show/307/ | 21:06 |
| rick_h__ | :) | 21:06 |
| snap-l | nice! | 21:07 |
| rick_h__ | ugh things are getting messy, but at least now has tag filter bar, completion of tag names as you type, and ajax results | 21:08 |
| snap-l | I'm sure it'll get cleaned up soon | 21:08 |
| rick_h__ | yea, working to get things ready for MUG | 21:12 |
| snap-l | There were 64 people in the Natty Panel | 21:48 |
| snap-l | 19 max in the Podcasting talk | 21:48 |
| snap-l | Pretty happy about that. | 21:48 |
| rick_h__ | yea, sounds like it went pretty well | 21:52 |
| TeamXlink | lol | 23:13 |
| TeamXlink | http://images.4chan.org/b/src/1304287882105.jpg | 23:13 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!
