How to create a text file from a query

["mega_L" <webforumsuser@xxxxxxxxxxxxxx>]

I need to generate a text file with CF. What I have is a query result with the 
values from 3 columns, OrderID, VersionID and Amount. I need to generate 
something like this:
 0000123 | 002 | 1
 0000124 | 002 | 2
 0000125 | 002 | 5
 0000126 | 002 | 1  and so on

 I know I have to use <CFFILE action="write" file="#somepath#Invoice.txt .....>
 but I'm not sure how can I output my query result into this text file??????
 Please help....