Stored Procedure calling

[inutelinside]

can we call a stored procedure via client scripting? How?

I want my stored procedure called before unloading or closing the window.

 

[BillyRayPreachersSon]

If you mean a SQL Server stored procedure, then the answer is no, you cannot do this with client-side scripting.

Hope this helps,
Dan


[tt]Dan's Page [blue]@[/blue] Code Couch

http://www.codecouch.com/dan/

[/tt]

 

[inutelinside]

any alternatives? other approach?

 

[BillyRayPreachersSon]

Well that depends on what you are trying to achieve - which you've not told us.

If you need to call SQL commands, or access a SQL server, you would normally use server-side scripting. If you are using ASP with JScript, this is definately the right place to ask. If not, you should probably ask in the forum related to whatever server-side technology you are using (ASP/VB, JSP, PHP, CFM, etc).

Dan

[tt]Dan's Page [blue]@[/blue] Code Couch

http://www.codecouch.com/dan/

[/tt]

 

[BabyJeffy]

As Dan mentions, there are server-side solutions... and you can trigger these using javascript (client-side). One method is to use AJAX... but basically all these "work arounds" provide is a means to run some server-side code.

So you can achieve the same thing with Javascript... using server-side code and triggering it using AJAX techniques.

Cheers
Jeff

[tt]Jeff's Page [/tt][tt]@[/tt][tt] Code Couch

http://www.codecouch.com/jeff/

[/tt]

What is Javascript? faq216-6094