RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Scott Thornton
Hello, Thanks for all replies. An update of my local dev server to 9,0,1,274733 appears to have solved the problem. From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Scott Thornton Sent: Friday, 1 October 2010 10:29 AM To: cfaussie@googlegroups.com Subject: RE:

RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Steve Onnis
If a simple query works i would be taking stuff out stripping stuff out of the query and seeing what is making it not return anything and i would be starting with the HAVING clause. It is possible that there is something in there that is making it not return anything. Out of curiosity, what hap

RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Scott Thornton
HI All, 1. What happens if you try CFDUMP instead right after the query? using returns Variable FIX_THIS is undefined. 2. re recordcount gt 0. I didn't know that, thanks. 3. Why the cfoutput? The original code used cfloop, I tried using cfoutput as well. Typically cfloop would be used.

Re: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Brett Payne-Rhodes
Maybe you also have "fix_this" defined in a different scope? B) On 1/10/2010 7:35 AM, Scott Thornton wrote: Hi, Running across a odd problem in CF 9,0,0,251028. development server. I was just running a process that usually works and has not been modified for quite a long time. part of that

RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Cassie Woolley
There is a SQLServer DateAdd function that I think it is using http://www.w3schools.com/sql/func_dateadd.asp From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Mark Ireland Sent: Friday, 1 October 2010 10:16 AM To: cfaussie@googlegroups.com Subject: [cfaussie] S

[cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Mark Ireland
#DateAdd(d,30,max(sb_claim_date))# From: cas...@bluerocksoftware.com To: cfaussie@googlegroups.com Subject: RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query Date: Fri, 1 Oct 2010 09:53:07 +1000 I had this exact same problem a few months ago. Unfortuna

RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Cassie Woolley
I had this exact same problem a few months ago. Unfortunately I can't remember exactly what the problem was but I do remember it was a smack myself in the head kind of answer. I have a feeling that even though the query was appearing to run OK, there was actually an issue with it that meant it wa

RE: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Andrew Scott
Not sure why you are getting that error, but there are a few things I will ask why? Mainly for others who might be newer to ColdFusion and reading this. This Can be written Any number above zero will always return true. Also this You are not actual

Re: [cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread m...@ampersand.net.au
What happens if you try CFDUMP instead right after the query? On 1/10/2010 9:35 AM, Scott Thornton wrote: Hi,   Running across a odd problem in CF 9,0,0,251028. development server.  

[cfaussie] Strange problem - Element RECORDCOUNT is undefined in query

2010-09-30 Thread Scott Thornton
Hi, Running across a odd problem in CF 9,0,0,251028. development server. I was just running a process that usually works and has not been modified for quite a long time. part of that process runs a query and then loops over the result set. Simple enough... however the query does not seem to exi