Will that work on CF5.0? -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 13 May 2004 12:22 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Exp ected 1. error on CF 5.0
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] -- 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]
