Buttons to pass Params to Stored Procedures

[MadBnz]

Hi,

I have a form with variables which I need to submit to a SQL 7 server.
When the user Clicks a button I want to send different information to different Stored Procedures on the SQL server based on the button pressed.
I've looked at using the onClick call function to call a subroutine as there is no data to return but I cant seem to get the client side VBScript to work...

Im sure this must be able to be done but as a newbie I can't figure exactly how to do it.
Thanks in Advance.

 

[dilettante]

Either pass a hidden item to your server-script, one you set in the button event before you trigger form.submit

Or... in your button event handler set the form.action to various ASP pages prior to triggering form.submit



So either use separate ASP pages, or in your common page invoke various stored procs based on the value of the hidden item.