Hey Will -
I'm going to give you a little H$LL here on the list - all in good
humor of course - and only because you and I have chatted off list.
But that code you posted sure looks a lot like CF and not .NET.
LMAO
I love ya, but I had to do it. Shoot me, sue me, whatever, it's Monday
from hell here and I could NOT pass it up!
;-)
Donna
On Mon, 10 Jan 2005 15:50:38 -0400, Will Tomlinson <[EMAIL PROTECTED]> wrote:
> I'm almost finished with the coding on my clothing e-commerce site, but I'm
> running into a few minor snags.
>
> When dealing with images, I usually just add a few image fields in the main
> table, image1,2,3,etc. It usually works fine and I built this stupidly
> elaborate process for updating and deleting them. But this clothing db is a
> little different and the image setup needs to be done right for it all to
> work as I need.
>
> Everything revolves around a model of clothing. The tblprodmodels table has:
> prodmodelcode-PK varchar
> prodsellprice
> title
> category
> etc.
>
> I also have a tblavailablecolors with
> availablecolorID - PK (int-autnum)
> prodmodelcode - FK from tblprodmodels
> colorname FK from tblallcolors
>
> tblallcolors is just a lookup or validation table.
>
> Everything works great with me looping available colors into tblavailable
> colors with a multiple select menu like so:
> <!--- Insert into available colors table --->
> <cfquery datasource="#DSN#">
> INSERT INTO tblavailablecolors (colorname, prodmodelcode)
> VALUES ('#FORM.prodcolor#', #FORM.model#)
> </cfquery>
>
> The problem arises with having, say 10 filefields to upload to my db.
> I'm uploading and saving each filename with no problem, but how do I loop the
> filenames into the table?
>
> Actually, I need a new linking table. tblavailableimages? Hell, I'm having a
> brainfart here! How should I tie in the images for a model? And tie it with a
> color at the same time?
>
> GRRRRR!!!
>
> Will
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189843
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
