>- see footer for list info -< Lee, such challenges can of course be frustrating, but there's always an explanation for what's going on. You just need to find out what's happening, where.
For your challenge, I would start by dropping that test code right after the CFQUERY. It's not clear from the below if that's what you're doing, or perhaps you're doing it in some later code (or perhaps another file, as your debug output shows a few files involved in processing the current request.) It would be interesting to see if the test for the variable would perhaps be true right after the query, but not later. You said in the first note that it was that the recordcount variable was undefined, but now you're showing that the query variable itself is undefined, which is why it seems useful to confirm if that happens "right after" the cfquery, which would be odd, or if it shows up right after but then is gone later (which would have a different explanation). If the problem is that it happens sometimes, but not others, and you needed to run this in production but didn't want this testing output to show up to users, then of course you could use CFLOG to track it instead. Just something else to consider as you tackle this. /charlie > -----Original Message----- > From: [email protected] [mailto:dev- > [email protected]] On Behalf Of [email protected] > Sent: Tuesday, August 24, 2010 3:31 PM > To: [email protected]; CFML Development; Adrian Lynch > Subject: Re: Re: [CF-Dev] Weird Database connectivity issue > > >- see footer for list info -< > BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px; > }Thanks Adrian. > Did that, result below, this is all wrapped in a cftry and there is > nothing being complained about in terms of DB errors > Code in page > #IsQuery(res_APPM8_GET_CLIENT_DETAILS)# > Result > Variable RES_APPM8_GET_CLIENT_DETAILS is undefined > DEBUG reports > Stored Procedures spr_APPM8_GET_CLIENT_DETAILS (Datasource=d8m8, > Time=0ms) in D:wwwroot_CFMX10120appointmentm8.comwwwrootmyGlobals.cfm > @ 20:32:43.043 > parameters > type > CFSQLType > value > variable > dbVarName > IN > CF_SQL_VARCHAR > www.appointmentm8.com/solihullcaretrust > resultsets > name > resultset > res_APPM8_GET_CLIENT_DETAILS > 1 > Have to say this is proving really frustrating :-( > Lee _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
