We have a cold fusion app with a fox database. I am trying to run a query that will return deleted records. I am not having much luck. I have tried adding the deleted line like:

<CFQUERY NAME="myquery"
    DATASOURCE="mydata"
    DELETED="yes"

SELECT field1 FROM table1
</CFQUERY>

That didn't work. If anyone has had experience with this, I would appreciate your help.
Kevin