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

2016-11-03 Thread Mike K
I wonder why it suddenly appeared in the mailbox then? I admit i didnt even look at the date. Cheers Mike Kear On Fri, Nov 4, 2016 at 9:05 AM, Scott Thornton < scott.thorn...@hnehealth.nsw.gov.au> wrote: > HI Guys, > > > > That post was from 2010! > > > > *From:* cfaussie@googlegroups.com

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

2016-11-03 Thread Peter Tilbrook
​​ Wouldn't it be better to use StructKeyExists(QueryName, RecordCount)? == Peter Tilbrook Professional Adobe ColdFusion 2016 and Microsoft SQL Server Application Development Managing Director, ColdGen Internet Solutions Web Administrator, The Club Group Pty Ltd PO Box 2247 Queanbeyan, NSW, 2620 A

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

2016-11-03 Thread Scott Thornton
HI Guys, That post was from 2010! From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Mike K Sent: Friday, 4 November 2016 8:21 AM To: cfaussie Subject: Re: [cfaussie] Re: Strange problem - Element RECORDCOUNT is undefined in query Have you run the query in your dat

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

2016-11-03 Thread Mike K
Have you run the query in your database to be certain it actually should return some rows? And that there's no syntax errors or anything like that in the query itself? It's possible that your CFQuery is correctly returning no rows. Cheers, Mike Kear Windsor, NSW, Australia AFP Webworks.

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

2016-11-03 Thread Hanswurst Globobrüll
I had exactly the same problem in CF8, CF9 und also CF11. Out team was analyzing and examining for days (!) - because the problem was not repleatable on purpose. It just occured sometimes and we found evidence in log files. and finally we found out that the problem is the database. we use mysql,