>- 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%2Fblog> > ---------------------------------------------------------------------- > > > 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.cfmxhosting.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 -<
