Some possibilities:
1. Add a column to the Parts table, store the name of the image file in that
column, retrieve the name in a query and dynamically create the <img> tag.
2. Create each image file so that the name is somehow linked to the record
in the database. For example, if the part_id is ABC123, call the image file
ABC123.jpg. Dynamically create the <img> tag based in the part_id.
3. Do both 1 and 2, that way you could write an update query that would
pre-populate the image name column with the proper file name, and any
inserts into the table could do the same as well.
Bob
-----Original Message-----
From: t nelson [mailto:[EMAIL PROTECTED]]
Sent: December 14, 2000 5:51 PM
To: CF-Talk
Subject: Is this even possible?
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
