Snippet for attachment shows incorrect data - see comment for fix

Verified that pdftotext is returning the correct information. The snippet seems to come from $file->data, but that field has nothing to do with the contents of $file->filename. In addition, $file->nid is the same for all returned results. For now, I've commented out the line that starts with $snippet =>.

The query in search_files_attachment is incorrect. Adding the AND clause at the end fixes it.

$file = db_fetch_object(db_query("
SELECT f.*, d.data, u.nid
FROM {files} AS f
JOIN {upload} AS u
USING(fid)
INNER JOIN {search_dataset} AS d
ON f.fid = d.sid
WHERE fid = %d
AND d.type='search_files_att'
", $item->sid));