Buttons to Pass Params to SQL 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.

 

[RobSchultz]

Could you not simply submit the info to a different ASP page which could then pass the parameters to SQL.

-Rob Rob
robschultz@yahoo.com
-Focus on the solution to the problem, not the obstacles in the way.-

 

[SrinuReddy]

Add a hidden text in your form and depending on the button clicked put some value in the hidden text.
Submit the form and in the server side check for the value of the hidden text and depending on this value execute the stored proc.

Hope this helps...

srinu...