- 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 -<
