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:
<CFLOOP NAME="Query1">
<CFLOOP NAME="Query2">
<CFIF Compare(Query1.name, Query1.name) is 0>
<br>A match found!!!<br>
</CFIF>
</CFLOOP>
</CFLOOP>
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?
Thanks.
Jun
Glad it worked for ya..i hate it when a web server doesn't use the page I just uploaded...darn caching..