Try this. Some of our customers use this to get better dubug outlut on the live server where debug is disabled.
http://www.rewindlife.com/archives/000135.cfm Russ Michaels Macromedia Certified ColdFusion Professional CFMX Hosting - Macromedia ColdFusionMX Hosting Phone: 0845 456 3487 Tech Support: 0906 9607800 FAX: 0709 2212 636 WEB: www.cfmxhosting.co.uk Helpdesk: www.cfmxhosting.co.uk/helpdesk ---------------------------------------------------------------------------- ----------------------- Please use the support helpdesk on our web site to submit support tickets. Join our ColdFusion Developer discussion lists and forums at www.cfdeveloper.co.uk. ---------------------------------------------------------------------------- ----------------------- > -----Original Message----- > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > Sent: 13 May 2004 08:42 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Exp ected 1. error on CF 5.0 > > > > can you ask your hosts to add your IP address in CF Admin and > have debug output just for you? > > Not sure if this is possible for multiple site hosts - Russ > may be able to answer that? I know I can put debug on from > cfdeveloper but then everybody gets it!? > > _______________________________________________________ > Regards, > Richard Lovelock > Senior Application Analyst > > Westminster City Council - Web Support > Capgemini UK > Southbank > 95 Wandsworth Road > London > SW8 2HG > Tel: 0870 906 7482 > > > -----Original Message----- > From: James Buckingham [mailto:[EMAIL PROTECTED] > Sent: 12 May 2004 16:46 > To: 'Lovelock, Richard J' > Subject: RE: [ cf-dev ] [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Exp ected 1. error on CF 5.0 > > > It's live so I can't get the debug information. I might put a > request into our hosting asking for the debug to be switch on though. > > Cheers for your help guys, > James > > -----Original Message----- > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > Sent: 12 May 2004 16:16 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Exp ected 1. error on CF 5.0 > > > is this in a live environment? or dev? > > can you add your IP address to the Debugging settings in CF > Administrator - should then give you debug output with all SQL no? > > _______________________________________________________ > Regards, > Richard Lovelock > Senior Application Analyst > > Westminster City Council - Web Support > Capgemini UK > Southbank > 95 Wandsworth Road > London > SW8 2HG > Tel: 0870 906 7482 > > > -----Original Message----- > From: James Buckingham [mailto:[EMAIL PROTECTED] > Sent: 12 May 2004 16:13 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Exp ected 1. error on CF 5.0 > > > Sorry how do I do that? > > -----Original Message----- > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > Sent: 12 May 2004 16:06 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Exp ected 1. error on CF 5.0 > > > can you get the exact SQL from debug info? > > _______________________________________________________ > Regards, > Richard Lovelock > Senior Application Analyst > > Westminster City Council - Web Support > Capgemini UK > Southbank > 95 Wandsworth Road > London > SW8 2HG > Tel: 0870 906 7482 > > > -----Original Message----- > From: James Buckingham [mailto:[EMAIL PROTECTED] > Sent: 12 May 2004 16:08 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Exp ected 1. error on CF 5.0 > > > There isn't any SQL being shown in the error just what I > posted in my original message unfortunately. > > Also, the only mention of any page reference was the document > position (2:1) to (2:47). I'm not to sure what that's > referring to as the query starts on line 3 and finishes on line 28 :(. > > -----Original Message----- > From: Stephen Moretti [mailto:[EMAIL PROTECTED] > Sent: 12 May 2004 15:45 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Exp ected 1. error on CF 5.0 > > James, > > >I've been puzzling away at this one all morning but no matter how I > >look at it I can't seem to nail what's causing the following error > >message: > > > >Error Diagnostic Information > >ODBC Error Code = 07001 (Wrong number of parameters) > > > >[Microsoft][ODBC Microsoft Access Driver] Too few > parameters. Expected > >1. > > > >The error occurred while processing an element with a general > >identifier of (CFQUERY), occupying document position (2:1) to (2:47). > > > > > > > What is the SQL thats actually being generated and shown in > the error message, also CF5 and CFMX usually highlight one > particular line in your code that it thinks is unhappy, which > line is that? > > Regards > > Stephen > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > Our name has changed. Please update your address book to the > following > format: "[EMAIL PROTECTED]". > > This message contains information that may be privileged or > confidential and is the property of the Capgemini Group. It > is intended only for the person to whom it is addressed. If > you are not the intended recipient, you are not authorized > to read, print, retain, copy, disseminate, distribute, or > use this message or any part thereof. If you receive this > message in error, please notify the sender immediately and > delete all copies of this message. > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > Our name has changed. Please update your address book to the > following > format: "[EMAIL PROTECTED]". > > This message contains information that may be privileged or > confidential and is the property of the Capgemini Group. It > is intended only for the person to whom it is addressed. If > you are not the intended recipient, you are not authorized > to read, print, retain, copy, disseminate, distribute, or > use this message or any part thereof. If you receive this > message in error, please notify the sender immediately and > delete all copies of this message. > > > Our name has changed. Please update your address book to the > following format: "[EMAIL PROTECTED]". > > This message contains information that may be privileged or > confidential and is the property of the Capgemini Group. It > is intended only for the person to whom it is addressed. If > you are not the intended recipient, you are not authorized > to read, print, retain, copy, disseminate, distribute, or > use this message or any part thereof. If you receive this > message in error, please notify the sender immediately and > delete all copies of this message. > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
