May 13th, 2008, 07:30 AM
|
|
Contributing User
|
|
Join Date: Dec 2004
Posts: 416
Time spent in forums: 5 Days 2 h 5 m 49 sec
Reputation Power: 6
|
|
|
Recordset error "Exception occurred."
Hi All,
IM trying to display some information if the recordet contains 1 or more records but am recieving the following error
Code:
Exception occurred.
Here is my code
Code:
RequestID=Request.Form("REF")
SQLQuery ="SELECT contact FROM caselist WHERE CaseID="
& RequestID & ""
SET rscontact = objConnection.Execute(SQLQuery)
SQLQuery ="SELECT username, MNGR_ID, COUNT(MNGR_ID) AS TEST FROM employee WHERE username LIKE '%" & rscontact("Contact") & "%' GROUP BY username, mngr_id"
SET rsusername = objConn.Execute(SQLQuery)
IF rsusername("TEST") <> 0 THEN
SQLQuery ="SELECT * FROM employee WHERE user_id = '" & rsusername("mngr_id") & "' "
SET rsmanagerid = objConn.Execute(SQLQuery)
SQLQuery ="SELECT * FROM employee WHERE user_id = '" & rsmanagerid("mngr_id") & "' "
SET rsmanagerid2 = objConn.Execute(SQLQuery) %>
<TD BGCOLOR="#f7fbae">
<FONT FACE="VERDANA" SIZE=2><B>DOAG: </B>
<SELECT NAME="PURCHASE" VALUE="" style= visibility:hidden>
<%IF rsusername("ProcessOrder") = 1 THEN%>
<OPTION VALUE = "<%=rsusername("username")%>"><%=rsusername("username")%></OPTION>
<%ELSE IF rsmanagerid("ProcessOrder") = 1 THEN%>
<OPTION VALUE = "<%=rsmanagerid("username")%>"><%=rsmanagerid("username")%></OPTION>
<%ELSE IF rsmanagerid2("ProcessOrder") = 1 THEN%>
<OPTION VALUE = "<%=rsmanagerid2("username")%>"><%=rsmanagerid2("username")%></OPTION>
<%END IF%>
<%END IF%>
<%END IF%>
the rsusername recordset is where the issue is. There is currently no reocrds in this reocordset and im trying to complete and if statment based of it (where i think the issue is)
Any help would be great
thanks
Last edited by djfubar : May 13th, 2008 at 07:34 AM.
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
