Hi Bruce,
Try this:
<cfif qGetVenue1.RecordCount EQ 1>
qGetVenue1
<cfelseif qGetVenue2.RecordCount EQ 1>
qGetVenue2
</cfif>
If the result outputs either 'qGetVenue1' or 'qGetVenue2' then the if/esleif statement
is working as it should, and the problem is in the actual code within.
Also, if it is working in your development environment but not your production
environment, then there is a difference between the two that needs to be found and
fixed.
Hope this helps,
Seth
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce
Sorge
Sent: Tuesday, October 30, 2001 10:35 PM
To: [EMAIL PROTECTED]
Subject: CFIF Issue
OK,
I know that this is beginner stuff, but I am having the most difficult time with this
CFIF statement;
<cfif qGetVenue1.RecordCount EQ "1">
bla bla bla
<cfelseif qGetVenue2.RecordCount EQ "1">
bla bla bla
</cfif>
When I do this:
<cfoutput>
MM Code 1: #qGetVenue1.RecordCount#<BR>
MM Code 2: #qGetVenue2.RecordCount#<BR>
</cfoutput>
then I get a recordcount on one or the other, depending on which evaluates true.
However, the code that is in between them is NOT processing. It is as if they are
being skipped. The real catch is that in my development environment, this works great.
It is in the live environment that it is not working. The test enviroinment is Windows
2K and CF5.0, and so is the test. I am baffled and tired.
Thanks,
Bruce
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
