• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

Display region IF

I need to modify the following statement:

<% If Qnrpg1.EOF And Qnrpg1.BOF Then %>

-- REGION --

<% End If >

The above shows a region IF a recordset is empty (Using dreamweaver). I need to add another condition, it has to be IF its empty OR (if it is NOT empty AND the value of the field is = 1)

The recordset name is : 'Qnrpg1'
The field name is:  'email'

What would the syntax be ?
0
Aleks
Asked:
Aleks
1 Solution
 
AleksAuthor Commented:
I tried this but I get a syntax error:

<% If (Qnrpg1.EOF And Qnrpg1.BOF) OR (Qnrpg1.EOF Or Not Qnrpg1.BOF AND Qnrpg1.sex = 1)  Then %>
0
 
Scott Fell, EE MVEDeveloper & EE ModeratorCommented:
If not Qnrpg1.eof or not Qnrpg1.bof then
     if cstr(Qnrpg1("sex"))="1" then
         'show some code
     end if
end if

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now