News and Musings login
[1] << Back 713 714 715 716  Next >> [722]
chunking big lists in ACC2K, revisited posted: Tue 2011-08-30 16:49:55 tags: database
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)
Serpentine Fire posted: Tue 2011-08-30 15:52:49 tags: music
terminology II posted: Mon 2011-08-29 18:36:38 tags: TWFTR
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)
Biblical liberalism posted: Mon 2011-08-29 00:19:54 tags: ministry, TWFTR
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)
mileage posted: Sat 2011-08-27 05:18:15 tags: fitness
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.