exception occurred

[amisima]

Hi,

I am getting this error.

Error Type:
(0x80020009)
Exception occurred

I am using Oracle8. I am getting this error when I try do display a date on my asp page. Here is the code that I am getting the error with.

<%if InStr(ucase(rsf(&quot;create_dt&quot),ucase(search_criteria)) <> 0 then %>
<td valign=&quot;top&quot;>{Date Created & N}</td>
<%
pos=InStr(Ucase(rsf(&quot;create_dt&quot),Ucase(search_criteria))
chunk=Mid(rsf(&quot;create_dt&quot,pos,Len(search_criteria))
pos2=pos+len(chunk)
pos3=len(rsf(&quot;create_dt&quot)
string1=mid(rsf(&quot;create_dt&quot,1,pos-1)
string2=mid(rsf(&quot;create_dt&quot,pos2,pos3)
MyHighlight=string1 & &quot;<SPAN STYLE=background:#FFFF00>&quot;& chunk &&quot;</SPAN>&quot; & string2%>
<td><%Response.Write (MyHighlight)%></td>
<%else
if rsf(&quot;create_dt&quot <> empty then
%>
<td valign=&quot;top&quot;>{Date Created & N}</td>
<td valign=&quot;top&quot;><%response.write(rsf(&quot;create_dt&quot)%><%response.write(&quot; &quot
end if
end if%>

The error occurs in the first line of the code. Can anyone help?

Thanks,

Amisima

 

[GaryC123]

Probably because theres nothing in the recordset, are you checking first

If Not(rs.eof or rs.bof) then
' ok we got records
else
' oops somethings gone wrong
end if

http://www.intouchmedialtd.com