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]
