Current Status of CFQUERY

[Guest]

Is there any way to know the status of cfquery Insert . i.e the insert was successful or aborted or any other returning Code which tells that ? .

[Stressed_Simon]

Unless you have set up your database in an unusual manner then SQL is either successful or throws an error.

[Guest]

hmm there is way around through triggers but that not what i am looking for . so CFQUERY it self is unable to return any status. interesting.

[Dan_Bracuk]

You could use cftry/cfcatch and write your own message of success. In fact, if your delete query has foreign key issues, this might not be a bad idea.

Actually a better idea is to delete the related records first.

[drforbin1970]

If you are using SQL Server, read the Books Online under Help in SQL Query Analyzer. Look into @@ROWCOUNT, RAISERROR, BEGIN TRANSACTION, ROLLBACK TRANSACTION. Also look into CFTRANSACTION in CF.

A quick, simple way is to run a select immediately following the insert. If the record is there, the insert was successful.
This is just a quick and dirty way to check. There are better options.