Re: Paged Results Set in MySQL DB with one result

On May 4, 2006, at 11:16 PM, Jochem Maas wrote:

Richard Lynch wrote:

On Thu, May 4, 2006 10:15 am, Edward Vermillion wrote:

On May 4, 2006, at 4:16 AM, Richard Lynch wrote:

On Wed, May 3, 2006 6:57 pm, Jochem Maas wrote:

...

Yes. Usually. Mostly sometimes. For something like a Forum or a CMS with minimal EZ tags for the admin on a small-scale site, I'll confess to just tossing HTML into the db. But not if my site is allegedly a professionally-written series of articles.

lets assume that the author of the articles what some kind of stylistic and/or semantic control over the content of the article - how would you store this formatting information? I'd hazard to say that XHTML is a rather better markup language definition than any custom thing we could come up with on own own, no?

Your probably right, well at least defining a custom xml dtd set for your particular purposes, or not, maybe. I haven't gotten into the whole XML thing yet, so I could very well change my mind once I do (in other words, I know what I know so if I'm being a complete idiot slap me over the head). The problem I have with using X/HTML in the body of the articles is that it's a lot more difficult, at least for me, to control what gets in and what doesn't. <script... for example (or <sc ri pt.. which apparently IE is more than happy to execute for you). I'd rather define a *small* set of custom tags that look nothing like X/HTML that I do a replacement on after running htmlentities() on the text. That way if for some unknown reason they want to have <img or <link or <script or just <? in the body of the text, it shows up fine and it doesn't break anything. If the replacement tag gets borked then you see parts of the tag, and the page still isn't broken.

As a personal note, I prefer to read things that have been broken up into logical chunks for me, as opposed to being fed some 2000 word essay all at once. I *hate* scrolling. But then I didn't learn to read on a computer screen either.

There's truly logical chunks, and there's "we need you to break this into 10 pages so we can sell more ads, okay?" chunks.

lol - don't forget the "chunk it so we sell more banners AND link random words in the article to DHTML popup ads" - I *really* hate those.

Blech.

I assumed logical chunks, hadn't even thought of marketing getting in on the action... *ewwwwww* Ed