After <cfquery> & <cfoutput> how do I close file(s)?

[josel]

Howdie friends!

I am just wondering how to close a file after I am through with <cfinquiry>/<cfoutput>.

I am not sure if close file everytime you run a query is a good idea (I have worked with applications where closing files put a heavy burden on server) and at the same time wonder if not closing them exposes the files to corruption or possibly locking other queries ...

Any comments on this will be appreciated;


josel
If you have the knowledge, consult and educate those who need it! - Jose Lerebours

 

[pigsie]

You dont need to close the database connection like asp. Connections are cached. This is set in the server administrator and is used to improve performance. Apparently this should not be used with access as it can lead to the db being corrupt but I have never ever seen this happen.

HTH

Kola

 

[josel]

pigsie,

Thank you for responding!

I can't do away with old habit of thinking in known language and try to write in new languare ... Not to mention making sure I don't mix the two

Regards;

josel If you have the knowledge, consult and educate those who need it! - Jose Lerebours