Classic ASP ProfessionalFor advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
i was using stored procedure(passing input parameters) for a simple updation in database( SQL server). I encountered following error in asp page which calls the stored procedure. Error Type:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. line 27
here is that part of the ASP code set cmdCalculate = Server.CreateObject("ADODB.Command")
Set strconn = Server.CreateObject("ADODB.Connection")
' The following line must be changed to reflect your data source info
Conn.Open "Yoour connection", "user id", "password" set cmdCalculate = Server.CreateObject("ADODB.Command")
set cmdCalculate.ActiveConnection = strconn
' Specify the name of the stored procedure you wish to call
cmdCalculate.CommandText = "usp_CalculateCalories"
cmdCalculate.CommandType = adCmdStoredProc
' Query the server for what the parameters are
<% For Each param In cmdCalculate.Parameters %>
<TD><%= param.name %></TD>
<TD><%= param.type %></TD>
<TD><%= param.direction %></TD>
<TD><%= param.size %></TD>