The program that reads the output file wants the tilde as a delimiter and
double-quote as the text qualifier..(dont ask - Italian programmer).
I know that portion works fine and perhaps I will go back to escaping the
double quotes. I used to do it that way but for some reason switched to the
SET method, probably just being lazy.
My problem is still setting the NewQty to 0 when POSTED = GW
Adrian
-----Original Message-----
From: Jann VanOver [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 28, 2000 1:45 PM
To: CF-Talk
Subject: RE: cfloop headache
The CFSET statement,
<cfset txtoutput = '"#BillNo#"~"#NewQty#"'>
looks "funny". What's with the tilde between the quoted strings? Did you
mean:
<cfset txtoutput = "#BillNo#~#NewCity#">
??
Try "printing" the txtoutput values without the CFFILE and see what you are
getting here.
> -----Original Message-----
> From: Adrian Cesana [SMTP:[EMAIL PROTECTED]]
>
> 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.
>
>
> <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.
