asp_databases thread: executing a store porcedure from asp
Message #1 by =?iso-8859-1?Q?Carlos Pedro?= <cpedro@i...> on Wed, 21 Aug 2002 18:11:56 +0100
|
|
hi ,
I'm trying to execute a store porcedure in sql from an asp i want an
example if some one can send to me!!!
- the store procedure and the asp!!
Thanks for asking a lot
Message #2 by Dave.Parkins@m... on Wed, 21 Aug 2002 12:27:02 -0500
|
|
<%@LANGUAGE="VBSCRIPT"%>
<HTML>
<HEAD>
<BODY>
<%
set cmd = server.CreateObject("ADODB.Command")
set oRs = server.CreateObject("ADODB.recordset")
cmd.ActiveConnection="Driver={SQL Server};Server=;Database=;UID=;PWD
=;"
cmd.CommandTimeout = 0
cmd.CommandText = "P250Create_Invoice_Group"
*p250create_invoice_group is the stored procedure*
set oRs =cmd.Execute
%>
<FORM>
</FORM>
</BODY>
</HTML>
|
View Cart
