|
 |
asp_databases thread: Running Script from trigger
Message #1 by giles.pepper@e... on Thu, 18 Oct 2001 13:45:53
|
|
HI...
Is it possible to get SQL Server to run an ASP script from a proceedure or
trigger...if so any hints on how to do this
Thanks
GDP
Message #2 by David Cameron <dcameron@i...> on Fri, 19 Oct 2001 10:18:34 +1000
|
|
Why?
regards
David Cameron
nOw.b2b
dcameron@i...
Is it possible to get SQL Server to run an ASP script from a proceedure or
trigger...if so any hints on how to do this
Message #3 by "Tomm Matthis" <matthis@b...> on Fri, 19 Oct 2001 08:27:17 -0400
|
|
You can call the xp_cmdshell proc from within your proc which runs "iexplore
youraspfile.asp".
Hope that helps.
-- Tomm
> -----Original Message-----
> From: David Cameron [mailto:dcameron@i...]
> Sent: Thursday, October 18, 2001 8:19 PM
> To: ASP Databases
> Subject: [asp_databases] RE: Running Script from trigger
>
>
>
> Why?
>
> regards
> David Cameron
> nOw.b2b
> dcameron@i...
>
> -----Original Message-----
> From: giles.pepper@e... [mailto:giles.pepper@e...]
> Sent: Thursday, 18 October 2001 11:46 PM
> To: ASP Databases
> Subject: [asp_databases] Running Script from trigger
>
>
> HI...
>
> Is it possible to get SQL Server to run an ASP script from a proceedure or
> trigger...if so any hints on how to do this
>
> Thanks
>
> GDP
>
>
>
> $subst('Email.Unsub')
>
>
Message #4 by giles.pepper@e... on Mon, 22 Oct 2001 08:25:41
|
|
Thanks...that sounds hopeful...i'll give it a try later today
> You can call the xp_cmdshell proc from within your proc which
runs "iexplore
> youraspfile.asp".
>
> Hope that helps.
>
> -- Tomm
>
> > -----Original Message-----
> > From: David Cameron [mailto:dcameron@i...]
> > Sent: Thursday, October 18, 2001 8:19 PM
> > To: ASP Databases
> > Subject: [asp_databases] RE: Running Script from trigger
> >
> >
> >
> > Why?
> >
> > regards
> > David Cameron
> > nOw.b2b
> > dcameron@i...
> >
> > -----Original Message-----
> > From: giles.pepper@e... [mailto:giles.pepper@e...]
> > Sent: Thursday, 18 October 2001 11:46 PM
> > To: ASP Databases
> > Subject: [asp_databases] Running Script from trigger
> >
> >
> > HI...
> >
> > Is it possible to get SQL Server to run an ASP script from a
proceedure or
> > trigger...if so any hints on how to do this
> >
> > Thanks
> >
> > GDP
> >
> >
> >
> > $subst('Email.Unsub')
> >
> >
>
Message #5 by giles.pepper@e... on Mon, 22 Oct 2001 08:29:47
|
|
why...because it's there!!!
and because i've inherited a big database with lots of triggers and stored
proceedures and I am not a database person so it's easier for me to write
scripts than new proceedures etc...I intend to learn it all but the job
needs me to produce results now so I'm getting things done the only way I
know how.
> Why?
>
> regards
> David Cameron
> nOw.b2b
> dcameron@i...
>
> -----Original Message-----
> From: giles.pepper@e... [mailto:giles.pepper@e...]
> Sent: Thursday, 18 October 2001 11:46 PM
> To: ASP Databases
> Subject: [asp_databases] Running Script from trigger
>
>
> HI...
>
> Is it possible to get SQL Server to run an ASP script from a proceedure
or
> trigger...if so any hints on how to do this
>
> Thanks
>
> GDP
>
Message #6 by David Cameron <dcameron@i...> on Mon, 22 Oct 2001 17:44:13 +1000
|
|
Fair enough.
The reason I asked if because if there was anything that I could think of
that I would be most unlikely to call from a proc would be an ASP page. I
can understand .exe, .dll or some script, but not .asp. But I guess if it is
already there...
Mind you I would suggest that you become a database person really quickly
:-). I have more fun in databases than anything else I do.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: giles.pepper@e... [mailto:giles.pepper@e...]
Sent: Monday, 22 October 2001 6:30 PM
To: ASP Databases
Subject: [asp_databases] RE: Running Script from trigger
why...because it's there!!!
and because i've inherited a big database with lots of triggers and stored
proceedures and I am not a database person so it's easier for me to write
scripts than new proceedures etc...I intend to learn it all but the job
needs me to produce results now so I'm getting things done the only way I
know how.
> Why?
>
> regards
> David Cameron
> nOw.b2b
> dcameron@i...
>
> -----Original Message-----
> From: giles.pepper@e... [mailto:giles.pepper@e...]
> Sent: Thursday, 18 October 2001 11:46 PM
> To: ASP Databases
> Subject: [asp_databases] Running Script from trigger
>
>
> HI...
>
> Is it possible to get SQL Server to run an ASP script from a proceedure
or
> trigger...if so any hints on how to do this
>
> Thanks
>
> GDP
>
Message #7 by giles.pepper@e... on Wed, 24 Oct 2001 10:53:42
|
|
hi...
actually...my poor use of terminology is probably to blame here...when i
say ASP script i don't actually mean one that produces a web page, i mean
just a bit of vbscript that can do stuff to the database...my reasoning is
that say i have a trigger on a table that fires on an update. that may
set off a proceedure that has been written by the developer who wrote this
system to do some horribly complex stuff all written in stored proceedure
SQL. I have only just started to look at that kind of thing and it makes
me want to weep with fear. So, instead of having the trigger set off the
existing proceedure I could get it to run my script which would perform
the same updates whatever as the the proceedure but which was written by
me in a langauge that i can understand. I am learning about the way
proceedures are written but I 'm in a position where I have a system that
is in constant use and there is no backup/development server to try stuff
out on!!! Therefore any mistakes I make will impact on the working
system. I am therefore avoiding modifying any of the existing stuff where
i can and writing little scripts to do things that can replace them when
they work. Eight weeks so far and the company is still in business!!!
regards
> Fair enough.
>
> The reason I asked if because if there was anything that I could think of
> that I would be most unlikely to call from a proc would be an ASP page. I
> can understand .exe, .dll or some script, but not .asp. But I guess if
it is
> already there...
>
> Mind you I would suggest that you become a database person really quickly
> :-). I have more fun in databases than anything else I do.
>
> regards
> David Cameron
> nOw.b2b
> dcameron@i...
>
> -----Original Message-----
> From: giles.pepper@e... [mailto:giles.pepper@e...]
> Sent: Monday, 22 October 2001 6:30 PM
> To: ASP Databases
> Subject: [asp_databases] RE: Running Script from trigger
>
>
> why...because it's there!!!
>
> and because i've inherited a big database with lots of triggers and
stored
> proceedures and I am not a database person so it's easier for me to
write
> scripts than new proceedures etc...I intend to learn it all but the job
> needs me to produce results now so I'm getting things done the only way
I
> know how.
>
> > Why?
> >
> > regards
> > David Cameron
> > nOw.b2b
> > dcameron@i...
> >
> > -----Original Message-----
> > From: giles.pepper@e... [mailto:giles.pepper@e...]
> > Sent: Thursday, 18 October 2001 11:46 PM
> > To: ASP Databases
> > Subject: [asp_databases] Running Script from trigger
> >
> >
> > HI...
> >
> > Is it possible to get SQL Server to run an ASP script from a
proceedure
> or
> > trigger...if so any hints on how to do this
> >
> > Thanks
> >
> > GDP
> >
>
|
|
|
View Cart
