[thelist] SQL / Tables (CF)

[Joshua Olson]

> -----Original Message-----
> From: Drew Shiel
> Sent: Friday, July 16, 2004 11:24 AM
>
> I have two tables.
>
> "Rss" contains the fields "Name", "EventTypeIDs", and a number of others,
> which aren't awfully relevant, one of which is "Description". "Name" is
> unique, "EventTypeIDS" is a string, which may be a single number,
> like "12"
> or "42", or a comma separated list, like "24, 26, 45"

Stop right there...

While I'm sure we can find a solution to this depending on your database,
you may want to consider putting these comma-delimited values into an
associated table relating the Name field to any number of EventTypeID... one
per row.

Example of NewTable:

Name | EventTypeID
soc | 23
soc | 24
soc | 25
45 | 45
24 | 24
amer | 1
amer | 4
amer | 10
1 | 1
4 | 4
72 | 72


Then, the query will be quite easy.

<><><><><><><><><><>
Joshua Olson
Web Application Engineer
WAE Tech Inc.
http://www.waetech.com/service_areas/
706.210.0168