As previously noted, Access 2000's TOP clause is the cognate of MySQL's LIMIT clause. Now let's say, having selected and contacted the first 1000 contacts from a big table, you want to isolate the next block of 1000 contacts.
The way not to accomplish this, is construct a query like
SELECT email FROM contacts
WHERE email NOT IN (
SELECT TOP 1000 email FROM contacts
)
The NOT IN clause is just horribly inefficient and slow. If you're picking the TOP 1000 records, and your list...
(...more)
In my entry on biblical liberalism I found myself referring to "liberals" and "conservatives" in "quotes" constantly.
According to dictionary.com, being ideologically "liberal" means being receptive to new ideas and uninvested in traditional values. By contrast then, conservatism would be resistance to new ideas and adherance to traditional values. The difficulty arises when we have to ask "which values? whose traditions?" E.g., current "conservatism" in America is not interested in defending the status...
(...more)
Last Sunday there was a mildly awkward incident where I posted a pair of Bible quotes to kick off my "Jesus Loves Liberals" series on my FB wall, and some right-wing sheep from my Castle Age network popped in to respond with ...what I guess he thought was a counter-sermon about doing pretty much anything else with your money besides helping the poor. I guess he thought I was making a case for welfare, which ironically wasn't even my intent, but that's where the ensuing commentary went. Actually, the passag...
(...more)
session 11: (per Twitter) 3.3mi in 49m20s (avg. 4.01mph), peaking at 6.2mph for a half-lap.
Seems every time I get on the 'mill I push my limits just a little further, but one thing I'm kind of frustrated with is, not being able to jog much more than 1/4 mile at a stretch.