Thanks for the response but I got my problem fixed. I had made some syntax errors. The ODS_CGuser is actually the variable name for the connection object. Thanks again!!
> What is the type of "ODS_CGuser" object ..? > > > > > Kuminda Chandimith > Sr. Technical Consultant > Ducont.com FZ-LLC > Tel: + 971-4-3913000 Ext 237 > Fax: +971-4-3913001 > http://www.ducont.com > > > > -----Original Message----- > From: msavoy [mailto:[EMAIL PROTECTED]] > Sent: 15 October 2002 18:00 > To: ActiveServerPages > Subject: Error Handling script question > > > I found an example of error handling within ASP when a SQL DB error occurs > however, I am getting the following error: > > ADODB.Connection error '800a0cc1' > > Item cannot be found in the collection corresponding to the requested name > or ordinal. > > /common/errorhandle.asp, line 525 = > (<%=ODS_CGuser.errors(counter).number%>) > > My code where I am trying to print out this info is as follows: > > <% If (ODS_CGuser.errors.count) > 0 Then %> > > <% For counter = 0 to ODS_CGuser.errors.count %> > <tr> > <td width="10"> </td> > <td nowrap align="left" valign="top"><font face="arial" size="2"><b>DB(ODS) > Error Number:</b></font></td> > <td colspan="5"> </td> > <td align="left" valign="top" name="odserrornumber"><font face="arial" > size="2"><%=ODS_CGuser.errors(counter).number%></font></td> > </tr> > <tr> > <td width="10"> </td> > <td nowrap align="left" valign="top"><font face="arial" size="2"><b>DB(ODS) > Error Descr.:</b></font></td> > <td colspan="5"> </td> > <td align="left" valign="top" name="odserrordescription"><font face="arial" > size="2"><%=ODS_CGuser.errors(counter).description%></font></td> > </tr> > <tr> > <td width="10"> </td> > <td nowrap align="left" valign="top"><font face="arial" size="2"><b>DB(ODS) > Error Source:</b></font></td> > <td colspan="5"> </td> > <td align="left" valign="top" name="odserrorsource"><font face="arial" > size="2"><%=ODS_CGuser.errors(counter).source%></font></td> > </tr> > <% Next %> > > <% End If %> > > Any suggestions or direction would be appreciated. Thank you!! > > --- > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
