I am building an affiliate site for a client. They are trying to resize images 
provided by vendors. All of the images are pulled into the pages from the 
vendor's server. All of the tags that I have found will only resize local 
images. So, I am trying to using CFHTTP to get the images and save them 
locally. I keep getting an unspecified error due to the use of the CFHTTP. 

I am allowing the client to create the product record in the dB, then I use the 
product ID number in the database to assign a name to the image file I am 
pulling from the vendor site. Once the image is retrieved via CFHTTP, I am 
updating the products database with the name of the image file saved.

Here is my code:
<cfif FORM.imageURL NEQ "">

<cfquery name="getResizeImage" datasource=#DSNproducts#>
SELECT productID
FROM products
ORDER BY productID DESC
</cfquery>

<cfset ProductID = #getResizeImage.productID#>
<cfset ImageLocation = #FORM.imageURL#>

<cfdump var="#ImageLocation#">
<cfdump var="#ProductID#">

<cfhttp method="get" 
url="#ImageLocation#"
throwonerror="yes"
path="C:\websites\#####\admin\manage\products\product_images\resize"
file='#ProductID#.gif'
resolveurl="yes"/>


<cfquery name="updateResizeImage" datasource=#DSNproducts#>
UPDATE products
SET image_resize = '#ProductID#.gif'
WHERE productID = #ProductID#
</cfquery>
</cfif>



Any thoughts or comments would be appreciated.

Thanks in advance.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:221869
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to