You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Problem viewing files that were saved as Attachments using PSoft functions

No replies
rjmerryman's picture
User offline. Last seen 6 years 41 weeks ago. Offline
Joined: 12/06/2011
Posts: 1

Hello,

I was able to apply the code delivered in FILE_ATTACH_WRK to send an attachment to our server, and also to retrieve (view) the file. But something is happening to the files when I return them from the server to view them. For example, I saved a text file, but when I pull the file back to view it appears that all the carriage returns have been removed. A file saved like this....

-- Script : delete_bad_referral.sql
--
-- 01/10/2011 rjm
--
-- Return failure code when program does not complete successfully
whenever sqlerror exit failure;
whenever oserror exit failure;

Comes back looking like this:

-- Script : delete_bad_referral.sql -- -- 01/10/2011 rjm -- -- Return failure code when program does not complete successfully whenever sqlerror exit failure; whenever oserror exit failure; set echo on set feedback on set head off set linesize 500 --select select * FROM sysadm

Has anyone seen this before? Know how to correct it?

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
4 + 0 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.