misslynx: (Quote - brain dead)
Challenge #10 in the Last Author Standing contest I'm in is now open for voting. Stories (there are six) and voting post can be found here.

The prompt this time was the word "alpha", and people took it in a number of interesting directions...

. . .

In other news: I am incredibly tired, and even though I am not yet quite finished sorting out all the assorted varieties of fail that resulted from upgrading a fairly large and complex client site from Drupal 5 to 6, I think I am going to have to go to bed early. Today's plans originally included editing work at my dad's place, laundry, and going to the Freaky Fountain launch party, but absolutely none of that actually happened. The laundry, at least, will happen tomorrow, I suppose. Right now I don't think I'm up for much more than walking Kiska, some rooibos tea, and bed.
misslynx: (Default)
It's that time, folks - four weeks since the last one, rather than two, this time.

The entries for the latest challenge in the Last Author Standing contest, Original Fiction version ([livejournal.com profile] originalfic_las) can be found here, along with the voting post (I have belatedly realized that linking to the day in the community's archives gives you handy access to both posts in one place).

We are down to only six(!) entries now, which means, if I understand it all correctly, that after this one we will be in the final stretch where no one is allowed to use "skips" any more (basically, free passes that you get for various reasons that allow you to skip a challenge without being disqualified). I'm kind of pleased to have made it this far, considering that we started out with 52 entries in the first challenge. Though of course I am hoping to make it yet further... I guess we'll see.

Anyway: as before, voting is open to anyone with an LJ account, and no, I can't tell you which is mine (and would have preferred not to even if it was allowed, as I'd rather know that if I get votes, it's because people genuinely liked what I wrote, and not just out of loyalty). So: go read, go vote!

. . .

In other news, I have been in a huge work crunch for the past week or so, getting very little sleep - I am actually going to be going to bed shortly after posting this, and that will be the earliest night I've had in probably 9 or 10 days. And yes, it's 3:15 am. These days, getting to bed before the sun comes up feels like luxury.

Also, I would really appreciate it if my DSL connection would stop flaking out on me. All day today, it's been up and down like a yo-yo. Very annoying. Right at the moment it is down, but if you see this post timestamped tonight, you'll know it came up before I went to bed. If tomorrow, then apparently it didn't.

. . .

Also, random question: would anyone happen to know of any children's books with steampunk elements to them? By "children's" I don't mean "young adult" books written for teenagers, but books aimed at kids whose ages are still a single digit, and not necessarily a high one. The Lynxcub picked up a library book I had out recently which while geared toward adults, had a few illustrations sprinkled through it, and started asking me lots of questions about the pictures - in particular, about airships.

I did try just googling "steampunk children's books", but most of what I found was YA or at least geared toward considerably older kids than him. That said, he does sometimes like hearing stories that are meant for at least a somewhat older age range - I was able to read Alice in Wonderland to him - but there are limits. Among them, he still requires there to be interesting pictures in order for a book to hold his attention (preferably, at least one per double-page spread, otherwise he may get antsy and start trying to turn the page while I'm still reading).

So... any steampunk-ish books out there for younger kids?
misslynx: (Quote - flamethrower)
So;
  1. The e-mail problems that had been happening for the past two days ( can't recall now if I posted about that here or on FB or both) are apparently NOT entirely sorted out, or at least not for all clients. Two client have not been able to receive mail all day today, and even my own mail is coming in sort of random bunches here and there throughout the day.

  2. My apartment building is filled with nasty solventy fumes from the renovations happening on the restaurant downstairs, and when I and my upstairs neighbours both complained to the building manager, he said that the company had told him that what they were using was water-based and non-toxic and the only thing anyone should be smelling is water and sawdust. Uh, right. Because that would totally account for the entire building reeking like paint thinner. It's relatively bearable IF you keep all the windows at least partially open, but it's bloody cold outside, and now bloody cold inside as well.

  3. I have to finish uploading a ton of pictures to a magazine site within the next hour, which is going to be next to impossible, but I haven't had any bloody TIME today.

  4. I am dealing with all this on only three hours of sleep.

The only good sides I can see to all this at the moment are that:
  1. I got to know my upstairs neighbours better, and the Lynxcub was able to spend some time playing with their kids, and

  2. Having it freezing cold in my apartment keeps the hot flashes to a minimum. Now they're more like lukewarm flashes.

So, yeah. Today: fired.
misslynx: (Me - w/ Kiska (on couch))
For some reason, I found today's Wondermark strip particularly amusing, in a bittersweet sort of way:

'Come along, Chadwick,' said Father, pulling the boy roughly by the hand. 'But Papa!' came the plaintive wail--'the cows, the cows, the cows, the cows!'

Thinking back to what I wanted to be when I grew up, at various stages of my childhood and adolescence, I can recall the following: actress, artist, anthropologist, astronaut, cat breeder, computer programmer, dog breeder, falconer, fashion designer, filmmaker, full-time political activist, lawyer, physicist, playwright, professor, toy designer, veterinarian, wildlife biologist, writer and zookeeper. And probably some more that I can't think of right now.

I suppose my actual career (web designer, which did not exist as an option until I was at least 30) could be said to draw on the artist and programmer choices to some extent. And while I've never (yet) been a full-time writer or anything close to it, I have at least done a certain amount of writing and gotten some of it published. But really, I don't think the life I have now exactly measures up to any of my childhood career projections.

Which makes me curious: how about the rest of you? What did you want to be when you grew up? And are you doing anything close to it now?
misslynx: (Default)
Note to self: when exhausted and massively short on sleep due to a brutal work crunch may not be the best of all possible times to keep compulsively reading news coverage about the situation in Haiti. One's usual emotional shock-absorbers are not functioning at full capacity in that state, and everything hits even harder than it ordinarily would, and I am the not the sort of person who can read stuff like that and remain unaffected even at the best of times.

Interesting article in the Toronto Star Underlying racism infects crisis response: study.

Unfortunately, the study's findings pretty accurately describe the mentality of a lot of the commenters on news stories on the Star site and elsewhere, which make me want to set people on fire. More so than I usually do, that is. Maybe one of my new year's resolutions should be stop reading the comment sections on news sites. Nothing good ever comes of doing that. Even when I can bring myself to post comments challenging all the reactionary crap that gets posted there, it feels like trying to stem a tidal wave of shit with a paper fan or something.

. . .

But in the vein of trying to do something constructive about the situation instead of just whimper and rock myself, this is a reminder that I am auctioning off three custom-written stories via the [livejournal.com profile] help_haiti community. One fairy-tale based, one mini-legend like the ones I've done in [livejournal.com profile] thousandcats, and one that's more or less anything goes.

Winning bidder on each one donates the amount of their bid to any recognized charity doing relief work in Haiti, and forwards a copy of the receipt. Only received one bid thus far (on the fairy tale), so I'm hoping to stir up a little more interest, so as to actually generate some useful amount of donations.

Note: if you do decide to bid, make sure you're clicking on the "Reply" link right under my comment with the offer, and not on the "Leave comment" link at the bottom of the comment thread, otherwise your bid will go in as a comment to the entire 3000-comment thread rather than coming to me specifically, and I'll never find it.

. . .

BTW, I'm finding the level of activity in that community to be really inspiring. There are hundreds and hundreds - maybe more like thousands - of things being auctioned, from books and stories to homemade cookies, souvenirs from all the different parts of the world that contributors to it live in (there's a lot of "A Box of [place name]" items that are basically collections of random stuff from the places in question - I was very tempted by the Box of Holland, which included stroopwafels among other things), graphic design and editing services, crocheted Cthulhus, PHP scripts and web hosting.

Yesterday, the moderator posted a request for people to translate the community FAQ & userinfo into other languages, and within just a few hours there were versions of it up in German, French, Spanish, Dutch, Polish, Japanese, Russian and Tagalog. A day later, that's been supplemented with Hebrew, Italian, Catalan, Welsh, Hungarian, Portuguese and Greek, and people are working on Korean and Chinese.

Note to self #2: more time perusing communities where people are coming together to do helpful and positive things, and less time looking at comments on news articles makes for a happier and more productive Lynx, with more faith in humanity.

. . .

In related news, I am delighted to report that I am still, for the moment, the top bidder for the crocheted dinosaur I want to get for Aidan.
misslynx: (Default)
Found via [livejournal.com profile] thewronghands:

Please design a logo for me. With pie charts. For free.

This is quite possibly the funniest thing I have seen on the internet since... I don't know. Maybe ever. I think I scared my pets laughing. All graphic designers need to read it, now.

. . .

And now I'm going to bed.
misslynx: (Default)
Being as I am primarily a Mac person, and secondarily a bit of a UNIX person, at least via working on remote web servers, I am not always up on matters in the Windows world except as I occasionally encounter them via clients and friends needing help.

Two Windows-related questions have arisen recently, and if anyone out there who's better versed in that OS than I am knows the answers, that would be very helpful:
  1. Is there a free or inexpensive text editor out there for Windows that's similar to BBEdit on the Mac? By which I mean: geared toward web designers and/or programmers, and does stuff like highlight tags in a different colour, and maybe basic syntax-checking and stuff like that?

    I should add: I know there a million and one cheap web design programs for Windows. What I'm mainly looking for (for a particular client) is one that is NOT a WYSIWYG editor, just a text editor, and is not going to throw all kinds of crap into the files or choke on the bits of PHP they contain. And basically, what the Windows geeks on my friends list would most recommend of whatever assortment there are.

  2. One thing I've been highly frustrated with when working on my dad's textbook manuscript (on his computer) is font handling in Windows. It seems like with most font families that have a number of different weights and styles (i.e light/book/demi/bold/black, etc.), Windows insists on treating each one as a wholly separate font instead of as varieties of the same font, so if you've got a document set in a particular font, and you apply some bold here and some italics there, it does NOT display those in the actual bold and italic versions of that font, but in a sort of fake-bold and fake-italic that look like ass and disappear when you try to print the document or convert it to PDF. In particular, this seems to happen with most of the higher-quality PostScript fonts.

    The crappy TrueType fonts that came with programs like WordPerfect (which he still uses in preference to MS Word, meaning I have to work with it too when working on his manuscript) do display as proper font families, but are mostly boring and would not be my first choice for the print version of the manuscript.

    I wouldn't be as annoyed about this if it was just a matter of the manuscript that was going to be submitted to publishers, because they're probably used to seeing everything in Times New Roman, but there's also a work-in-progress version that he gets printed every year by the York bookstore and uses as a text in his courses, and I'd like it if that could look decent.

    Does anyone know how to solve this problem? Is there some way of making Windows realize that the different versions of a font do in fact belong together?

    If we had more time, I might just try flowing the whole thing into InDesign and dealing with the font issue from there, but we're on a really tight deadline for this year's edition of the in-progress text, and everything but the cover is probably going to be printed straight from WP. Which, annoyingly enough, has no way of searching for applied styles of a font. You can search for, say, Franklin Gothic or even Franklin Gothic Italic, but NOT for Franklin Gothic with the italic style applied. Unless you are searching for a specific piece of text in that font and style - THAT it will let you do. But it won't let you just search for all instances of that style having been applied to that font.

    Did I mention I hate Word Perfect? I tend to hate word processors in general, mainly for the (probably irrational) reason that they are not page layout programs and won't let me do everything I can do in Quark or InDesign. But I think I hate WordPerfect more than most.
misslynx: (Good Day)
Well, I went up the new post office on Eglinton today (not precisely a new post office, I suppose, but the one to which they relocated all the PO boxes from the Wychwood PO). It's in a tiny, hole-in-the-wall photocopy shop at Bathurst & Eglinton. The ride up wasn't too bad despite being mostly uphill - I think I have [livejournal.com profile] optimystik to thank for that, as hills have been much more manageable since he raised my bike seat and pumped the tires a little fuller.

While waiting, I overheard that the move is actually temporary - they're putting a new post office on St. Clair, though I don't know if it's going to be a new facility in the same location, or a different one. So apparently the relocation is only for 4-6 months or something like that, after which point the boxes will be moved to the new PO on St. Clair, or at least so the staff at the Eglinton post office have been told. So maybe that's not so bad.

However... The really sucky thing about it is that while they supposedly transferred everyone's mail up to the new place, they have no mail on file for me. At all. This despite the fact that two clients have told me they sent me cheques in the past couple of weeks, long enough ago that they should have been there. It was when going to the post office with the expectation of picking up those cheques on Friday that I found out about the move. And now: no mail.

If it was just one cheque that I'd expected that wasn't there, I'd be more inclined to think that maybe it was maybe either delayed, or the client didn't actually send it. But two at once makes me suspicious. Particularly since it's been about two weeks since I last checked my mail there and you'd think there'd at least be some junk mail or a bank statement or something... So I strongly suspect my mail got lost in the shuffle. Grrr.

I need those cheques! It's not like even the two together were for all that much, or would make more than a small dent in my current stack of unpaid bills, but at this point every little bit counts. Now I have to decide whether to wait a little longer and see if they turn up, or just contact the clients, explain the situation, and get them to put stop-payment orders on the original cheques and issue new ones, which I'd really rather not have to do if at all possible. Grrr grrr grrr grrr.

The staff at the new post office, for what it's worth, seemed very nice, and spent quite some time searching everywhere for my mail, not just in the file box where all the mail from Wychwood PO was supposed to be, but in all kinds of other places. But they didn't find anything.

All of this is making me think that maybe, despite the possibility of my PO box moving back down to my neighbourhood in six months or whatever, I might be better off without it, and just have payments sent to my home address. People don't seem as inclined to look askance at a business not having a mailing address listed on their web site or business cards any more, and I'm OK with my clients having my home address.

So, question for the Internet masses: if you were contemplating hiring a web designer, would you (a) notice, and/or (b) care if there was no postal address listed on their web site or business cards?
misslynx: (Aidan & me w/ dandelion)
Just a short update, because I am tired and want to go to bed.
  1. First and most important:

    Happy birthday, Aidan!

    Two years...! Sometimes it seems like you've been in my life a lot longer, and it's hard to imagine the time before, and other times it seems like only yesterday that you were learning to crawl - or just being born. But either way, happy birthday to the boy who is unfailingly the brightest spot in my life.

  2. Sadly, I did not make it out to the Masala! Mehndi! Masti! festival this weekend, mainly because of the incredible weather suckage (rain rain rain rain rain punctuated by thunder and lightning and more rain, mostly). Oh well... Apparently they are going to have a winter version of it as well this year, so I don't have to wait a whole year for the next one.

    And the weekend was not entirely without South Asian influence, because I got Aidan veggie pakoras at Savera (the new Indian restaurant on St. Clair, which is awesome, BTW, and anyone in the area should definitely check it out) for a birthday treat.

  3. Was astonished and somewhat horrified on Friday to find that the post office where I have had my business PO box for the past 12 years is now gone, with no warning. minor venting )
That is all. Sleep now.
misslynx: (brain dead)
I've been in a huge work crunch lately and have just done two consecutive all-nighters, at least if all-nighter is defined as staying up until the hours when most people are getting up, and then trying to squeeze in a few hours of sleep in the morning, as opposed to not sleeping at all.

As a result, I am not exactly brimming with energy. However... I am very definitely going to Funkasia tonight! It's been the highlight of Pride weekend for me ever since I discovered it, and more so now that I had a chance to get well and truly hooked during its brief duration as a monthly night last fall, and have been in withdrawal ever since.



More info at the web site I built for them: http://www.funkasia.ca
And on Facebook: http://www.facebook.com/home.php#/event.php?eid=96431205739
misslynx: (Default)
Typocalypse

This may be one of those only-appeals-to-graphic-designers things, but I was laughing out loud at some of those. I don't know whether to be disappointed or relieved that none of my particular favourite fonts were included.

. . .

BTW, sorry to have more or less disappeared on people lately (in RL as well as on LJ). Due to having been sick on and off for so much of the winter and thus falling behind on work, I am now drowning in past-due bills, and trying to work my ass off and pull in as much money as humanly possible before any Very Bad Things happen as a result. There are a number of hard deadlines coming up for things to be paid by, and I will probably re-emerge into the world of the living once those are past. Assuming I've met said deadlines successfully, that is...
misslynx: (With Kiska (in chair))
Well, let's see...
  • Marathon work binge involving very little sleep for a long time? Check.
  • Exposure to illness via small child? Check.
  • Hitting point of wondering just how long I can keep up the pace I was? Check.
  • Starting to get at least beginning cold symtpoms, though not too severe yet, and because they weren't severe, brushed them off for the most part and didn't ease up on my activity level as much as I should have? Check.

What do these things add up to?

The beginnings of a painfully bad cough last night, followed by waking up this morning feeling like death warmed over, with my lungs and head both feeling like they're packed full of some odd blend of cotton wool, sandpaper and industrial waste.

I pretty much knew this would happen, or at least was highly likely to happen. It's not like I haven't had this same pattern recur many times before. And I do not really meet the "doing the same thing over and over and expecting different results" definition of insanity - being only slightly insane, I usually do the same thing over and over while expecting most likely the same results, yet nonetheless holding onto that small shred of hope that says that maybe I'll get away with it this time... Clearly, I didn't.

Phoned my dad, told him I wouldn't be able to come do editing today, then crawled back into bed and didn't get up again until 2pm. Walked dog very briefly while still in pajamas (a long winter coat hides a multitude of sartorial sins).

Will probably not be doing much this weekend other than staying in, finishing what work I can during periodic bouts of semi-alertness, and wishing Khmer Thai has not chosen this particular time period to be closed for two weeks. I would kill for some Thai hot and sour soup right now, and the soups they make are gigantic concoctions that are more like stew than soup, with one order being big enough to make two full meals out of. Not to mention incredibly delicious. Well, there are other Thai restaurants in the area, even though they are not Khmer Thai and thus not the same damn it, so perhaps if I feel up to it later I will try and drag myself to one of those and get some takeout.

The most aggravating thing about Khmer Thai being temporarily out of commission is that I found this out by way of trying to phone in an order that [livejournal.com profile] cleasai was going to pick up and bring to me, along with dog food that I'd been meaning to buy earlier this week and hadn't gotten around to... Oh well, at least Kiska will be well fed.

And at least I will be getting some sleep. I actually sometimes find that I weirdly enjoy getting sick when I've been really busy and running myself ragged, because it forces me to take a break, and gives me a sound reason for doing so so that I don't feel like a slacker. So in a strange sort of way sickness = luxury. It's kind of like an unexpected vacation, but with much lower energy levels, and more coughing.
misslynx: (needs must)
I can has 36 hour day plz?

Or just stop time for a week or so while I get caught up. That would do it too...

Maybe more like a month.
misslynx: (Default)
Huge work crunch, got 3.5 hours sleep in the last 40 hours or so, and those after staying up last night until 11 this morning working. So not much time to update...

However, I just have to say that this is quite possibly the finest ad I have ever seen in all my days on The Interwebs. Seriously, I want to print it out and frame it or something.

Its destination is here, for anyone who wants to have a look. But the actual site doesn't look nearly as spiffy as that insane ad.

(I would have just put a link to the page I saw it on, but I think the ads rotate randomly, so it might not be there next time.)
misslynx: (Angry cat)
(This is primarily what I would like to say to people sending in tech support queries to me for sites I maintain, but it probably applies elsewhere as well...)
  1. Do not assume that because you ran into a problems with a site, that therefore everyone must run into the exact same problems and that the site is therefore horribly broken and must never have been tested. You can test a site 500 times and not necessarily replicate every single bizarre thing every end user might think of submitting to it...

  2. You might want to at least consider, before pronouncing the site "broken", "badly designed", etc., the possibility that you might have done something wrong. Especially since this turns out to be the case about 80% of the time. Yes, a well-designed site should try to anticipate the various ways in which end users might break it by doing stupid things, but no one can fully anticipate every bizarre thing that anyone might do to their web site. As the saying goes, every time you think you've made a system idiot-proof, someone comes along and builds a better idiot. That better idiot might, in fact, be you.

  3. Do not complain that the site simply "didn't work", "shut you out", "is broken", or that "something went wrong", without providing any further details, and expect a helpful response. Contrary to popular opinion, web geeks do not diagnose technical problems through our amazing psychic powers. Generally, we require actual information on what happened. Shocking but true.

  4. The above applies especially when right before the link to the support address, it says to include as much detail as possible, particularly the text of any error messages you may have received.

    and last but definitely not least...

  5. The level of snarkiness and/or verbal abuse in your message is likely to be inversely proportional to my desire to help you find a solution to your problems.
This public service message has been brought to you by the department of STFU.
misslynx: (Default)
This isn't a whole lot of notice, but for you local folks, there's going to be a BPAL meet'n'sniff this Sunday at 3pm, at Java House on Queen St. (at Augusta, halfway between Bathurst and Spadina).

I aim to have everyone's CD III decants there, for those of you who joined my decant circle for that one.

. . .

In other news, What's that Japanese word for death by overwork again? )
misslynx: (Can't brain)
Tons of things I want to post about, but not enough time for any of it. Maybe I'll catch up over the holidays... For now, just a few quick ones:
  1. The WCC Yule ritual last Sunday was amazing. In the 25 years I've been involved with that community, I can only think of a handful of public rituals that have had that kind of spine-tingling intensity that makes them still stand out in your mind a decade later, but I think this will definitely be one of those. It was an Egyptian mystery play, based on a myth in which Hathor leaves the House of Ra and Thoth is sent to find her and convince her to return, and the thing that made it really unique was that it was done almost entirely in music -- like a ritual opera. I had no idea we had such an array of incredible voices in this community... The music was gorgeous, and Thoth's final duet with Hathor was incredibly powerful and moving, especially when the whole circle gradually begain joining in on the refrain. I think I can safely say that was one of the top ten Best Rituals Ever.

  2. December has flown by at warp speed. We are leaving town on Friday afternoon and I have so much stuff I at least theoretically need to get done between now and then that even if I didn't sleep at all I still couldn't do all of it. I think there will be some apologetic e-mails to clients in the very near future, accompanied by promises of finishing everything when I get back into town...

  3. Speaking of not sleeping, I really don't handle all-nighters as well as I used to. Night before last I didn't go to bed until nearly 8 in the morning, and my attempts at giftmas shopping the next day were pitiful. I would walk into a store and stand there in the midst of bustling crowds, staring blankly ahead of me and trying to remember what I was doing there again. Anything requiring decision-making ability was a dead loss. I spent about 5 hours out and came home with two books, nothing else.

  4. Pray for Coal: The 10 Worst Toys of All Time is too funny, in a sick sort of way. Link courtesy of [livejournal.com profile] satyrblade. I think the home atomic energy kit is my personal favourite, though the finger-eating Cabbage Patch Kids are a close runner-up.

  5. We are going to a resort-ish place for Christmas with my father and stepmother, and one of my stepbrothers and his wife and kids. Nothing exotic, just a couple of hours from Toronto and normally a ski resort, but with our current absence of snow (apparently Colorado has stolen our winter), there won't be much skiing going on. Still, it sounds kind of equal parts exciting and nervous-making. More the latter, for [livejournal.com profile] taikakettu, who is very worried about food issues.

  6. This has also necessitated us getting nice pajamas and such to wear when dealing with family members early in the morning. I now have shiny purple pajamas and, as of today, also a new pair of slippers with are ridiculously girly -- white with fake fur trim and silver sparkles and rhinestones on them. They are all soft and furry inside, so it's kind of like walking around with me feet in furry pillows. Shiny sparkly furry pillows. I love them. But I think I just lost all my goth points in one fell swoop.

  7. Claribell is afraid of said slippers -- she seems to think they're some kind of weird animal, and watches them warily whenever she's in the same room with them, as though she thinks they might attack at any moment. And occasionally tries to sneak up on them and swipe at them with her claws -- only to end up fleeing down the hall in terror if some prankster happens to nudge the slippers so that they move a little... Not that any of us would ever do such a thing, of course.

  8. Everyone who likes pretty-smelling bath things, handmade soaps, etc. should check out http://www.faerytub.com immediately. Local (as in Toronto), scented with all natural essential oils, and clearly her web site was designed by someone fabulously talented. ;-)

  9. How, exactly, did it get to be 3:11 am, and what happend to all the stuff I thought I was going to get done before going to bed tonight?
misslynx: (Feline world domination)
  1. The title of this post is taken from my favourite spam subject line of the day.


  2. Must read: Rick Mercer's commentary on the Tories' decision to reopen the same-sex marriage issue. Sample quote:

    "I have heard rumours that in the future the Conservatives plan on devoting every Thursday in the House of Commons to more votes on minority rights.

    "So far they have planned motions debating whether the Chinese should be allowed to drive, whether women should be allowed to vote and whether turbans should be allowed in elevators that travel more than 16 floors."


  3. I am stupidly happy about StĂ©phane Dion being chosen as leader of the Liberal party. He was my favourite of the lot, but it didn't look like he had a chance. And then all of a sudden, bang -- he pretty much pole-vaulted over all the front-runners while they were fighting out amongst themselves. It appears to be because competition was so fierce among the three of them that each one's followers hated the other two with a passion, and no one hated Dion, being as he was a dorky, rabidly environmentalist academic who can barely speak English intelligibly (then again, ChrĂȘtien was pretty much unintelligible in both official languages, and he did OK), was apparently not considered important enough to hate. Et voila...

    Now, the real question is whether the Canadian public are willing to elect a dorky, rabidly environmentalist academic in lieu of Stephen Harper. That, I am sadly not so sure about...

  4. As promised, an attempt to cover at least a couple of the topics I listed in brief in my recent catching-up post:

    trading spaces )
    me on TV )

  5. More later...
misslynx: (Waterhouse - Magic Circle)
Tonight's favourite words are LEFT JOIN (although ON DELETE CASCADE is still high in my esteem - take that, test data! Ha!).

Note to self (and others who've had similar join troubles):

When you want everything in the FIRST table you list that meets your condition, along with the related data you want from one or more other tables, to show up in your query, regardless of whether there are some null values kicking around in there somewhere, that is LEFT JOIN. Left join left join left join left join.

If you wanted everything meeting your condition in the LAST table you list in your query to show up along with whatever related data there may or may not be in the tables before it, that would be RIGHT JOIN.

LEFT = the table at the beginning is the one that really counts

RIGHT = the table at the end is the one that really counts

Because, you know, people read from left to right in this language we're speaking. Usually. Unless they're holding a book upside down.

INNER JOIN is basically the same as WHERE. You know: SELECT everything from table x and table y where some-column-in-X = some-column-in-Y. INNER JOIN (like WHERE) craps out if there any null values anywhere in the data you're asking it for.

Maybe now that I've typed it out like that it will actually stick in my brain.

On a semi-related note, I want this T-shirt.
misslynx: (Default)
Right now, my three favourite words in the world are:

ON DELETE CASCADE

That is all.

Profile

misslynx: (Default)
misslynx

April 2011

S M T W T F S
     12
34 56 78 9
10111213141516
17181920212223
24252627282930

Syndicate

RSS Atom

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Sep. 26th, 2017 03:37 am
Powered by Dreamwidth Studios