%@Language=VBScript%> <% varEventID = Request.QueryString("ID") Set oRS=Server.CreateObject("ADODB.recordset") Set objCmd=Server.CreateObject("ADODB.Command") Set objCmd.ActiveConnection = objConn objCmd.CommandText = "sp_GetEventInfo" objCmd.CommandType = adCmdStoredProc set parm1= objCmd.CreateParameter("RETURN_VALUE", adInteger, adParamReturnValue) objCmd.Parameters.Append parm1 set parm2= objCmd.CreateParameter("@ClientID", adVarChar, adParamInput,10 ,varClientID) objCmd.Parameters.Append parm2 set parm3= objCmd.CreateParameter("@EventID", adVarchar, adParamInput,20,varEventID) objCmd.Parameters.Append parm3 set oRS = objCmd.Execute varSubject = ORS("EventName") %>
<%
varEventDesc = oRS("EventDesc")
varEventURLAddress = oRS("MoreInfoURL")
Call CheckForErrors(objConn)
'Check for errors
if objconn.Errors.Count > 0 then
set objErr = Server.CreateObject("ADODB.RecordSet")
For Each objErr In objConn.Errors
if objErr.Number <> 0 Then
Response.Write " System Error Description: " & objErr.Description & " "
Response.Write " Please feel free to contact us if you have any questions. "
Response.Write "" & vargTechSuptEmail & ""
blnCriticalError = True
end if
Next
Set objErr = Nothing
if blncriticalError Then
Response.End
end if
objErr.Close
set objErr = Nothing
end if
%>
|