[13:38] <snap-l> ebarch: Thank you. :)
[13:42] <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:43] <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:44] <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
[19:07] <snap-l> Back
[19:09] <rick_h__> party!
[19:17] <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:20] <rick_h__> very cool
[19:33] <snap-l> Now catching up on e-mmail
[20:12] <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:22] <Blazeix> most DBs do have some sort of 'all' statement, but I've never used it.
[20:37] <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:39] <rick_h__> yea, http://paste.mitechie.com/show/304/ works to get me the id of the one I want
[20:40] <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:41] <snap-l> pindboard?
[20:42] <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:46] <rick_h__> http://paste.mitechie.com/show/306/ these two queries should be equiv?
[20:47] <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
[21:04] <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:06] <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:07] <snap-l> nice!
[21:08] <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:12] <rick_h__> yea, working to get things ready for MUG
[21:48] <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:52] <rick_h__> yea, sounds like it went pretty well
[23:13] <TeamXlink> lol
[23:13] <TeamXlink> http://images.4chan.org/b/src/1304287882105.jpg