I have problem with inserting new records. The problem is weird I must say. Sometimes I get a double entries, sometimes I dont. This is making me crazy as I never know when its gonna come out double again.
First of all, I checked on my code, its not running twice (most of friend told me this!).
Secondly, I tried to query my table before inserting a new record, if found a same record (with the same batch of data), then delete it (not working too!!)
Thirdly, I put a <cflock> in all my insert statements, and it doesnt seems to work too.
So my question is, can anyone tell me what's going on here and how can I solve this as it comes and go, comes and go, unpredictable!