[SQL] access to new/old in dynamic sql for audit table

2005-06-08 Thread Jay Parker
an easier way to get the name of the schema associated with a table from inside a trigger, rather than the trigger argument kludge I used above? Thanks, -jbp -- Jay Parker - UALR Computing Services - Networks Project Manager [EMAIL PROTECTED] - http://www.ualr.edu/jbparker - 501-569-334

Re: [SQL] triggering an external action

2005-05-17 Thread Jay Parker
On 05/17/2005 01:07 PM, Bricklen Anderson wrote: How about LISTEN and NOTIFY, would they work for this? Yes, that is precisely what I need... and what I have somehow overlooked during at least a dozen passes through the docs. Sigh. Thanks for your help, -jbp -- Jay Parker - UALR Computing

[SQL] triggering an external action

2005-05-17 Thread Jay Parker
nd if not, which of the other mailing lists would be the most appropriate place for me to discuss the best way to implement an OS-level solution?) Thanks, -jbp -- Jay Parker - UALR Computing Services - Networks Project Manager [EMAIL PROTECTED] - http://www.ualr.edu/jbparker -