OK, this is what I came up with. There are actually two lookups, so 4 tables. I'd appreciate it someone would look them over.
create table PEOPLE_DEPT (
id NUMBER Primary Key,
dept VARCHAR2(100)
)
create table PEOPLE_JOBTYPE (
id NUMBER Primary Key,
jobType VARCHAR2(100)
)
crea
read up on
SQL joins as well as CFOUTPUT a little more but it will definitely make
life easier.
John
-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 21, 2004 3:30 PM
To: CF-Talk
Subject: Re: DB field setup
Yeah, I believe it does make sense, and I
Burns is in Family Studies while Daniel
>Kessler is in Family Studies and Kinnesiology. I hope that helps.
>
>John Burns
>
>-Original Message-----
>From: daniel kessler [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, July 21, 2004 2:22 PM
>To: CF-Talk
>Subject: Re
e AS category
FROM person p, personcategory x, category c
WHERE p.personid = x.personid
ANDx.categoryid = c.categoryid
Make sense?
- Original Message -
From: "daniel kessler" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesda
s and Kinnesiology. I hope that helps.
John Burns
-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 21, 2004 2:22 PM
To: CF-Talk
Subject: Re: DB field setup
>Seems like you need a lookup table (in case the possibilities ever
>increase from 3 to X)
Use three tables something like what's below. The has multiple entries
for each user. HTH.
--Jeff
tblUsers
PK_tblUsers
userName
firstName
...
tblSubjects
PK_tblSubjects
subject
description
...
tblUserSubjects
FK_tblUsers
FK_tblSubjects
On 7/21/2004 1:43 PM, Dan
>Seems like you need a lookup table (in case the possibilities ever
>increase from 3 to X). Then you can either store the IDs in a
>comma-delimited list or do another lookup table where you insert the
>userID and the type they are. Then each user can be in multiple places.
While I agree that I p
Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 21, 2004 1:44 PM
To: CF-Talk
Subject: DB field setup
I had a dropdown that had three entries: kinesiology, family studies,
public and community health. So in my Oracle DB, I had a field TYPE
VARCHAR2(100) to take that
I had a dropdown that had three entries: kinesiology, family studies,
public and community health. So in my Oracle DB, I had a field TYPE
VARCHAR2(100) to take that information, as is. Now I find that
someone can be in more than one spot, so instead of a dropdown, I now
have a checkbox for ea
9 matches
Mail list logo
