>- see footer for list info -< Shawn, I suspect the access driver doesn't support that function, you might want to try rewriting the coding using a standard MAX() function instead.
If you really want to use DMAX, then you can write a stored query in your access db, and call that instead. Russ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Fawcett Sent: 29 March 2006 10:12 To: Coldfusion Development Subject: Re: [CF-Dev] Dmax in cfquery >- see footer for list info -< here you go Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3. The error occurred in D:\wwwroot\ablydev.com\wwwroot\dsp_home_cover_french.cfm: line 200 Called from D:\wwwroot\ablydev.com\wwwroot\dsp_home.cfm: line 9 Called from D:\wwwroot\ablydev.com\wwwroot\pagemaster.cfm: line 11 Called from D:\wwwroot\ablydev.com\wwwroot\index.cfm: line 134 Called from D:\wwwroot\ablydev.com\wwwroot\dsp_home_cover_french.cfm: line 200 Called from D:\wwwroot\ablydev.com\wwwroot\dsp_home.cfm: line 9 Called from D:\wwwroot\ablydev.com\wwwroot\pagemaster.cfm: line 11 Called from D:\wwwroot\ablydev.com\wwwroot\index.cfm: line 134 198 : "> 199 : 200 : <cfquery name="q_LatestDate" datasource="#application.DS#" username="#application.dbuser#" password="#application.dbpass#"> 201 : SELECT tblDailyRates.CurrencyRateDate AS aaa 202 : FROM tblDailyRates SQL SELECT tblDailyRates.CurrencyRateDate AS aaa FROM tblDailyRates WHERE tblDailyRates.CurrencyRateDate = DMax("CurrencyRateDate","tblDailyRates") DATASOURCE araxi VENDORERRORCODE -3010 SQLSTATE 07002 At 13:41 28/03/2006, you wrote: > >- see footer for list info -< >can you post the actual sql reported in the error please? > >On 3/28/06, Shawn Fawcett <[EMAIL PROTECTED]> wrote: > > > > >- see footer for list info -< > > > > works in access but when I insert in cfquery I get an error of too > > few parameters > > > > <cfquery name="q_LatestDate" > > datasource="#application.DS#" > > username="#application.dbuser#" password="#application.dbpass#"> > > SELECT tblDailyRates.CurrencyRateDate AS aaa FROM tblDailyRates > > WHERE (((tblDailyRates.CurrencyRateDate > > )=DMax("CurrencyRateDate","tblDailyRates"))); > > </cfquery> > > > > > > > > > > ARAXI Traductions France > > 100 Passage Henri Régnault - 92400 Courbevoie La Défense 6 Tél. : 01 > > 49 03 41 49 - Fax : 01 49 03 41 42 > > _______________________________________________ > > > > For details on ALL mailing lists and for joining or leaving lists, > > go to http://list.cfdeveloper.co.uk/mailman/listinfo > > > > -- > > CFDeveloper Sponsors:- > > >- Hosting provided by www.cfmxhosting.co.uk -< > > >- Forum provided by www.fusetalk.com -< > > >- DHTML Menus provided by www.APYCOM.com -< > > >- Lists hosted by www.Gradwell.com -< > > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > > >help > > -< > > > > > >-- >Mike T >Blog http://www.socialpoints.com/ >_______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go >to http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- > >- Hosting provided by www.cfmxhosting.co.uk -< > >- Forum provided by www.fusetalk.com -< > >- DHTML Menus provided by www.APYCOM.com -< > >- Lists hosted by www.Gradwell.com -< > >- CFdeveloper is run by Russ Michaels, feel free to volunteer your > >help -< ARAXI Traductions France 100 Passage Henri Régnault - 92400 Courbevoie La Défense 6 Tél. : 01 49 03 41 49 - Fax : 01 49 03 41 42 _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- Hosting provided by www.cfmxhosting.co.uk -< >- Forum provided by www.fusetalk.com -< >- DHTML Menus provided by www.APYCOM.com -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
