>- see footer for list info -< Good point, Kev. Lee, it seems reasonable that you had an error that went into the CFCATCH, but because you were catching only a certain type, it wasn't that type, so no catch happened, so that when you went to the isquery (or your original code), there was no procresult because something had failed.
Beyond that, I'll note that your CFCATCH doesn't terminate the request. Many don't realize that processing continues after the CFCATCH (because its goal is to let you catch and even ignore any error). So be aware that even if you HAD caught it, you would have shown your error but then proceeded to return to the code and that too could have caused the problem you're seeing (code failing because the procresult didn't exist). As for the output you show (in the pastebin file of when the error happens), I see that that has represents some sort of custom error handling, as it says, "The following information is meant for the website developer for debugging purposes". Are you assuming that that comes from the CFCATCH? I would think not (given what Kev notes and the fact that it fails due to your line 79 which is NOT a database error). I would bet that that error handling is from someplace else. Do you have an application-level CFERROR tag, either in your application.cfm or that may be set in the framework? /charlie > -----Original Message----- > From: [email protected] [mailto:dev- > [email protected]] On Behalf Of Kev McCabe > Sent: Friday, August 27, 2010 8:10 AM > To: [email protected] > Cc: CFML Development > Subject: Re: Re: RE: Re: [CF-Dev] Weird Database connectivity issue > > >- see footer for list info -< > So you're using a Stored Proc? > > Before the store proc on line 74 can out dump out the variables so that you > can call: > > The Stored Proc spr_#SP_name#APPM8_GET_CLIENT_DETAILS > > with the in variable URL with the value of > #HTTP.host##REPLACE(CGI.path_info,"/index.cfm","")# > > As I think this is an issue with your SP not returning a record set > > in addition your cfcatch only has database and not an ALL as a failure for > your code (i.e. SP not returning back a query but this isn't a Database > Error so that catch doesn't get it) > > So to clean up the error the user gets I'd suggest a CFCATCH ="ANY" and then > handle the display there. > > HTH > > ---------------------------------------------------------------------- > [ ] internal [ ] private [X] ask first [ ] bloggable > ---------------------------------------------------------------------- > Kev McCabe > Adobe Community Professional - ColdFusion > UK ColdFusion User Group Manager > tel: +44 7751 230 725 > email: [email protected] > skype: bigmadkev > blog: http://bigmadkev.com/blog > ---------------------------------------------------------------------- > > > On 27 August 2010 10:26, <[email protected]> wrote: > > > > > Hi Kev and all, > > > > Text when viewing the page is here: http://pastebin.com/fQmH46zJ > > > > Code of the page itself is as follows: http://pastebin.com/bBhs1sCV > > > > Any help is hugely appreciated, I am going MAD!!! > > > > Lee > > > > > > On Fri 27/08/10 9:04 AM , Kev McCabe [email protected] sent: > > > > >- see footer for list info -< > > Lee, > > > > Are you able to post the whole page into pastebin.com so we can view it > > Fully to see what we may all spy? ;) > > > > Cheers > > ---------------------------------------------------------------------- > > [ ] internal [ ] private [X] ask first [ ] bloggable > > ---------------------------------------------------------------------- > > Kev McCabe > > Adobe Community Professional - ColdFusion > > UK ColdFusion User Group Manager > > tel: +44 7751 230 725 > > email: [email protected] > > skype: bigmadkev > > blog: > http://bigmadkev.com/blog<http://parse.php?redirect=http%3A%2F%2Fbigmadkev.com%2 > Fblog> > > ---------------------------------------------------------------------- > > > > > > On 27 August 2010 08:19, <[email protected]> wrote: > > > > > >- see footer for list info -< > > > BODY { font-family:Arial, Helvetica, sans-serif;font-size:12px; }Hi > > > Charlie, > > > Thanks for your input. I have copied the relevant code from the page > > > below. The inclusion of the 'IsQuery' line was from Adrian, as you can > > > see, the call to the DB is made and then the IsQuery and RecordCount > > > statements. > > > The reason multiple files are being called and processed is that is > > > it built on the old fusebox 3 / 4 framework. > > > At the moment the error is persistent and has now been present for > > > about 3 or 4 days. This is on a production server and my client is > > > none to amused :-( > > > Regards, > > > Lee > > > #IsQuery(res_APPM8_GET_CLIENT_DETAILS)# > > > On Thu 26/08/10 2:17 PM , "charlie arehart" > > > [email protected] sent: > > > >- see footer for list info - -----Original Message----- > > > > From: [mailto:dev- > > > > ] On Behalf Of > > > > Sent: Tuesday, August 24, 2010 3:31 PM > > > > To: ; 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 > > > > http://www.appointmentm8.com%2Fsolihullcaretrust";> > > 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<http://parse.php?redirect=http%3A > %2F%2Flist.cfdeveloper.co.uk%2Fmailman%2Flistinfo> > > > -- > > > CFDeveloper Sponsors:- > > > >- cfdeveloper Hosting provided by http://www.cfmxhosting.co.uk";> > > www.cfmxhosting.co.uk -- Lists > > > hosted by http://www.Gradwell.com";>www.Gradwell.com -- CFdeveloper is > > run by Russ Michaels, > > > > > feel free to volunteer your help - > > > > > > Links: > > > ------ > > > [5] > http://www.appointmentm8.com%2Fsolihullcaretrust<http://parse.php?redirect=http% > 3A%2F%2Fwww.appointmentm8.com%252Fsolihullcaretrust> > > > [6] > http://www.cfmxhosting.co.uk<http://parse.php?redirect=http%3A%2F%2Fwww.cfmxhost > ing.co.uk> > > > [7] > http://www.Gradwell.com<http://parse.php?redirect=http%3A%2F%2Fwww.Gradwell.com> > > > _______________________________________________ > > > > > > For details on ALL mailing lists and for joining or leaving lists, go to > > > > http://list.cfdeveloper.co.uk/mailman/listinfo<http://parse.php?redirect=http%3A > %2F%2Flist.cfdeveloper.co.uk%2Fmailman%2Flistinfo> > > > > > > -- > > > CFDeveloper Sponsors:- > > > >- cfdeveloper Hosting provided by http://www.cfmxhosting.co.uk";> > > www.cfmxhosting.co.uk -< > > > >- Lists hosted by http://www.Gradwell.com";>www.Gradwell.com -< > > > > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help > > -< > > > > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, go to > > > http://list.cfdeveloper.co.uk/mailman/listinfo<http://parse.php?redirect=http%3A > %2F%2Flist.cfdeveloper.co.uk%2Fmailman%2Flistinfo> > > > > -- > > CFDeveloper Sponsors:- > > >- cfdeveloper Hosting provided by http://www.cfmxhosting.co.uk";> > > www.cfmxhosting.co.uk -< > > >- Lists hosted by http://www.Gradwell.com";>www.Gradwell.com -< > > > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -< > > > > > > > _______________________________________________ > > 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 -< _______________________________________________ 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 -<
