RE: CFIF Issue

Sorge, Bruce Wed, 31 Oct 2001 05:54:57 -0800

Did all that. Also tried the CompareNoCase. This is so strange that in two similar environments, the code works in one place and not the other.

-----Original Message-----
From: Dan Blackman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 11:31 PM
To: [EMAIL PROTECTED]
Subject: RE: CFIF Issue

Have you tried to take the quotes off? Just a random thought. I know CF is typeless, but it's worth a shot.

The only other thing I can think of is using

<cfelseif not CompareNoCase(qGetVenue2.RecordCount, "1")

</cfif>

You could probably do a Compare vs. a CompareNoCase...Just habit for me. If that doesn't equate, then I would have to have more info....

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bruce Sorge
Sent: Tuesday, October 30, 2001 11:23 PM
To: [EMAIL PROTECTED]
Subject: RE: CFIF Issue

The typo was on my in this message. I assure you it is spelled correctly in the code, otherwise I would have received an error. Like I said, I am tired. What I am doing is, if the first query returns only one recordcount, then run a couple of select, update and delete queries, otherwise if the second query returns only one recordcount, then run some other queries. The cfoutput was just for me to see if any of the queries worked and returned a recordcount, and one or the other does depending on the circumstances. This leads me to believe that the cfif statements are not working properly, even though I know that I have them entered in correctly.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dan Blackman
Sent: Tuesday, October 30, 2001 11:14 PM
To: [EMAIL PROTECTED]
Subject: RE: CFIF Issue

Not sure what you are trying to accomplish? Are you trying to affirm that there is a recordcount or that the recordcount is equal to 1!?

Also, the cfelseif statement is misspelled.

-----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

RE: CFIF Issue

Reply via email to