From 789021d9288228e8bae9c3fdedd696c0169a1bbd Mon Sep 17 00:00:00 2001 From: Robert Sesek Date: Sat, 15 Oct 2005 18:11:31 +0000 Subject: [PATCH] r552: Cleaned up the attachment query so we're not grabbing the BLOB --- showreport.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/showreport.php b/showreport.php index 0cfa9c3..6027817 100644 --- a/showreport.php +++ b/showreport.php @@ -245,8 +245,10 @@ $show['attachments'] = ($show['getattachments'] OR $show['putattachments']) ? tr if ($show['getattachments'] OR $show['putattachments']) { $attachments_fetch = $db->query(" - SELECT attachment.*, user.email, user.showemail, - user.displayname + SELECT attachment.attachmentid, attachment.filename, + attachment.description, attachment.dateline, + attachment.userid, attachment.obsolete, user.email, + user.showemail, user.displayname FROM " . TABLE_PREFIX . "attachment AS attachment LEFT JOIN " . TABLE_PREFIX . "user AS user ON (attachment.userid = user.userid) -- 2.22.5