[thelist] add comments to a home-made blog

david.landy at somerfield.co.uk david.landy at somerfield.co.uk
Wed Jun 16 07:29:03 CDT 2004


If your comments can live in an unlimited-length (varchar or a memo) field,
then why not just append (or pre-pend, for reverse order) each comment to
the memo field? 

I'm doing that here and it works just fine. One downside is that it wouldn't
be so easy to see a list of each person's individual posts if they are tied
to other events and hidden inside memo fields, but if you're not interested
in that list then this would be a simple option.

UPDATE posts SET comments = comments + username + datetime + 'my new
comment' WHERE postid = 99

Hope this helps.


If you are not the intended recipient of this e-mail, please preserve the
confidentiality of it and advise the sender immediately of any error in
transmission. Any disclosure, copying, distribution or action taken, or
omitted to be taken, by an unauthorised recipient in reliance upon the
contents of this e-mail is prohibited. Somerfield cannot accept liability
for any damage which you may sustain as a result of software viruses so
please carry out your own virus checks before opening an attachment. In
replying to this e-mail you are granting the right for that reply to be
forwarded to any other individual within the business and also to be read by
others. Any views expressed by an individual within this message do not
necessarily reflect the views of Somerfield.  Somerfield reserves the right
to intercept, monitor and record communications for lawful business

More information about the thelist mailing list