I got it figured out. The CFIF statements were working all along. What happened was, the table where I was querying for the first record, some di*k head decided that it would be cute to enter a null value into the table. So what I was doing was querying for the top 1* of the table, then updating another table field with the null value, which is why I was not seeing what I was expecting. This will teach me to look at tables others upload for me before querying them.
-----Original Message----- From: Seth Bienek [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 31, 2001 8:59 AM To: [EMAIL PROTECTED] Subject: RE: CFIF Issue 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 ------------------------------------------------------------------------- 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
