Hello Experts:Im using the following code to pass the problemstatusID to to the next page so I can use this information:
<%Response.Write("Edit")%> | And using the following code to extract the information:ProblemStatusID=Request.QueryString("ProblemStatusID")Whenever I click on the Edit button I am getting error message"Microsoft OLE DB Provider for SQL Server error '80040e10' Procedure or function 'GetInformationForProblemStatusId' expects parameter '@problemStatusId', which was not supplied. /helpdesk/test/problemdetails.asp, line 32 " This question is,I am not sure why I am getting this error message Can anybody help me regarding this issue or anybody has any other idea to the form using this technique?ThanksSANHere is the code and the stored procedure I am usingALTER Proc [dbo].[GetAllOpenProblems]As Select a.ProblemStatusId,a.ProblemStatus,b.TeamMemberName,c.problemTitle,e.DepartmentN
ame From (((ProblemsUsersDeptsReps dInner Join Departments eon d.DepartmentID = e.DepartmentID)Inner Join Problems con d.ProblemID = c.ProblemID)Inner Join ProblemStatus aon d.ProblemsUsersDeptsRepsID = a.ProblemsUsersDeptsRepsID)Inner Join TeamMembers b on a.TeamMemberId = b.TeamMemberId Where UPPER(a.ProblemStatus) = 'OPEN'_________________________________________________________<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> ! <%Dim strSQL, result' Set SQL statementstrSQL = "GetAllOpenProblems"'Execute teh SQL and obtain resultsetSet result = objconn.Execute(strsql)'Check for ErrorsIf objconn.Errors.Count > 0 thenResponse.Write("Error Occurred:
")Else%> <%Response.Write("The following Tickets are opened today")%>
<%Response.Write("Problem ID")%> | <%Response.Write("Team Member Name")%> | <%Response.Write("Subject")%> | <%Response.Write("Component")%> | <%Response.Write("Status of the Problem")%> | <%Response.write("Edit")%> |
<%Do Until result.EOF%><%Response.write(" " & result("ProblemStatusID") & " ")%> | <%Response.write(" " & result("TeamMemberName") & " ")%> | <%Response.write(" " & result("ProblemTitle") & " ")%> | <%Response.write(" " & result("DepartmentName") & " ")%> | <%Response.write(" " & result("ProblemStatus") & " ")%> | <%ProblemStatusID=Request.QueryString("ProblemStatusID") %><%Response.Write("Edit")%> |
<%result.MoveNextloopEnd If'Close Database'objconn.Close%>
-------------------------------------------------------<%@ LANGUAGE="VBScript" %><% Option Explicit 'Buffer the response, so Response.Expires can be used Response.Buffer = TRUE%> !
|
DetailsforProblem |
ProblemID: | <%Response.write(" " & result("ProblemStatusID") & " ")%> | UserName | <%Response.write(" " & result("UserName") & " ")%> | EMail: | <%Response.write(" " & result("Email") & " ")%> | Location: | <%Response.write(" " & result("Location") & " ")%> | Phone | <%Response.write(" " & result("Phone") & " ")%> | Component: | <%Response.write(" " & result("DepartmentName") & " ")%> | NH | <%Response.write(" " & result("NH") & " ")%> | SSN: | <%Response.write(" " & result("SSN") & " ")%> | IsRepresentativeInvolved: | <%Response.write(" " & result("IsRepresentativeInvolved") & " ")%> | RepresentativeSSN: | <%Response.write(" " & result("RepresentativeSSN") & " ")%> | RepresentativeZipCode: | <%Response.write(" " & result("RepresentativeZipCode") & " ")%> | OrganizationName: | <%Response.write(" " & result("OrganizationName") & " ")%> | IsProblemQuestion: | <%Response.write(" " & result("IsProblemQuestion") & " ")%> | IsComment: | <%Response.write(" " & result("IsComment") & " ")%> | ProblemTitle: | <%Response.write(" " & result("ProblemTitle") & " ")%> | ProblemTitle: | <%Response.write(" " & result("ProblemDescription") & " ")%> | Attachment: | <%Response.write(" " & result("Attachment") & " ")%> | StartDate: | start_date | CloseDate: | close_date | "Solution": | "solution" |
TEXT
Uploading file and scanning for virus... Please Wait
About QuomonQuomon is a network of IT professionals from around the world, collaborating by sharing knowledgeable answers in their specific field of expertise.
Ask your question here
Please wait...
|