Duplication cfmail

[Guest]

Hi i am getting a duplication problem using cfmail, i am looping through a table using a query then sending a cfmail then deleting the current row from the table, this is all in a cf scheduled task, but for som reason i am getting duplicates any ideas why this would be?

[Oğuz_Demirkapı]

I think you have duplicated e-mail in your resultset. Just try to check your query dump in order to detect the problem. :)

[Guest]

no i have put a check in place to delete if the id number is the same, as my code below using the "NewID", but still the id number is appearing twice in the cfmail sending logs.

any ideas?