How can you check if a file has been uploaded using a query?

You can use the FileCount variable in a query like: SELECT CASE WHEN $PFileCount$<=0 THEN 0 ELSE 1 END. This checks whether any files are attached without accessing the file content directly.