Feb. 20th, 2009

nonethefewer: (Default)
Silly SQL question.

I'm using SQL Server 2000.  I am in the SERV1 server.  Is it possible to run a select statement for a database on SERV2?

So like, while on SERV1:

select * from SERV2.database.dbo.table

I ask because I want to store certain data across six servers into one table.  If I can't do the above, what would be better?

[eta] Why do I do this to myself?  sp_addlinkedserver, duh.
nonethefewer: (Default)

When I post in Wordpress, I use Visual for appearance and forcing double-spaces, but I use HTML for adding links and being very picky with my code.  Here's how to add a button in the HTML editor bar to not only add LJ user code, but to have it plug in the username in the right spots.

0) You will be editing the /wp-includes/js/quicktag.js file.  Make backups, &c &c.

1) Open the file and look for the first instance of this line: edButtons[edButtons.length]

Underneath that code block (should be for the 'strong' tag), add this:

edButtons[edButtons.length] =
    new edButton('ed_lj'
    ,'LJ User'
    ,'<a href="http://###.livejournal.com/profile"><img style="margin: 0px; vertical-align: middle;" title="ljuser" src="[img src]" alt="ljuser" border="0" width="17" height="17"></a><a href="http://###.livejournal.com/"><strong>###</strong></a>'
    ,"
    ,'ljuser'
);

If you stop and save at this point, you will have a button that will add the LJ user code.  ### should be replaced with the user name, and [img src] should be replaced with where you've saved the 17×17 LJ user icon.  (I recommend saving it locally.)

However, I want it to ask for and insert the username, so I don't have to.  So…

2) Search for this string: function edShowButton(button, i) {

You should see an if/else if/else block.  Insert this code above the else if line:

else if (button.id == 'ed_lj') {
    document.write('<input id="' + button.id + '" class="ed_button" onclick="edInsertLJUser(edCanvas, ' + i + ');" type="button" value="' + button.display + '" accesskey="' + button.access + '" />');
}

3) Search for this string: function edInsertLink(myField, i, defaultValue) {

Below that function (and above the edInsertImage function), add this code block:

function edInsertLJUser(myField, i, defaultValue) {
    if (!defaultValue) {
        defaultValue = 'news';
    }
    if (!edCheckOpenTags(i)) {
        var theUser = prompt(quicktagsL10n.enterURL, defaultValue);
        if (theUser) {
            edButtons[i].tagStart = '<a href="http://' + theUser + '.livejournal.com/profile"><img style="margin: 0px; vertical-align: middle;" title="ljuser" src="[img src]" alt="ljuser" border="0" width="17" height="17"></a><a href="http://' + theUser + '.livejournal.com/"><strong>' + theUser + '</strong></a>';
            edInsertTag(myField, i);
        }
    }
    else {
        edInsertTag(myField, i);
    }
}

4) Finally, save, close, and refresh the Add New Post or Edit Post page.  When you click on the HTML tab now, you should see LJ User.  Click on that, and where it says 'news' (the default LJ user), put in the LJ username you want to enter in.  This will return code that (a) has the username in all the right places and (b) looks right both in WP and LJ.

Ta-da!

Originally posted at Xtinian Thoughts.  Comment here or there.

nonethefewer: (Default)

Back to what I was on about an age ago.  That being, Twisty is awesome.  Today's evidence is where she posts about consent.  The entire post is what win is, but I will excerpt a portion just for you:

There are rules about what sort of woman can even attempt to make the "I said no" argument in court. Women who typically are not eligible to opt out of consent include: women who drink in bars, women who walk alone, women who walk at night, women who use drugs, women belonging to certain castes, women who dress a certain way, women who don't dress a certain way, women who are married to men, women who have had multiple sex partners, women who may have said yes last month, women who may have said yes at the beginning but who, three minutes in, found it disagreeable and changed to "no," women who didn't fight back hard enough, women who didn't tell anyone or report it right away, women whose physical similarity to pornulated women aroused the defendant, women whose behavior at the party aroused the defendant, teens with a "reputation," and prostituted women.

She goes on to discuss (a) a news item about a 13-year-old who was raped by her instructor, and how vile and appalling it is that the article author put quote marks around "rape", (b) the problem with consent as it stands, and (c) her bona-fide solution for it.

This is precisely why I love reading I Blame The Patriarchy.  The language is precise and the concepts are amazing.  I am ever in hearts with folk what can put words to ideas in such a fashion, since I so often have problems with it.

Originally posted at Xtinian Thoughts.  Comment here or there.

nonethefewer: (Default)
Cross-post from [livejournal.com profile] xtina_rss.

If you use Wordpress and you want to insert that whole <lj user=blah> code by clicking one button in the editor, check here.
nonethefewer: (Default)

Breastfeeding Bingo

I want to do a bingo-card roundup now.

Originally posted at Xtinian Thoughts.  Comment here or there.

nonethefewer: (Default)

Tonight has been spent, among other things, managing my blog layout.  Primarily, I focused on improving linking to other folk:  I added the Recent Comments item, I moved the "blogroll" up a bit and updated the links, and I installed the CommentLuv plugin.  (I don't know if that last will work yet, but why not?)

I will never entirely know what I'm using this blog for.  I have the occasional idle idea of moving entirely over to here (from my LJ journal), but it will never fly.  I get a sense of community from LJ that I don't get from other blogs.  To torture an analogy, LJ is like a dorm, and individual blogs (e.g., any non-LJ blog in the Linkage sidebar item there) are like houses in a suburb.  The analogy is intended to highlight the casual atmosphere of LJ, versus the slightly more formal nature of non-LJ blogs.

Each have their ups and downs.  I tilt more towards casualness, so I'm more on LJ, the end.

*waves hand*  Regardless, I wanted to improve others-linkage because even though this is a teensy hole-in-the-wall as far as blogs go, I want to… include? acknowledge? others.  Some word that means "Though I'm a small corner of the web, every strand counts".

I still get nervous that I'll say the wrong thing or not do something right or whatever.  I greatly admire a bunch of these well-spoken, successful, amazing women who I've linked to on the sidebar there, and I have the doom-anx, you know.  But I figure that so long as I (a) respond well to constructive criticism and (b) continue improving, any fuck-ups I have will not involve deportation.

Anywho.

  • I set the &%*$ tag cloud to not be limited in number but be uniform in size.  I cannot abide mixed-size tag clouds.
  • I added a random quote generator.  I think.  I may post my Javascript workaround, since none of the plugins are pleasing me at the moment.
  • I created a bingo card page.  Gosh is it ever a work in progress, but I lurv it.
  • I updated a few plugins what needed it.
  • I streamlined my new post page.  Turns out you can remove modules, which cuts down on page load time, yay!

I'm still inordinately pleased with myself for adding and updating that RSS footer plugin, that advises that I will receive comments through here, not through LJ.  I do not want to discourage input, and I really hope I wasn't rude, but I don't get notifications from comments made on the LJ feed, and I don't want to miss them.

And in conclusion, I've been lying to my girlfriend by saying this game is easy.  It's fun, but after a certain level, I want to break out the graph paper.

Or, uh, go to sleep.  Right.

Originally posted at Xtinian Thoughts.  Comment here or there.

nonethefewer: (Default)

Ages ago, Amanda Marcotte at Pandagon posted this amazing post:

The liberal-feminist view of sex is that it's not a war or a game, but more of a mutual collaboration, less like a battle and more like playing music. In this model, to be a sexual person is to be a musician and sex is playing your instrument. Sometimes you play by yourself, sometimes you get with others and jam, and sometimes you actually have a band that you have a long-term relationship with. There aren't winners and losers, but there can be good and bad sex, just like there can be good and bad music.

I link it here because it needs to be linked more.  They changed sites (they're now at pandagon.net), so it's harder to find, for some reason.  But oh goodness, read that post.  She compares the liberal-feminist view of sex (playing music) to the conservative view of sex (playing basketball), and I adore it.

Have I mentioned already that I love words?

Originally posted at Xtinian Thoughts.  Comment here or there.

nonethefewer: (Default)
A couple of nights ago, I dreamt I was flying.  I flew to Australia.  I had to call and leave a message, because someone something something.  I think I woke myself up for that part.  But I got to fly, you understand.

In other news, this userpic is cracking me up, and is the only time I've ever liked the song:

Page generated Jul. 20th, 2025 03:47 pm
Powered by Dreamwidth Studios