SELECT * from table1 where not deleted()

is what works in VFP. Whether you can pass that directly in CF...I'm not sure if the ODBC connection would allow it.

--- Larry


>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