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]
