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

    Help With Simple CFIF question please


          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>




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


      <!--- do something -->




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