I want to compare two query variables like this:
Query1 has a name fild with values a, b, c, d.
Query2 is a subset of Quer1. It also has a name fild with values a, or b, or c, or d, or any combination of them.
I tried the following code:
<CFIF Compare(Query1.name, Query1.name) is 0>
<br>A match found!!!<br>
My problem is that Query1.name in the comparation statement is still a, it never changed to b, c, d. I tried to use Evaluate function, but it helpless.
Could You help me?