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
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 -->
The term "does not seem to be working" is vague. What do expect to happen and what is actually happening?
Your code seems to be all right. Just remove the symbol > from your SQL statement