|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
December 5th, 2004, 01:59 PM
|
|||
|
|||
|
Getting Stored Procedure Parameters - error need help
Below is the html code for getting the parameters I need for the Stored Procedure I created.
Getting the error: Error Type: ADODB.Command (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /maxi/sue_test/parameter.asp, line 17 line 17 is in red below ... what is wrong with it? <%@ LANGUAGE = VBScript %> <!-- #INCLUDE VIRTUAL="../adovbs.inc" --> <HTML> <HEAD><TITLE>Stored Proc Example</TITLE></HEAD> <BODY> <% Set Conn = Server.CreateObject("ADODB.Connection") ' The following line must be changed to reflect your data source info Conn.Open "maxihealth", "maxi", "bank" set cmd = Server.CreateObject("ADODB.Command") set cmd.ActiveConnection = Conn ' Specify the name of the stored procedure you wish to call cmd.CommandText = "changelevel" cmd.CommandType = adCmdStoredProc ' Query the server for what the parameters are cmd.Parameters.Refresh %> <Table Border=1> <TR> <TD><B>PARAMETER NAME</B></TD> <TD><B>DATA-TYPE</B></TD> <TD><B>DIRECTION</B></TD> <TD><B>DATA-SIZE</B></TD> </TR> <% For Each param In cmd.Parameters %> <TR> <TD><%= param.name %></TD> <TD><%= param.type %></TD> <TD><%= param.direction %></TD> <TD><%= param.size %></TD> </TR> <% Next Conn.Close %> </TABLE> </BODY> </HTML>
|
|
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Getting Stored Procedure Parameters - error need help |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
