Bob, I'm out for the day, but I'll try. What are you passing? You have 2 variables there, photo and ID.
What exactly are you getting for each of thise values in Form? What data type is photo? Jerry 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:1897 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
