Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.
Course Of The Month
3 days, 16 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
How to compare two variables in different scope dynamically?
Posted on 2000-04-18
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3-
3
7 Comments
Try not using the query identifier in front of the variable..when you do, that only gives you the first record of the query..
<CFLOOP QUERY="Query1">
<CFSET somevar = name>
<CFLOOP QUERY="Query2">
<CFIF Compare(somevar, name) is 0>
<br>A match found!!!<br>
</CFIF>
</CFLOOP>
</CFLOOP>
<CFLOOP QUERY="Query1">
<CFSET somevar = name>
<CFLOOP QUERY="Query2">
<CFIF Compare(somevar, name) is 0>
<br>A match found!!!<br>
</CFIF>
</CFLOOP>
</CFLOOP>
Thanks for your help.
I tried the similare way, and print out somevar in outer loop and in inner loop, like this:
<CFLOOP QUERY="Query1">
<CFSET somevar = name>
<br>1. #somevar# <br>
<CFLOOP QUERY="Query2">
<br>2. #somevar# <br>
<CFIF Compare(somevar, name) is 0>
<br>A match found!!!<br> </CFIF>
</CFLOOP>
</CFLOOP>
1. is correct, but 2. remains the same.
I tried the similare way, and print out somevar in outer loop and in inner loop, like this:
<CFLOOP QUERY="Query1">
<CFSET somevar = name>
<br>1. #somevar# <br>
<CFLOOP QUERY="Query2">
<br>2. #somevar# <br>
<CFIF Compare(somevar, name) is 0>
<br>A match found!!!<br> </CFIF>
</CFLOOP>
</CFLOOP>
1. is correct, but 2. remains the same.
2 would remain the same inside that second loop..your code should print:
1.a
2.a
a match is found!
2.a
2.a
2.a
1.b
2.b
2.b
a match is found!
2.b
2.b
etc..what output are you trying to get?
i'll test it on a server when i get a chance..
1.a
2.a
a match is found!
2.a
2.a
2.a
1.b
2.b
2.b
a match is found!
2.b
2.b
etc..what output are you trying to get?
i'll test it on a server when i get a chance..
Thanks lot!
I retest it and get the right answer. Last time I got a incorrect result may be because some thing wrong with my account. Each time I need to ftp my programm into there.
Thanks again.
I retest it and get the right answer. Last time I got a incorrect result may be because some thing wrong with my account. Each time I need to ftp my programm into there.
Thanks again.
If it works GRADE him.... Give him a 'A'
Nathan Stanford
Mr. ColdFusion
www.nsnd.com
ColdFusion Tips Plus
Nathan Stanford
Mr. ColdFusion
www.nsnd.com
ColdFusion Tips Plus
Featured Post
You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.
With xMatters, you'll never miss a beat.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This is a guide to setting up a new WHM/cPanel Server to be used for web hosting accounts. It is intended for web hosting company administrators and dedicated server owners. For under $99 per month (considering normal rate of Big Data Cetnters like …
Introduction
This article explores the design of a cache system that can improve the performance of a web site or web application. The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
If you're a developer or IT admin, you’re probably tasked with managing multiple websites, servers, applications, and levels of security on a daily basis. While this can be extremely time consuming, it can also be frustrating when systems aren't wor…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses
Course of the Month3 days, 16 hours left to enroll
691 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.