[thelist] Looking for dynamic menus for ASP pages

[Drew Shiel]

At 01:14 28/07/2004, Ken Schaefer wrote:

> > How do you fit this mess together to provide a highly
> > customizable menu system for
> > each person? I used comma delimited lists.
>
>If possible, avoid this. You end up with increasingly nasty code
>up-above splitting strings up, and putting them back together again.

   I'm firmly with Ken on this. We almost had to reboot one of our backend 
guys here recently after he got his head stuck in a query/code mess 
resulting from a comma-delimited field.

   You're much better off creating a table that links As and Bs, whatever 
the As and Bs may be, and querying that when you want to get all the As 
connected with a specific B, or vice versa.

   Comma-delimited looks neat and tidy at first, but I'm very close to 
printing off a large notice saying "No comma-delimited fields, ever!" and 
sticking it on the wall where everyone here can see it.

   Drew.
-------------- next part --------------

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.725 / Virus Database: 480 - Release Date: 19/07/2004