Pause between queries

[VMISteve]

I'm using CFMX with a Visual FoxPro database. I have a page that contains both
a Delete query and a Select query that access the same table. The Delete query
deletes certain records that belong to a sample id. The Select query then
queries the table to see if there are any records remaining for that sample id.
Sometimes, but not always, Cold Fusion will process the Delete query for a
sample id. and then the Select query will return a non-empty recordset for that
sample id. even though the Delete query completely removed all records for the
sample id. It's as if the server performs the Select query before the Delete
query has completely finished.

Is there a way to force Cold Fusion to pause after one query before processing
the next one?

[paross1]

Maybe it is a query cache issue. Or, perhaps try using CFTRANSACTION with a COMMIT between the delete and select, if FoxPro database supports it.

Phil

[VMISteve]

Thanks for the suggestion. I'll try the CFTRANSACTION.