creating file then pgp encrypting

[olmos]

How can I have a file created from a query output.
This would need to be created on to the unix server.
I used cffile create but I want it to be created on the
server not on the local machine , I am not sure how
to do this.

Then I need to somehow pgp encrypt the file and
mail it out. any suggestions on how to do this?

Thanks in advance for your help,
olmos

 

[tleish]

I did a similar thing recently for a client, but used gnupg instead.

[ol][li]Created a txt file from a query and saved it to a different machine on the network using cffile[/li]
[li]Created a batch file that was saved on a different machine than the network. It executed the gnupg, and encrypted the txt file. I executed this batch file and passed parameters to it using CFEXECUTE, it worked great.[/li][/ol] - tleish