Highlighted

compare values

New Here ,
Oct 21, 2014

Copy link to clipboard

Copied

Hi,

I have the query with out put below for one field as an example

Status

------

yes

yes

yes

no

i want to be able to do the compare for ALL status in one field but don't know how to do it, Can anyone plz help? Thanks

<cfif all status = "yes" ---> display  Yes

<cfelseif all status = No -- display No

<cfelse> Other

</cfif>

TOPICS
Getting started

Views

329

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

compare values

New Here ,
Oct 21, 2014

Copy link to clipboard

Copied

Hi,

I have the query with out put below for one field as an example

Status

------

yes

yes

yes

no

i want to be able to do the compare for ALL status in one field but don't know how to do it, Can anyone plz help? Thanks

<cfif all status = "yes" ---> display  Yes

<cfelseif all status = No -- display No

<cfelse> Other

</cfif>

TOPICS
Getting started

Views

330

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Oct 21, 2014 0
LEGEND ,
Oct 27, 2014

Copy link to clipboard

Copied

Let's say the query name is "qry" and the column name is "booln".

A query object is really an array.

<cfset display = "">

<cfif ArrayFindNoCase(qry.booln,"no") AND NOT ArrayFindNoCase(qry.booln,"yes")>

  <cfset display = "no">

<cfelseif ArrayFindNoCase(qry.booln,"yes") AND NOT ArrayFindNoCase(qry.booln,"no")>

  <cfset display = "yes">

<cfelse>

  <cfset display = "both">

<cfif>

HTH,

^_^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Oct 27, 2014 0
Adobe Community Professional ,
Nov 01, 2014

Copy link to clipboard

Copied

<cfset numberOfYeses = 0>

<cfoutput query="myQuery">

    <cfif status EQ "yes">

        <cfset numberOfYeses = numberOfYeses + 1>

    </cfif>

</cfoutput>

<cfif numberOfYeses EQ myQuery.recordCount>

    <!--- Then there were all Yeses --->

<cfelseif numberOfYeses EQ 0>

    <!--- Then there were all Nos --->

<cfelse>

    <!--- Then there were Yeses and Nos --->

</cfif>

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 01, 2014 0
New Here ,
Nov 06, 2014

Copy link to clipboard

Copied

Hi,

If your query name is "myquery" and the status column name is "status" then you can check like below:

           <cfoutput query="myquery">          

            <br />

                <cfif #myquery.status# eq "yes">

                     #myquery.status#

                <cfelse>

                      #myquery.status#

                </cfif>               

           </cfoutput>

If you want same status continuously then you can use order by in your query.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Nov 06, 2014 0