On www.allbooks4less.com we store the file name of the image in the database. Since
the site deals with books, every item has a unique ISBN number (substitute your
favorite ID# here). Each image is named <isbn#>.gif, so we didn't really need to store
the file names in the database (but we do just in case that relationship doesn't
always hold true- for example if we add products that DONT have ISBN numbers). There
are too many files to put in one directory, so we split them by the least significant
digit of the ISBN # (more random distribution than the most significant digit). Eg:
/images/8/12345678.gif
(FYI: most of this is hidden from the user, and this is NOT a CF site. Sorry...)
At 10:51 PM 12/14/00 +0000, t nelson wrote:
>Hi all,
>
>I am wondering if this will even be possible or if I just have a pie in the
>sky dream.
>
>Here it goes:
>
>Let's say that you have an online store with a huge inventory of products,
>we're talking close to 10'000 distinct items. your site has everything we
>have come to expect from an e-store application (search features, shopping
>carts, etc..). if by some miracle i had a good quality and not too big
>(under 10k each) .jpg or .gif for each item in my inventory. would it be
>possible for me to some how link each of those pictures to its corresponding
>part in my database? this way when a customer searched for an item, a nice
>picture could come along with it.
>
>again, is this even possible, if so how?
>
>thanks in advance for your time and help,
>
>nelson
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
