Thread: Recordset and Stored Procedure issues!

Originally Posted by mehere

do you have an include file like adovbs.inc on your page? if so, remove your const lines.

Error Type:
Microsoft VBScript compilation (0x800A03EE)
Expected ')'
edit1.asp, line 20, column 12

this is line 20:

Code:

("@username",adVarChar,adParamInput,50,session("username"))

Originally Posted by Wolffy

What you have there is only a fragment of a statement. Is it a continuation of the previous line? as in

Code:

cmd.Parameters.Append cmd.CreateParameter &_
      ("@username",adVarChar,adParamInput,50,session("username"))

sorry not sure what you mean? are you saying i need to do the same thing for first name and surname? wouldnt this be pointless as the parameters and datatypes are defined in the stored procedure??

Originally Posted by Wolffy

Uh, no. What I'm say is that the statement you posted is not a valid statement in and of itself. Unless it's part of a complete statement, as I've shown, it's going to throw an error. What the line right before the line in error?

this is the line..

Code:

cmd.Parameters.Append cmd.CreateParameter &_

Originally Posted by Wolffy

Ach, remove the ampersand. It seems it was in the example code and just kept getting missed. We most definitely do NOT was to concatenate two strings here.

Code:

cmd.Parameters.Append cmd.CreateParameter _
      ("@username",adVarChar,adParamInput,50,session("username"))

Or maybe better, just put the whole statement on one line and furgettaboutit

Code:

cmd.Parameters.Append cmd.CreateParameter("@username",adVarChar,adParamInput,50,session("username"))

Code:

<%
Dim cmd, rs, connect, intNumber


Set cmd = Server.CreateObject ("ADODB.Command")
connect = "Provider=SQLOLEDB;Persist Security Info=False;User ID=sa; &;Password=test;" ;"Initial Catalog=coursesSQL;Data Source=MY DB LOCATION"
      
      

cmd.ActiveConnection = connect
cmd.CommandText = "MY STORED PROC"
cmd.CommandType = adCmdStoredProc

cmd.Parameters.Append cmd.CreateParameter("@username",adVarChar,adParamInput,50,session("username"))


Set rs = cmd.Execute

intNumber = comm.Parameters("@username")
set cmd = nothing
%>

I am annoyed, i got an error now,

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
edit1.asp, line 12, column 87


once i learn how to do this propely, ill be more confident in doing my other many stored procedures and calling them from other pages..

[edit]

below is line 12

Code:

connect = "Provider=SQLOLEDB;Persist Security Info=False;User ID=sa; &;Password=test;" ;"Initial Catalog=coursesSQL;Data Source=db location"