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
Re: Another dealing with inventories?
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
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 __ 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
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 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
Re: Another dealing with inventories?
I shall give it a try. I know I sound like a tardo, but I am kinda new to DB management. Thanks 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: Bryan Love [EMAIL 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 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 __ 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
