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 in the same table you won't have to
wonder
how to relate them to each other any more.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may
have
peace'..."
- 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 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 the ALBUM ID and dynamically create the form fields IE: <input
type="text" NAME="clip_#song_titleID#">. Will this help me to match
them up?
There are two major products that come out of Berkeley: LSD and [Unix]
BSD. We don't believe this to be a coincidence.
Doug Brown
----- Original Message -----
From: "Douglas Brown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, January 17, 2002 10:40 AM
Subject: Another dealing with inventories?
> I have a form with several fields that will be filled in by someone
> adding song titles. Each song title will have a song clip(30 second
demo
> of song) Have not figured out if they should be on the same form or
not.
> I need figure out how to handle the song clip issue.
>
> I need the song clips ID to match up with the song titles ID, I have
2
> seperate tables. IE: [albums] [clips] How would I go about inserting
the
> song clips to where they will match up with the song titles?
>
> Hope this made sense
>
>
>
>
> There are two major products that come out of Berkeley: LSD and
[Unix]
> BSD. We don't believe this to be a coincidence.
>
>
>
> Doug Brown
>
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
