Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating a relational database via an asp
Message
From
04/06/2003 10:06:34
Philip Jones
Cornwall County Council
Truro, United Kingdom
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00795654
Message ID:
00796163
Views:
18
I've got this code in my asp...

<%
Dim Conn, sSQL, nextRef

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "BlahBlah","Username","Password"
Set Cmd = Server.createObject("ADODB.command")
Set Cmd.ActiveConnection = Conn
cmd.CommandText="usp_saveaddress"
cmd.CommandType = adCmdStoredProc
cmd.Parameters.Append cmd.CreateParameter("RetVal", adInteger, _
adParamReturnValue)
cmd.Parameters.Append cmd.CreateParameter("param1", adInteger, _
adParamInput)
cmd.Parameters.Append cmd.CreateParameter("param2", adInteger, _
adParamInput)
cmd.param1=Request.Form("Surname")
cmd.param2=Request.Form("Forname")
Cmd.Execute

Response.Write "

Thank you. Your information has been added to our database!

"
%>


It doesn't like this line though.

cmd.CommandType = adCmdStoredProc

It gives me error messages saying...

ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.


Do you have any idea what's going on here?

I don't.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform