Erm, prob not.
> -----Original Message----- > From: James Buckingham [mailto:[EMAIL PROTECTED] > Sent: 13 May 2004 12:32 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] [Microsoft][ODBC Microsoft Access > Driver] Too few parameters. Exp ected 1. error on CF 5.0 > > > 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] > > -- 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]
