Click here to Skip to main content
16,011,784 members
Home / Discussions / Web Development
   

Web Development

 
GeneralWSDL in VS.NET Pin
moredip3-Feb-03 6:22
moredip3-Feb-03 6:22 
Generalsetting value of file input field Pin
particle2k3-Feb-03 3:41
particle2k3-Feb-03 3:41 
GeneralRe: setting value of file input field Pin
Heath Stewart3-Feb-03 4:09
protectorHeath Stewart3-Feb-03 4:09 
GeneralA little help w/ Javascript and DHTML please Pin
georgiek502-Feb-03 2:21
georgiek502-Feb-03 2:21 
GeneralRe: A little help w/ Javascript and DHTML please Pin
Stephane Rodriguez.2-Feb-03 4:43
Stephane Rodriguez.2-Feb-03 4:43 
GeneralRe: A little help w/ Javascript and DHTML please Pin
georgiek502-Feb-03 7:11
georgiek502-Feb-03 7:11 
GeneralRe: A little help w/ Javascript and DHTML please Pin
Stephane Rodriguez.2-Feb-03 7:45
Stephane Rodriguez.2-Feb-03 7:45 
GeneralADODB.command --- trouble with adParamInput/Output Pin
devvvy1-Feb-03 22:30
devvvy1-Feb-03 22:30 
Hi, having some touble with ADODB.command

Here's the ASP code snippet:

...
...
...

Set oCmd = Server.CreateObject("ADODB.Command")

With oCmd

.ActiveConnection = oConn
.CommandText = "sproc_AddUser"
.CommandType = adCmdStoredProc

.Parameters.Append .CreateParameter("@login", adChar, adParamInput, 15, Request.Form("txtLogin") )
.Parameters.Append .CreateParameter("@password", adChar, adParamInput, 15, Request.Form("txtPasswd") )
.Parameters.Append .CreateParameter("@first_name", adChar, adParamInput, 50, Request.Form("first_name") )
.Parameters.Append .CreateParameter("@cust_service_level", adInteger, adParamInput, 5, CInt(Request.Form("cust_service_level")) )
...
... a whole bunch of other parameters ...
...
If Request.Form("user_category")="0" Then
.Parameters.Append .CreateParameter("@bClientStatus", adInteger, adParamInput, 4, 1)
Else
.Parameters.Append .CreateParameter("@bClientStatus", adInteger, adParamInput, 4, 0) ****** LINE_1 *****
End If

.Parameters.Append .CreateParameter("@error_status", adInteger, adParamOutput, 4, 0) ***** LINE_2 *****


'Execute the stored procedure:
.Execute


End With

ERROR MESSAGE:

"Microsoft OLE DB Provider for SQL Server error '80040e14'

Formal parameter '@bClientStatus' was defined as OUTPUT but the actual parameter not declared OUTPUT.

/registration.asp, line 227"

QUESTION 1:
Objection!@@!! Can you see that "bClientStatus" was explicitly defined to be "adParamInput" in the code snippet above (LINE_1)? The funny thing is, if I remove LINE_2, the code executed with no error!??

QUESTION 2: How can you extract return value?

Thanks a bunch!

norm
GeneralRe: ADODB.command --- trouble with adParamInput/Output Pin
devvvy1-Feb-03 22:40
devvvy1-Feb-03 22:40 
QuestionCDONTS - IIS/SMTP config? Pin
devvvy1-Feb-03 8:00
devvvy1-Feb-03 8:00 
AnswerRe: CDONTS - IIS/SMTP config? Pin
Vasudevan Deepak Kumar1-Feb-03 21:21
Vasudevan Deepak Kumar1-Feb-03 21:21 
GeneralRe: CDONTS - IIS/SMTP config? Pin
devvvy1-Feb-03 21:33
devvvy1-Feb-03 21:33 
GeneralWhats wrong in my ASPMail Pin
Sarvesvara (BVKS) Dasa31-Jan-03 21:07
Sarvesvara (BVKS) Dasa31-Jan-03 21:07 
GeneralRe: Whats wrong in my ASPMail Pin
Jon Sagara31-Jan-03 21:18
Jon Sagara31-Jan-03 21:18 
GeneralRe: Whats wrong in my ASPMail Pin
Sarvesvara (BVKS) Dasa31-Jan-03 21:28
Sarvesvara (BVKS) Dasa31-Jan-03 21:28 
GeneralI think I have similar problem... Pin
devvvy31-Jan-03 22:23
devvvy31-Jan-03 22:23 
GeneralRe: I think I have similar problem... Pin
Sarvesvara (BVKS) Dasa1-Feb-03 18:21
Sarvesvara (BVKS) Dasa1-Feb-03 18:21 
GeneralRe: I think I have similar problem... Pin
devvvy1-Feb-03 18:38
devvvy1-Feb-03 18:38 
GeneralRe: I think I have similar problem... Pin
Sarvesvara (BVKS) Dasa1-Feb-03 18:54
Sarvesvara (BVKS) Dasa1-Feb-03 18:54 
GeneralRe: I think I have similar problem... Pin
devvvy1-Feb-03 22:43
devvvy1-Feb-03 22:43 
GeneralRe: I think I have similar problem... Pin
Sarvesvara (BVKS) Dasa2-Feb-03 18:52
Sarvesvara (BVKS) Dasa2-Feb-03 18:52 
GeneralRe: I think I have similar problem... Pin
devvvy2-Feb-03 19:18
devvvy2-Feb-03 19:18 
GeneralRe: I think I have similar problem... Pin
Sarvesvara (BVKS) Dasa2-Feb-03 20:04
Sarvesvara (BVKS) Dasa2-Feb-03 20:04 
GeneralRe: I think I have similar problem... Pin
devvvy2-Feb-03 20:06
devvvy2-Feb-03 20:06 
GeneralRe: I think I have similar problem... Pin
Sarvesvara (BVKS) Dasa2-Feb-03 20:13
Sarvesvara (BVKS) Dasa2-Feb-03 20:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.