SQl Trigger and Session

[shiggyshag]

Hi

Not sure where to post this so I will try here.

I have an asp.net form which makes changes to a table via a stored procedure this then runs an sql trigger but I want to pass an asp.net seesion to the trigger so it can add this to the table.

Any ideas on how to do this?

Cheers

 

[ca8msm]

I want to pass an asp.net seesion to the trigger so it can add this to the table

Do you just mean the session id?



____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[shiggyshag]

Hi

No I set session("UserID") and i need to insert that.

Cheers

 

[ca8msm]

Why don't you pass the session variable to the stored procedure then? If the SP inserts it into the table that is getting changed, the presumably you can modify your trigger to pick this value up?


____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.