Hi Chris,

The best way I have ever handled this is to create a stored proc.  Call the
stored proc as normal and let it make the a new connection, log and commit
accordingly that way it can be done without interfering with the current
transation state allowing rollback if required.

Cheers
Simon.

2008/7/7 Chris Velevitch <[EMAIL PROTECTED]>:

>
> How do you do application logging into the same database inside a
> transaction that might get rolled back?
>
> --
> Chris
> --
> Chris Velevitch
> Manager - Adobe Platform Users Group, Sydney
> m: 0415 469 095
> www.apugs.org.au
>
> Adobe Platform Users Group, Sydney
> July meeting: Taming The Code
> Date: Mon 28th July 6pm for 6:30 start
> Details to follow.
>
> >
>


-- 
Cheers
Simon Haddon

Woman loves feeling danger and speed. That is why woman wants man. They get
a speed rush that is the most dangerous of all.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to