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!!
Bob -----Original Message----- From: J Thompson [mailto:[EMAIL PROTECTED] Sent: Friday, June 16, 2006 6:56 PM To: CF-Newbie Subject: Re: I know it's Friday ... but.. Have you checked to see if the datatypes of the columns match the datatypes you are inserting? On 6/16/06, Bob Imperial <[EMAIL PROTECTED]> wrote: > Hello folks ...... if anybody is out there, I could use some > enlightenment here on a error I'm getting while trying to update an > image name in my db. I don't get it, I even output this value just > before the update to make sure it's not passing some terrifically long string and it's fine, 2 digit ID. > Any help would be greatly appreciated, TIA Bewildered Bob > > > > Error Executing Database Query. > > The field is too small to accept the amount of data you attempted to add. > Try inserting or pasting less data. > > The error occurred in D:\wwwsites\mywebshopcom\admin\myupload.cfm: > line 13 > > > 11 : UPDATE Products > > 12 : SET itemImage = '#form.photo#' > > 13 : WHERE itemID = #form.itemID# > > 14 : </cfquery> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1898 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
