Basic database design. If you have one clip per song, why not just have a
field that contains the clip filename?
Otherwise, have a second table that contains a foreign key to your song ID.
Now, obtaining the id created for the song is a bit tricky, depending on
your RDBMS.
- Original
Actually maybe I know the answer, but tell me if this sounds logical. I
have the person insert the album with the album ID and when they hit
insert, it takes them to the song clip page where I carry over the album
ID. At that point I query the album table for the song titles associated
with
'...
- Thomas Paine, The American Crisis
-Original Message-
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 17, 2002 10:47 AM
To: CF-Talk
Subject: Re: Another dealing with inventories?
Actually maybe I know the answer, but tell me if this sounds logical. I
have the person
PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, January 17, 2002 11:14 AM
Subject: RE: Another dealing with inventories?
You're turning an everyday problem into a show stopper.
If the relationship is 1 to 1 between songs and clips then they should
not
be in a seperate table. Put them
4 matches
Mail list logo
