Click here to Skip to main content
15,910,603 members
Home / Discussions / Web Development
   

Web Development

 
QuestionFirst Spring Login Page Pin
sanuji29-Mar-09 19:07
sanuji29-Mar-09 19:07 
AnswerRe: First Spring Login Page Pin
Yusuf30-Mar-09 10:15
Yusuf30-Mar-09 10:15 
QuestionClass diagram Pin
CrimeanTurtle200829-Mar-09 15:17
CrimeanTurtle200829-Mar-09 15:17 
AnswerRe: Class diagram Pin
Yusuf30-Mar-09 10:16
Yusuf30-Mar-09 10:16 
QuestionSender ID question Pin
MarkB77728-Mar-09 22:56
MarkB77728-Mar-09 22:56 
AnswerRe: Sender ID question Pin
Marc Firth29-Mar-09 23:48
Marc Firth29-Mar-09 23:48 
AnswerRe: Sender ID question Pin
Marc Firth29-Mar-09 23:52
Marc Firth29-Mar-09 23:52 
QuestionCalling stored procedure from ASP page. Pin
Kiran S. S.27-Mar-09 18:20
Kiran S. S.27-Mar-09 18:20 
I have created a stored procedure in SQL Server 2005. I am trying to call that procedure from ASP (Classic asp) page. The stored procedure returns a recordset of this query.

SELECT Count(worklist_P.wrkID) AS Total, Sum(CASE WHEN complited = 'True' then 1 else 0 end) AS [comp], 
Sum(Case when readed = 'False' then 1 else 0 end) AS new, 
Sum(Case When complited = 'False' then 1 else 0 end) AS pend 
FROM (employee_Master INNER JOIN worklist_C ON employee_Master.empID = worklist_C.assignedWhom) 
INNER JOIN worklist_P ON worklist_C.wrkID = worklist_P.wrkID WHERE (((worklist_C.assignedWhom)=@empId));



I am calling that procedure in following code:

set cmd = Server.CreateObject("ADODB.Command")
	cmd.ActiveConnection = con
	cmd.CommandText = "wrksCnt"
	cmd.CommandText = "{call wrksCnt(?)}"			
	cmd.Parameters.Append cmd.CreateParameter("@empId", 3, 1)
        cmd.Parameters("@empId") = 2
	set rsWork = cmd.Execute()


But it is not returning anything. I have tried executing above stored procedure in SQL Server 2005. It is running well. Giving proper output.

I have also tried this code to

strSql = "exec wrksCnt '" & Session("empID") & "'"
set rsWork = con.Execute(strSql)

This code is also not returning any value. Please guide how to call stored procedure properly in classic asp page.

Kiran Sajanikar
Software Engineer
Pune, India

AnswerRe: Calling stored procedure from ASP page. Pin
Yusuf30-Mar-09 10:18
Yusuf30-Mar-09 10:18 
GeneralCalling stored procedure from ASP page. Pin
Kiran S. S.30-Mar-09 23:20
Kiran S. S.30-Mar-09 23:20 
QuestionCalling stored procedure from ASP page. Pin
Kiran S. S.31-Mar-09 2:00
Kiran S. S.31-Mar-09 2:00 
QuestionCalling stored procedure from ASP page. Pin
Kiran S. S.31-Mar-09 22:00
Kiran S. S.31-Mar-09 22:00 
QuestionAny one there, Please help me Pin
Kiran S. S.1-Apr-09 18:45
Kiran S. S.1-Apr-09 18:45 
QuestionSticky page footers and absolute control positioning Pin
Greg Chelstowski27-Mar-09 2:27
Greg Chelstowski27-Mar-09 2:27 
AnswerRe: Sticky page footers and absolute control positioning Pin
Greg Chelstowski27-Mar-09 5:22
Greg Chelstowski27-Mar-09 5:22 
AnswerRe: Sticky page footers and absolute control positioning Pin
bulg30-Mar-09 11:00
bulg30-Mar-09 11:00 
Questione-learning Survey Pin
Poonam Gandash26-Mar-09 19:34
Poonam Gandash26-Mar-09 19:34 
AnswerRe: e-learning Survey Pin
SeMartens26-Mar-09 22:20
SeMartens26-Mar-09 22:20 
Question[Message Deleted] Pin
Kiran S. S.26-Mar-09 1:42
Kiran S. S.26-Mar-09 1:42 
AnswerRe: Calling stored procedure from ASP page. Pin
Yusuf26-Mar-09 4:33
Yusuf26-Mar-09 4:33 
Questionthe webdesign Pin
shareef22200025-Mar-09 23:29
shareef22200025-Mar-09 23:29 
AnswerRe: the webdesign Pin
Marc Firth26-Mar-09 2:05
Marc Firth26-Mar-09 2:05 
QuestionThis Virtual Directory Does Not Allow Contents To Be Listed Pin
Hemant Thaker25-Mar-09 19:15
Hemant Thaker25-Mar-09 19:15 
AnswerRe: This Virtual Directory Does Not Allow Contents To Be Listed Pin
Naruki25-Mar-09 19:38
Naruki25-Mar-09 19:38 
GeneralRe: This Virtual Directory Does Not Allow Contents To Be Listed Pin
Hemant Thaker25-Mar-09 20:09
Hemant Thaker25-Mar-09 20:09 

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.