Coldfusion9 ORM

2009-07-24 Thread Gavin Stewart
Hello there, I have a question about cf9 orm. I am trying to add a postInsert() event on a persistent cfc which basically logs the action in an audit table. My code looks like this. public void function postInsert(){ //log the action Audit=entitynew('Audit'); Audit.setItem_type('Art');

Re: Coldfusion9 ORM

2009-07-24 Thread Gavin Stewart
Be sure to turn on event handling in Application.cfc, this.ormsettins.eventhandling = true; I have done this and it does definatley trigger the event. I can dump out the Audit object in the event handler and I see it there. It just doesnt save to the database. There are no errors, logs or any

Re: Coldfusion9 ORM

2009-07-24 Thread Gavin Stewart
1) Are you sure you are looking at the correct data source? 2) Have you run a trace on the database while the page execute to confirm if _any_ SQL is being run? 1) Yes as far as i know you can only use one data source in orm. 2) The insert statement gets executed in the object but the Audit

Re: Converting Year to Integer

2009-07-24 Thread Gavin Stewart
Yes thats a typo in my email.Adding ## sign does not help you need to remove the quotes araound 2000 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing