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 Message ----- From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 17, 2002 12:40 PM 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 > ______________________________________________________________________ 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=coldfusiona 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