Hello All,
Ok not sure if this is the correct category to post this in
but ill try.
I have a large bespoked program throughout our company
allowing users to manage 'works orders' and other items via web
pages with cold fussion etc (normal stuff)
Just lately there is a need to trace when certain things are
deleted from our database, for auditing purposes.
I set up an SQL trigger on the table in question.. see below
----------------------------------------
CREATE TRIGGER [woDelete] ON dbo.worksorders
FOR DELETE
AS
INSERT INTO Audit_Wo (Actiontaken, auser, adate, wo)
SELECT 'D', USER_NAME (), GetDate(),Del.won from Deleted Del
----------------------------------------------
so every time a worksorder is deleted I get an audit record
in the Audit_wo table showing me what date, worksorder, and user
deleted it.
My problem is when a user deletes a worksordeer through our
off the shelf MRP program the 'USER_NAME()' is populated correctly
i.e I would see DOMAIN\username in the audit table.
However if a user deletes a worksorder via my bespoked
coldfussion pages the 'USER_NAME()' variable returns just 'dbo' im
assuming this is because its actually being deleted by the server
so therefore the user deleting it is realy the server and not the
user logged into a workstation.
How can I set a variable on my cold fussion page that would
then be seen by the SQL trigger, Im just not sure on how it works
can I just <cfset a variable up and then put that variable in my
SQL trigger or how do I pass a coldfussion variable to an SQL one.
im just confussed how I would do this.
I thought id ask here although im going to go and play now
see if I can resolve it as well.
Many Kind Regards Guy