Adobe Community: Message List - compare values

Re: compare values

forums_noreply@adobe.com — Thu, 06 Nov 2014 13:31:37 GMT

Hi,

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

<br />

#myquery.status#

#myquery.status#

</cfif>

</cfoutput>

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

forums_noreply@adobe.com — Sat, 01 Nov 2014 11:33:57 GMT

</cfif>

</cfoutput>

</cfif>

forums_noreply@adobe.com — Mon, 27 Oct 2014 19:55:46 GMT

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

A query object is really an array.

<cfif>

HTH,

^_^

forums_noreply@adobe.com — Tue, 21 Oct 2014 16:35:50 GMT

Hi,

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

Status

------

yes

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>