I have a page that calls categories for the headings
'calls the cats for the page heading
set rs1 = My_Conn.Execute("SELECT * from tbl_cats where CatID = " & Request.QueryString("CatID"))
strCatID = RS1("CatID")
So far so good and the page works.
Later on I want to set up what to do, depending on the catID
<% 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 :)