Connecting Tech Pros Worldwide Forums | Help | Site Map

probs on asp-sql command

Member
 
Join Date: Sep 2006
Posts: 73
#1: Sep 24 '08
Expand|Select|Wrap|Line Numbers
  1. dim val
  2. set rm = Server.CreateObject ("ADODB.Command")
  3. rm.ActiveConnection=OBJdbConnection
  4. rm.CommandText="exec get_user"
  5.  
  6. rm.Parameters.Append rm.CreateParameter("RETURN",adInteger,adParamReturnValue,4)
  7.  
  8. rm.Parameters.Append rm.CreateParameter("@user_id",adVarChar,adParamInput,8,NoStaf)
  9.  
  10. rm.Parameters.Append rm.CreateParameter("@pwd",adVarChar,adParamInput,12,Pwd)
  11. rm.Execute 
  12. val=rm.Parameters("RETURN").Value 
  13.  
------------------------------------------------------------------------------------------------------------------ADODB.Command error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/Intranet/MainVal2.asp, line 14

acoder's Avatar
Site Moderator
 
Join Date: Nov 2006
Location: UK
Posts: 14,581
#2: Sep 24 '08

re: probs on asp-sql command


Moved from the Feedback forum to the ASP forum. Please post you questions in the correct forum and remember to use code tags when posting code.

Moderator.
Member
 
Join Date: Sep 2006
Posts: 73
#3: Sep 25 '08

re: probs on asp-sql command


Hi Hi, Gomenasai(Sorry)
Reply