Calling a stored procedure with parameters (VB Script)

Added By: logicaldove

(4 of 5) by 2.
Rate Snippet:
Description:  This code assumes that you have a form on another page that sends on the clientid variable. It calls the stored procedure using the clientid variable as it's only input parameter. The variable 'rs' will be the recordset returned that you may use as you like (in a 'while not rs.eof' loop perhaps) I included the stored procedure definition at the bottom just to show how the input parameter is used.
Language:  Visual Basic Script

Save to web space
E-mail Link

Code Snippet: