/**
* Delete the link between an image and a collection. Returning 1 if the link is deleted,
* 0 when the link didnt exist.
*
* @param iid image id
* @param cid collection id
* @return integer 1 on success, 0 when no rows were affected
*/
public int deleteImageFromCollection(int iid, int cid) {
String sql = "DELETE FROM " + getTagTable() + " WHERE imageid = '" + iid + "' AND collectionid = '" + cid + "'";
return delete(sql);
}
/**
* Delete the link between an image and a location. Returning 1 if the link is deleted,
* 0 when the link didnt exist.
*
* @param iid image id
* @param cid location id
* @return integer 1 on success, 0 when no rows were affected
*/
public int deleteImageFromLocation(int iid, int lid) {
String sql = "DELETE FROM " + getLocationTable() + " WHERE imageid = '" + iid + "' AND locationid = '" + lid + "'";
return delete(sql);
}
}