I am using Coldfusion MX code to update some MS Access database tables.
I have written some code which checks to see if a record exists in a table and if it does then it deletes it.
What is happening is that the check confirms that the record exists but I then get an error message telling me that the record has been deleted when I try to delete it.
I have attached the code I use and a screenshot of the results.
Can anyone explain to me what is happening and how I can fix it.
<cfoutput>Status = 0<br></cfoutput>
SELECT * FROM SubmitAssessorAcceptance WHERE Subid=#thesub#;
<cfoutput>Record already exists</cfoutput>