Session Variable For A Sequel Trigger

[GJones]

Is there away to capture a session variable value from IIS
and use it in a SQL 2000 trigger with out passing it as a
part of a string query. I just want to capture it somehow
systemically.

Thanks,
Greg

[Tom B]

Re: Session Variable For A Sequel Trigger

How about just storing the session variable value, somewhere in the SQL
server?


"GJones" <support@snapan swers.com> wrote in message
news:070f01c3af 00$178440f0$a30 1280a@phx.gbl.. .[color=blue]
> Is there away to capture a session variable value from IIS
> and use it in a SQL 2000 trigger with out passing it as a
> part of a string query. I just want to capture it somehow
> systemically.
>
> Thanks,
> Greg
>[/color]

[Greg Jones]

Re: Session Variable For A Sequel Trigger

Tom;

I do not know how to get it from where it is being held in IIS over to
Sequel without passing it in a string query. The need originates
because I have a before trigger to track changes on a table but for the
delete the session user name never gets passed because it is a delete.

Got any ideas on how to do it without passing it as a string?

Thanks for your help



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Bob Barrows]

Re: Session Variable For A Sequel Trigger

GJones wrote:[color=blue]
> Is there away to capture a session variable value from IIS
> and use it in a SQL 2000 trigger with out passing it as a
> part of a string query. I just want to capture it somehow
> systemically.
>
> Thanks,
> Greg[/color]

No, you will not be able to use a trigger for this. Instead, create a stored
procedure to which you pass the value as a parameter, and have the stored
procedure do the task that you are intending the trigger to do. You will
need to remove DELETE permissions on the table so all deletions will need to
be done via the stored procedure.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[TomB]

Re: Session Variable For A Sequel Trigger

Not sure I fully understand, but how about setting up a stored procedure,
that is called from ASP. This Stored Procedure would take the user name as
a parameter and could then delete whatever needs to be deleted, and update
the "tracking" table.

Just a thought



"Greg Jones" <support@snapan swers.com> wrote in message
news:OCNNUKxrDH A.2028@TK2MSFTN GP10.phx.gbl...[color=blue]
> Tom;
>
> I do not know how to get it from where it is being held in IIS over to
> Sequel without passing it in a string query. The need originates
> because I have a before trigger to track changes on a table but for the
> delete the session user name never gets passed because it is a delete.
>
> Got any ideas on how to do it without passing it as a string?
>
> Thanks for your help
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]