Solved

Display region IF

Posted on 2013-06-22
2
321 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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmakerā€¦
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

830 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