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