Is there a gateway that monitors database changes (for example, new table records?)

[how2557215989vj]

Hi everybody,

I look for a gateway that watches changes in a database (e.g., insertions of records into a table, etc.), just like DirectoryWatcher monitors in a directory for files when they are created, modified, or deleted.

Which of the existing CF gateways is most suited for this purpose? or might it work with a few changes???

Is there a bespoke CF gateway that does this?

Thank you in advance.

[Charlie Arehart]

No cf gateway will support that. There are ways to audit such things from the db side--which makes sense all the more if you may have such db changes caused by other than the cf code.

[AXcrystallis]

Thank you Charlie for your response. You are right, through db it would much easier.

[Charlie Arehart]

Great to hear, and glad to help. I notice another user started the thread, how2557215989vj. Is that you as well, perhaps ?

[Mike Collins_CF]

Sounds like you want an insert trigger.  If you have a created timestamp column  you could monitor new records with a schedule task that looks for new records at some interval.

[BKBK]

This question was asked here - almost word for word - two months ago: https://community.adobe.com/t5/coldfusion-discussions/is-there-gateway-watching-changes-in-a-databas... 

ColdFusion hasn't changed much since then. 🙂