Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating a relational database via an asp
Message
De
04/06/2003 10:06:34
Philip Jones
Cornwall County Council
Truro, Royaume Uni
 
 
À
04/06/2003 08:39:14
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00795654
Message ID:
00796163
Vues:
17
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform