My apologies, Nate. I didn't catch on that your main problem was with the images.
Ours are stored on a separate server and referenced through the record ID. Since I don't deal with the images, only the listings, my job is much simpler. There's no reason I know of why you can't use something like ImageMagick to manage the images and rename them with the MLSnumber as part of the file name. Are you familiar with that? Dave Long -----Original Message----- From: Nathan C. Smith [mailto:[EMAIL PROTECTED] Sent: Thursday, January 17, 2008 2:14 PM To: CF-Talk Subject: RE: insert/retrieve image into database SQL Server 2005/CF8? I didn't think so either... You are always a great resource Dave, any thoughts on my original question? 'http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:54861#29676 6' -Nate > -----Original Message----- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 17, 2008 1:54 PM > To: CF-Talk > Subject: RE: insert/retrieve image into database SQL Server 2005/CF8? > > > I was hoping to avoid the tired old in-DB v. Out-of-DB > > conversation. > > Like the war between good and evil, that conversation is > eternal. There's > nothing wrong with storing images in a modern RDBMS. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > > Fig Leaf Software provides the highest caliber vendor-authorized > instruction at our training centers in Washington DC, Atlanta, > Chicago, Baltimore, Northern Virginia, or on-site at your location. > Visit http://training.figleaf.com/ for more information! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296782 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
