Error with call to stored procedure....

[Mayoor]

Im getting this error

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' 

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ','. 

/etads/rptgrpchange(new).asp, line 20
code]

line 20 is

[code]
myConn.Execute ("usp_UpdateRptGrpPrimDeltest " & lngRptGrpID & ",'" & Request("cbo_PrimDel" & rst("lngRptGrpID")) & "'")

Please can someone help with this probelm.....?

 

[Kendel]

try this:

myConn.Execute ("usp_UpdateRptGrpPrimDeltest " & lngRptGrpID & ",'" & Request("cbo_PrimDel") & "','" & rst("lngRptGrpID")) & "'")

 

[DreXor]

Or try :
myConn.Execute ("usp_UpdateRptGrpPrimDeltest (" & lngRptGrpID & ",'" & Request("cbo_PrimDel" & rst("lngRptGrpID")) & "')")



DreX
aKa - Robert

 

[ignoreme]

or try this:

set cmdProj = server.CreateObject("ADODB.Command")
   with cmdProj
	.ActiveConnection = db_connstring
	.CommandText = "usp_UpdateRptGrpPrimDeltest"
	.CommandType = adCmdStoredProc
	.Parameters.Refresh 
	.Parameters("@lngRptGrpID")= lngRptGrpID
	.Parameters("@cbo_PrimDel") = Request("cbo_PrimDel")
	set rsRec = .Execute (ret, , adExecuteNoRecords)
  end with
//use rsRec with whatever
  set rsRec = nothing
  set cmdProj = nothing