Last post Jul 08, 2016 12:05 PM by PatriceSc
Jul 03, 2016 06:32 AM|fiazahmed|LINK
i used PhotoGallery template to store photos .i created new table photos because the rows can not be deleted due to image datatype of a column fileContent. i changed the data type of fileContent to varbinary with length max 8000. but does not store images
and following error occure.
Jul 04, 2016 06:38 AM|PatriceSc|LINK
Image is outdated and varbinary(max) should be used instead. That said, it would be really weird to have a database providing a data type that would prevent to ever delete a row using this data type !? More likely you had anyway another problem (such as a
wrong WHERE clause as it seems you didn't have any error message?)
Jul 08, 2016 10:09 AM|fiazahmed|LINK
thanks PatriceSe ,
I used image data type and tried to delete through query it was successfully deleted.
Jul 08, 2016 12:05 PM|PatriceSc|LINK
Fine if solved. For now it seems you used varbinary(8000) rather than varbinary(max) and that your issue was not really related to deleting the row...