Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 334
  • 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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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