Another thing to check, since you've gone the DB image route (which, BTW, IMHO, can be a great way to go) you should also verify that you've set the datasource to pass large chunks of data. I think with .GIFs you'd see a part of the image at least, but with JPG if it get's cut off, you won't see anything.
I might have that backwards... Anyway, I think CF defaults to like a 65k chunk at a time, which will need to be increased if you're trying a larger image, or don't have them broke up in 65k chunks. It's probably the thing Sandra mentions below though. GL, :D On 9/25/06, Sandra Clark <[EMAIL PROTECTED]> wrote: > > The problem is that in FB3, the images are displayed in relation to the > display fuse itself. I believe that a variable exists that is set up in > each fbx_settings.cfm file for a circuit for an image and another one > should > be in the apps_globals.cfm at the top for a baseline directory of the > webroot, but I can't remember the name of these. > > So your dsp_view.cfm file should look something like > > <img > > src="#Fullrootpathofapplictation#/dsp_setImage.cfm?dTaskIndex=#attributes.dT > askIndex#" border="0" width="300" height="200"> > > > Sandra Clark > ============================== > http://www.shayna.com > Training in Cascading Style Sheets and Accessibility > > > -----Original Message----- > From: Chris Alfano [mailto:[EMAIL PROTECTED] > Sent: Monday, September 25, 2006 2:24 PM > To: CF-Talk > Subject: Re: Displaying images from SQL Server in Fusebox > > I'm going to look into the HTTP Proxy Debugger > > As for my code, I believe I have all bases covered: > > dsp_setImage.cfm --> > <cfquery name="getImage" datasource="#request.DSN#"> SELECT attachment > FROM > images WHERE task_index = #attributes.dTaskIndex# </cfquery> > > <cfcontent type="image/jpeg" variable="#getImage.attachment#" > reset="true"> > > > > dsp_view.cfm --> > <img src="Web/Uploads/dsp_setImage.cfm?dTaskIndex=#attributes.dTaskIndex#" > border="0" width="300" height="200"> > > This leads to a broken image. > > When I add the query and cfcontent to the actual dsp_view page, then the > image takes over the ENTIRE display -- hiding the header, footer, > navigation > and other content associated with that file. > > Cheers. > -c > > >Chris, > > > > > >I'm pretty confident the problem is your getting extra whitespacing > >somewhere in your output. Use an HTTP Proxy Debugger (like Fiddler or > >Live HTTP Headers) to actually examine the data being served from the > server. > > > >Also, you might try adding the "type" attribute to the <cfcontent /> > >tag to specify the mime type. > > > >-Dan > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
