>- see footer for list info -<
Charlie,
IIRC "The following information is meant for the website developer for
debugging purposes" Is Standard CF Error Message. (I guess it's been a while
both of us have seen one with all the custom error messages we build in our
systems ;) )
If the variable RES_APPM8_GET_CLIENT_DETAILS isn't set from the SP I would
set it to start with, with a cfset RES_APPM8_GET_CLIENT_DETAILS =
queryNew('') but I have a feeling that the SP will overwrite this with
whatever comes out the SP, which may of been changed? What is the DB MySql /
MSSQL?
----------------------------------------------------------------------
[ ] 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 16:37, charlie arehart <[email protected]> wrote:
> >- 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 -<
>
_______________________________________________
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 -<
