Funny Stuff Respectfully,
<cf_developer> Phillip B. Holmes Media Resolutions Inc. Premier Allaire Alliance Partner http://www.mediares.com [EMAIL PROTECTED] 1-888-395-4678 ext. 101 972-889-0201 ext. 101 </cf_developer> Please send support requests to [EMAIL PROTECTED] ----- Original Message ----- From: "Sorge, Bruce" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 31, 2001 8:45 AM Subject: RE: CFIF Issue > 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 > ------------------------------------------------------------------------- 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
