Executing A Stored Procedure

[08091979]

What is the quickest way to execute a SQL Stored Procedure in ASP?

 

[Chopstik]

A search through some of the previous posts in this forum may help to answer this question. Otherwise, it might be beneficial to post a more specific question or offer some code as to what you have accomplished thus far.

------------------------------------------------------------------------------------------------------------------------
If you don't have a sense of humor, you probably don't have any sense at all.
- Anonymous

 

[Veep]

<%
fName = request.form("txtFName")
LName = request.form("txtLName")
Email = request.form("txtEmail")
Set Conn = Server.CreateObject("ADODB.CONNECTION")
Conn.Open yourConnString
strProc = "Exec myStoredProcedure @FName='" & fName & "',@LName='" & LName _
& "',@Email='" & Email & "'"
Conn.Execute(strProc)

 

[RhythmAddict112]

Is your stored proc returning any values? what kind of DB?