RE: Why doe my cfscript if statement fail?

2001-01-23 Thread Mike Townend
try just putting CFSCRIPT if (Check_NT.RecordCount gt 0) .. HTH Mike -Original Message- From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]] Sent: Monday, January 22, 2001 17:10 To: CF-Talk Subject: Why doe my cfscript if statement fail? Hi There, I'm trying to

RE: Why doe my cfscript if statement fail?

2001-01-22 Thread Dan G. Switzer, II
Kevin, I'm actually surprised that CF doesn't throw an error with the statement. Get rid of the "is 'TRUE'" portion: if( Check_NT.RecordCount GT 0 ){ } (You can shortcut this further to just "if( Check_NT.RecordCount ){" Also, I don't notice any brackets around your IF statement, which means

RE: Why doe my cfscript if statement fail?

2001-01-22 Thread Sean Daniels
if (Check_NT.RecordCount gt 0 is "TRUE") I don't know if this is the problem, but I would definitely not write that condition that way. I would use either: 1. if (check_NT.recordcount gt 0) or 2. if (check_NT.recordcount) Both will achieve the result I assume you are looking for. -

RE: Why doe my cfscript if statement fail?

2001-01-22 Thread Dave Watts
I'm trying to find why this if condition keeps getting evaluated as true when it shouldn't. ... if (Check_NT.RecordCount gt 0 is "TRUE") You've got two conditions, not one. You can just use one condition: if (Check_NT.RecordCount gt 0) Or, you can simply reference the variable - a nonzero

Re: Why doe my cfscript if statement fail?

2001-01-22 Thread David E. Crawford
just use cfscript if (check_nt.recordcount GT 0) . /cfscript There is no need to add the "is 'TRUE'" clause, which is what is causing the statement to fail. DC - Original Message - From: "Kevin Gilchrist" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Monday, January 22,

RE: Why doe my cfscript if statement fail?

2001-01-22 Thread Philip Arnold - ASP
I'm trying to find why this if condition keeps getting evaluated as true when it shouldn't. I've traced through the debugger to track the value of the if condition and even though the record count condition comes up as 0 when I put a watch on it, it still executes. I added a CFOUTPUT