Thank you so much. What a newbie error. I had tried it without the cfoutput and was at the point of frustration I was coding recklessly.
That fixed it! > Well thats the problem alright. Your putting CFOUTPUT in the cfset > tag. It's getting used as a literal. > > This is the better way to do this > > <cfset variables.ImageSource = > 'C:\Inetpub\wwwroot\Interspire\images_originals\#trim(catalog.sku)#. > png'> > > Alternately you could do this: > <cfset variables.ImageSource = > 'C:\Inetpub\wwwroot\Interspire\images_originals\' & trim(catalog.sku) > & '.png'> > > What you were doing produced an output that looked like this: > "C:\I> netpub\wwwroot\Interspire\images_originals\<cfoutput>394803</cfoutput>. > png" > Assuming the catalog.sku = 394803 > > > > > Wil Genovese > > One man with courage makes a majority. > -Andrew Jackson > > A fine is a tax for doing wrong. A tax is a fine for doing well. > > On Apr 8, 2010, at 1:58 PM, Fred Grainger wrote: > > > > >> You said that "When I build the file path from the database fields > it > >> will not work. ". Lets see that code. Something may not be what > it > >> seems to be. > >> > >> > > <cfset variables.ImageSource = '> C:\Inetpub\wwwroot\Interspire\images_originals\<cfoutput>#trim(catalog. > sku)#</cfoutput>.png'> > > > > The value is: > > C:\Inetpub\wwwroot\Interspire\images_originals\707-2298005-001.png > > > > The length of the variable is 15. > > > > The file exists - I have the image output next to the path and file > name... > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm