Zelda, I'm not storing the images in the db, just the image name, images are uploaded to a specified directory and then referenced by the name in the db. Every image is associated with an item and every item is referenced by itemID, the description, price and image are all tied together through the itemID. HTH
Bob -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 19, 2006 10:33 AM To: CF-Newbie Subject: RE: I know it's Friday ... but.. Bob/All, This is a timely subject for me. We are trying for the first time to work with inserting photos into a db. What datatype do you use? Can anything else be used besides blob? What code do you use to pull the image out of the db to display on the page? Thanks. Zelda -----Original Message----- From: Bob Imperial [mailto:[EMAIL PROTECTED] Sent: Saturday, June 17, 2006 10:19 AM To: CF-Newbie Subject: RE: I know it's Friday ... but.. Thanks ...Maybe too early in the morning for that fourth now :) and I've run into another problem, I mean opportunity to learn more about CF :) Let me explain my little scenario thus far, and what I am trying to do then maybe someone has a different approach w/o my little issues. I have a form with 2 fields to add an item to the db, description and price, and no I'm not trying to build a shopping cart ;) The form is submitted and description and price are added to the db, then it proceeds to the next step which is to upload an image to associate with each item (works fine so far), then right after uploading I have another routine that runs a little cfdirectory bit with recurse set to yes, herein lies my issue.... Sometimes this works fine as I understand how recurse works in this scenario, based on LastDateModified I snag the image name to update the db with this image name for future use. Sometimes this works ok, sometimes it grabs the previous uploaded image name as opposed to the current. If this makes sense to anyone out there ....... Can you offer me any insight here please? Bob -----Original Message----- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Friday, June 16, 2006 10:39 PM To: CF-Newbie Subject: Re: I know it's Friday ... but.. Well, have a fourth to celebrate! On 6/16/06, Bob Imperial <[EMAIL PROTECTED]> wrote: > Well.... Yes and after 3 Yuenglings I found out why I was getting the > error > ;) I needed to use cfdirectory with recurse set to yes to get last > image uploaded for my update statement. I was trying to snag the image > name before it actually made it through the upload routine and was > alive and well in the proper directory. Thanks for taking the time to > respond and have a great weekend!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1902 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
