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