Try trimming the Posted field, in case you have any spaces in there.
<cfif trim(posted) IS "GW">
Sharon
At 10:48 AM 9/28/2000 -0700, Adrian Cesana wrote:
>What am I doing wrong here...I am trying to evaluate a field and change the
>outoput based on this. I know I have a few records that meet the <cfif
>get.posted IS "GW"> test but they dont get SET to 0 as if the test failed.
>It appears I am not evaluating on the correct record. Do I need to set a
>field from the query to a list then loop thru the list perhaps? Seems like
>I should be able to do it like this somehow...
>
>Thanks,Adrian
>
>
>Ive slimmed the query and output down to make it simple:
>
>
><CFQUERY NAME="get" DATASOURCE="blah">
>SELECT billno,posted,qty FROM blah WHERE blah
></CFQUERY>
>
><cfloop query="get">
>
><cfif posted IS "GW"> <!--- tried get.posted - same result --->
><cfset NewQty = 0>
><cfelse>
><cfset NewQty = qty>
></cfif>
>
><cfset txtoutput = '"#BillNo#"~"#NewQty#"'>
><cffile action=append file="blah" output="#txtoutput#">
>
></cfloop>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
