error '80020009' Exception occurred.

hauruapai · April 9th, 2006, 09:34 PM

Hi all,

I have a page that calls categories for the headings

Code:

<% 
'calls the cats for the page heading
set rs1 = My_Conn.Execute("SELECT * from tbl_cats where CatID = " & Request.QueryString("CatID"))
strCatID =  RS1("CatID")
'response.write strCatID
%>

So far so good and the page works.

Later on I want to set up what to do, depending on the catID

Code:

<% if rs1("CatID") = strCatID  then %>
Fill in the form below
<% end if %>

However, this causes the above error.

I have also tried
<% if rs1("CatID") = 4 then %> AND
<% if rs1("CatID") <> 4 then %> AND just to see if it will work
<% if rs1("CatID") < 4 then %>
but still get the same error.

Any guidence will be much appreciated - thank you for your time :)

mat41 · April 9th, 2006, 09:48 PM

;;;However, this causes the above error
What error? I can not see a error, am I missing something??

is the record set empty? try:

<% if not rs1.Eof then
      if (rs1("CatID") = strCatID) then %>
         //Fill in the form below
      end if
<% else %>
      response.write "no records found
<% en if %>

FYI: are they integers you are comparing? if so use the cInt function around them

Wind is your friend
Matt

hauruapai · April 10th, 2006, 05:05 PM

Thank you for your reply mat41. The error message was
error '80020009' Exception occurred
which I had put as the title to the post, but next time I will add it into the post as well - forgive me for that but I will learn how to post correctly as I go along :)

And Your code example has helped me to see what is happening, so I can get it fixed now :-)

thank you for your time - it is appreciated :-)