Solved

Display region IF

Posted on 2013-06-22
2
317 Views
Last Modified: 2013-06-22
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
Comment
Question by:amucinobluedot
2 Comments
 

Author Comment

by:amucinobluedot
ID: 39268114
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
 
LVL 52

Accepted Solution

by:
Scott Fell,  EE MVE earned 500 total points
ID: 39268127
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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
This video teaches users how to migrate an existing Wordpress website to a new domain.
The viewer will learn how to dynamically set the form action using jQuery.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now