I did have one case of that. One. And it was an empty field cuasing the problem.
Here its just query... sql server runs the query just fine.. its when its between cfquery that it causes a problem. On Tue, 15 Feb 2005 15:17:11 +0800, James Holmes <[EMAIL PROTECTED]> wrote: > Actually I've seen (and corrected) code that does it too. In my case it was > due to DB data that contained NULLs where it shouldn't. In all cases, the > error was between the keyboard and the chair, not in CF. > > -----Original Message----- > From: Tony Hicks [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 15 February 2005 3:12 > To: CF-Talk > Subject: Null Null > > I've finally found good resources on NULL NULL error, that at least tells me > what it is.. still not helpful, but I know that its not code that causes it > but generally one of various bugs in cf or java memory issues. > > I've heard somewhere that blackstone users are seeing this too? I run a > growing site of decent size right now and I see this error too much as it > is.. and that's just once or twice every two days. But I ran I very massive > site on CF 5 a year or so ago that never saw this kind of error and that > site (a project I took over) had slow clunky code. > Rather than using cfoutput grouping like... > > <cfoutput....> > Header > <cfoutput group="thing"> > Item > </cfoutput> > </cfoutput> > > It had many cases of > > <cfset saveheader=""> > <cfoutput...> > <cfif header is not saveheader><cfset saveheader=header>Header</cfif> > Item > </cfoutput> > > Only.. much larger.. that's a quick sample.. anyway so to get back on track, > if I wasn't seeing this on CF 5 with bad code, I'm upset (as a lot of > developers are) that I _still_ get this on carefully honed code. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194769 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
