Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: "Exception Occured" Error


Message #1 by "Judy Sese" <jmss66@y...> on Thu, 8 Aug 2002 22:11:24
I encountered this error message while checking a field.

Exception occurred. 
/hfrrf/hfpension/BrowseListings.asp, line 114

The code is

<b>

<TD><A HREF="Register.asp?Update=True">Edit Registration Info</A></TD><BR>
<TD><A HREF="Download.asp">Download Forms</A></TD><BR>
<% If  rsMemInfo("Status") <> "R" Then %>
	<TD><A HREF="Calculator.htm">Calculator</A></TD><BR>
<% End If %>
<TD><A HREF="Login.asp">Exit</A></TD>	
	
</b>	
rsMemInfo.Close
Set rsMemInfo = Nothing

Can someone please help me resolve this problem.

Thanks,
Judy 
Message #2 by "Peter Foti (PeterF)" <PeterF@S...> on Thu, 8 Aug 2002 17:20:29 -0400
Which line is 114?

Also, in the code you posted below, the last 2 lines should be enclosed in
ASP tags <% %>, should they not?

-Pete

-----Original Message-----
From: Judy Sese [mailto:jmss66@y...]
Sent: Thursday, August 08, 2002 10:11 PM
To: ASP Databases
Subject: [asp_databases] "Exception Occured" Error


I encountered this error message while checking a field.

Exception occurred. 
/hfrrf/hfpension/BrowseListings.asp, line 114

The code is

<b>

<TD><A HREF="Register.asp?Update=True">Edit Registration Info</A></TD><BR>
<TD><A HREF="Download.asp">Download Forms</A></TD><BR>
<% If  rsMemInfo("Status") <> "R" Then %>
	<TD><A HREF="Calculator.htm">Calculator</A></TD><BR>
<% End If %>
<TD><A HREF="Login.asp">Exit</A></TD>	
	
</b>	
rsMemInfo.Close
Set rsMemInfo = Nothing

Can someone please help me resolve this problem.

Thanks,
Judy 
Message #3 by "Judy Sese" <jmss66@y...> on Fri, 9 Aug 2002 13:54:14
Line 114 is  

<% If  rsMemInfo("Status") <> "R" Then %>

and yes the last two lines were suppose to be enclosed in script tags 
thanks.

> Which line is 114?

Also, in the code you posted below, the last 2 lines should be enclosed in
ASP tags <% %>, should they not?

-Pete

-----Original Message-----
From: Judy Sese [mailto:jmss66@y...]
Sent: Thursday, August 08, 2002 10:11 PM
To: ASP Databases
Subject: [asp_databases] "Exception Occured" Error


I encountered this error message while checking a field.

Exception occurred. 
/hfrrf/hfpension/BrowseListings.asp, line 114

The code is

<b>

<TD><A HREF="Register.asp?Update=True">Edit Registration Info</A></TD><BR>
<TD><A HREF="Download.asp">Download Forms</A></TD><BR>
<% If  rsMemInfo("Status") <> "R" Then %>
	<TD><A HREF="Calculator.htm">Calculator</A></TD><BR>
<% End If %>
<TD><A HREF="Login.asp">Exit</A></TD>	
	
</b>	
rsMemInfo.Close
Set rsMemInfo = Nothing

Can someone please help me resolve this problem.

Thanks,
Judy 
Message #4 by "Peter Foti (PeterF)" <PeterF@S...> on Fri, 9 Aug 2002 10:49:35 -0400
Sorry, I don't know what the problem is.  Perhaps try doing:
 Response.Write(rsMemInfo("Status")
before your If...Then statement, to see if this actually has a value.  Is it
possible that this might contain a null value?

Regards,
Peter

> -----Original Message-----
> From: Judy Sese [mailto:jmss66@y...]
> Sent: Friday, August 09, 2002 1:54 PM
> To: ASP Databases
> Subject: [asp_databases] RE: "Exception Occured" Error
> 
> 
> Line 114 is  
> 
> <% If  rsMemInfo("Status") <> "R" Then %>
> 
> and yes the last two lines were suppose to be enclosed in script tags 
> thanks.
> 
> > Which line is 114?
> 
> Also, in the code you posted below, the last 2 lines should 
> be enclosed in
> ASP tags <% %>, should they not?
> 
> -Pete
> 
> -----Original Message-----
> From: Judy Sese [mailto:jmss66@y...]
> Sent: Thursday, August 08, 2002 10:11 PM
> To: ASP Databases
> Subject: [asp_databases] "Exception Occured" Error
> 
> 
> I encountered this error message while checking a field.
> 
> Exception occurred. 
> /hfrrf/hfpension/BrowseListings.asp, line 114
> 
> The code is
> 
> <b>
> 
> <TD><A HREF="Register.asp?Update=True">Edit Registration 
> Info</A></TD><BR>
> <TD><A HREF="Download.asp">Download Forms</A></TD><BR>
> <% If  rsMemInfo("Status") <> "R" Then %>
> 	<TD><A HREF="Calculator.htm">Calculator</A></TD><BR>
> <% End If %>
> <TD><A HREF="Login.asp">Exit</A></TD>	
> 	
> </b>	
> rsMemInfo.Close
> Set rsMemInfo = Nothing
> 
> Can someone please help me resolve this problem.
> 
> Thanks,
> Judy 
> 
Message #5 by "Judy Sese" <jmss66@y...> on Fri, 9 Aug 2002 18:51:24
Hi Peter,
 I got it to work. Thanks for your help.

Regards, 
Judy

> Sorry, I don't know what the problem is.  Perhaps try doing:
 Response.Write(rsMemInfo("Status")
before your If...Then statement, to see if this actually has a value.  Is 
it
possible that this might contain a null value?

Regards,
Peter

> -----Original Message-----
> From: Judy Sese [mailto:jmss66@y...]
> Sent: Friday, August 09, 2002 1:54 PM
> To: ASP Databases
> Subject: [asp_databases] RE: "Exception Occured" Error
> 
> 
> Line 114 is  
> 
> <% If  rsMemInfo("Status") <> "R" Then %>
> 
> and yes the last two lines were suppose to be enclosed in script tags 
> thanks.
> 
> > Which line is 114?
> 
> Also, in the code you posted below, the last 2 lines should 
> be enclosed in
> ASP tags <% %>, should they not?
> 
> -Pete
> 
> -----Original Message-----
> From: Judy Sese [mailto:jmss66@y...]
> Sent: Thursday, August 08, 2002 10:11 PM
> To: ASP Databases
> Subject: [asp_databases] "Exception Occured" Error
> 
> 
> I encountered this error message while checking a field.
> 
> Exception occurred. 
> /hfrrf/hfpension/BrowseListings.asp, line 114
> 
> The code is
> 
> <b>
> 
> <TD><A HREF="Register.asp?Update=True">Edit Registration 
> Info</A></TD><BR>
> <TD><A HREF="Download.asp">Download Forms</A></TD><BR>
> <% If  rsMemInfo("Status") <> "R" Then %>
> 	<TD><A HREF="Calculator.htm">Calculator</A></TD><BR>
> <% End If %>
> <TD><A HREF="Login.asp">Exit</A></TD>	
> 	
> </b>	
> rsMemInfo.Close
> Set rsMemInfo = Nothing
> 
> Can someone please help me resolve this problem.
> 
> Thanks,
> Judy 
> 

  Return to Index