read 4 lines below where you've ever ready before. I'ts sent to you
hundreds of times a day.
Cheers,
Mike kear
On Mon, 7 May 2001 [EMAIL PROTECTED] wrote:
>
> I want to unsubscribe from CFtalk.
> What should i do?
>
>
>
>
~~
Structure your ColdFu
I want to unsubscribe from CFtalk.
What should i do?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe
This is the way I would go too:
-Kelly
This is a classic many-to-many relationship, best represented by 3 tables:
Table Users (userid, username, other user info)
Table Groups (groupid, groupname, other group info)
Table UsersGroups (userid, groupid)
-David
On Sunday, May 06, 2001 9:38 AM, Mich
users - user information
groups - group information
usergroups - userid, groupid
For every group that a user belongs to, there should be an entry in the
usergroups table with their userid and the groupid
> I'm trying to normalize a table to best hold the following data:
> username, group1, g
; <[EMAIL PROTECTED]>
Sent: Sunday, May 06, 2001 11:38 AM
Subject: Quick DB Design
> I'm trying to normalize a table to best hold the following data:
> username, group1, group2, group3, group4... groupN...
>
> there are 1000s of unique usernames, and 1s of unique groups
>
by "SELECT count(uid) AS cnt WHERE gid = GROUP BY gid", etc.
If that data was stored in a list in a field, it would negate the purpose of
storing it in a database.
-Original Message-
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: May 6, 2001 09:38
To: CF-Talk
Subject: Q
Aack!
This is a classic many-to-many relationship, best represented by 3 tables:
Table Users (userid, username, other user info)
Table Groups (groupid, groupname, other group info)
Table UsersGroups (userid, groupid)
-David
On Sunday, May 06, 2001 9:38 AM, Michael Lugassy [SMTP:[EMAIL PROTECTE
I'm trying to normalize a table to best hold the following data:
username, group1, group2, group3, group4... groupN...
there are 1000s of unique usernames, and 1s of unique groups
every user can subscribe to 1-1 diffrent groups (so I don't know how much group
colums to put).
I need some
8 matches
Mail list logo