2 Replies Latest reply: Apr 25, 2012 1:10 AM by BKBK RSS

    Help With Simple CFIF question please

    whistlerwebandprint

          I am trying to check the contents of 2 form elements against existing database enties and then if either of them are differnet run a conditional option but I am having some issues as the below does not seem to be working. Am I doing something wrong?

       

       

      <cfquery name="qLiveService" datasource="#application.datasource#">

              SELECT broadcastPackage, AdditonalDVDs

              FROM dbo.tributes

              WHERE profileID = 122>

          </cfquery>  

          

             

      <cfif qLiveService.broadcastPackage is form.broadcastPackage and qLiveService.AdditonalDVDs is form.AdditonalDVDs >

       

      <!--- do something -->

       

      <cfelse>

       

      <!--- of one was different now run the code in this area -->

      </cfif>